[JBoss JIRA] (TEIID-4518) Add support for JDG 7.1
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4518?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4518:
------------------------------------
In order for Teiid JDG resource-adapter to connect to a JDG cache, the following will be needed:
1. the username/password needs to be configured in JDG to have permission role, "__schema_manager", which is required of the user attempting to WRITE to the '__protobuf_metadata' cache when the JDG schema is configured by the resource-adapter.
2. this username/password would be configured on the JDG resource-adapter (these need to be added to the resource-adapter).
Because this is like a one-time administrative task in JDG resource-adapter, there's no option for trying to use pass-thru credentials.
> Add support for JDG 7.1
> -----------------------
>
> Key: TEIID-4518
> URL: https://issues.jboss.org/browse/TEIID-4518
> Project: Teiid
> Issue Type: Enhancement
> Components: JDG Connector
> Affects Versions: 8.12.7.6_3
> Reporter: Van Halbert
> Assignee: Van Halbert
> Fix For: 9.2
>
>
> The JDG 7.1 modules need to be added as dependencies in the infinispan translator and connector module.xml files.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4567) UCASE and LCASE functions do not work with CLOBs.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4567?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4567.
-----------------------------------
Fix Version/s: 9.2
Assignee: Steven Hawkins
Resolution: Done
Added upper/lower clob handling off of the underlying reader stream.
> UCASE and LCASE functions do not work with CLOBs.
> --------------------------------------------------
>
> Key: TEIID-4567
> URL: https://issues.jboss.org/browse/TEIID-4567
> Project: Teiid
> Issue Type: Enhancement
> Components: Common
> Affects Versions: 8.0
> Environment: In any Environment
> Reporter: sameer P
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> With the fresh Server, without adding any datasource, if I run the query :
> {code:sql}
> select lcase(convert('A', clob))
> {code} ,
> It gives the following exception:
> {code:sql}
> org.teiid.jdbc.TeiidSQLException: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lcase(?): TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:723)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:65)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:561)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:284)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:322)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy1.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:421)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:570)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:423)
> at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)
> at DVConnection.main(DVConnection.java:110)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lcase(?): TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
> at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:477)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30341 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1389)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:756)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
> ... 18 more
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30341 Remote org.teiid.api.exception.query.FunctionExecutionException: TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluatePushdown(SubqueryAwareEvaluator.java:438)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1387)
> ... 20 more
> Exception in thread "main" org.teiid.jdbc.TeiidSQLException: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lcase(?): TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:723)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:65)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:561)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:284)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:322)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy1.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:421)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:570)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:423)
> at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)
> at DVConnection.main(DVConnection.java:110)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lcase(?): TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:728)
> at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:194)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:169)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:477)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30341 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1389)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:756)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
> ... 18 more
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30341 Remote org.teiid.api.exception.query.FunctionExecutionException: TEIID30341 Function lcase is marked in the function metadata as a function that must be evaluated at the source.
> at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluatePushdown(SubqueryAwareEvaluator.java:438)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1387)
> ... 20 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4700) Google translator inconsistent behavior for DELETE and SELECT for null values
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4700?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4700.
-----------------------------------
Fix Version/s: 9.2
9.1.3
Resolution: Done
Yes the doc note is for the Teiid side.
The change should address null handling in more scenarios - but there are some circumstances that we cannot do anything about, such as
delete ... where col = ''
That would affect rows with both empty strings and null values.
> Google translator inconsistent behavior for DELETE and SELECT for null values
> -----------------------------------------------------------------------------
>
> Key: TEIID-4700
> URL: https://issues.jboss.org/browse/TEIID-4700
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.2
> Environment: 9.2.0.Alpha2
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Fix For: 9.2, 9.1.3
>
>
> In teiid I observed following inconsistent behavior:
> Q1: select intnum, intkey from smalla where intnum > -10 AND intnum < 20
> Q2: delete from smalla where intnum > -10 AND intnum < 20
> Q1 returns rows without null values for intnum, but Q2 deletes also rows with null values for intnum.
> I observed that if I remove the lower boundary (ie. Q3: select intnum, intkey from smalla where intnum < 20 and similarly for delete), both selected and deleted rows contain null values, so the result is consistent.
> The server.log is empty, so I didn't attach it...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4700) Google translator inconsistent behavior for DELETE and SELECT for null values
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIID-4700?page=com.atlassian.jira.plugin... ]
Lucie Fabrikova commented on TEIID-4700:
----------------------------------------
Could this be added to documentation of teiid, as it concerns the google translator? (even though it is caused by google spreadsheet behavior...)
> Google translator inconsistent behavior for DELETE and SELECT for null values
> -----------------------------------------------------------------------------
>
> Key: TEIID-4700
> URL: https://issues.jboss.org/browse/TEIID-4700
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.2
> Environment: 9.2.0.Alpha2
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
>
> In teiid I observed following inconsistent behavior:
> Q1: select intnum, intkey from smalla where intnum > -10 AND intnum < 20
> Q2: delete from smalla where intnum > -10 AND intnum < 20
> Q1 returns rows without null values for intnum, but Q2 deletes also rows with null values for intnum.
> I observed that if I remove the lower boundary (ie. Q3: select intnum, intkey from smalla where intnum < 20 and similarly for delete), both selected and deleted rows contain null values, so the result is consistent.
> The server.log is empty, so I didn't attach it...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4683) PrestoDB translator - dayof* functions not translated correctly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4683?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4683.
-----------------------------------
Fix Version/s: 9.2
(was: 9.2.1)
Resolution: Done
Merged the pull request. Thanks Kylin.
> PrestoDB translator - dayof* functions not translated correctly
> ---------------------------------------------------------------
>
> Key: TEIID-4683
> URL: https://issues.jboss.org/browse/TEIID-4683
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
> Fix For: 9.2
>
>
> Teiid pushes functions *dayofmonth*, *dayofweek* and *dayofyear* directly to PrestoDB. Functions in PrestoDB have different name - see [doc|https://prestodb.io/docs/current/functions/datetime.html].
> {code:sql|title=Query}
> SELECT IntKey, DAYOFMONTH(datevalue) AS DayFromDate FROM BQT1.SmallA
> {code}
> {code:sql|title=Source command}
> SELECT g_0.intkey, dayofmonth(g_0.datevalue) FROM smalla AS g_0
> {code}
> {code:plain|title=Exception}
> 14:33:10,897 WARN [org.teiid.CONNECTOR] (Worker28_QueryProcessorQueue137) Connector worker process failed for atomic-request=A7WqBzZhsyYM.48.0.32: org.teiid.translator.jdbc.JDBCExecutionException: 1 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, dayofmonth(g_0.datevalue) FROM smalla AS g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
> at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) [:1.8.0_92]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy48.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> Caused by: java.sql.SQLException: Query failed (#20170106_133310_04116_k4ss5): line 1:20: Function dayofmonth not registered
> at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799)
> at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1747)
> at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:125)
> at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:212)
> at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69)
> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> ... 17 more
> Caused by: com.facebook.presto.sql.analyzer.SemanticException: line 1:20: Function dayofmonth not registered
> at com.facebook.presto.sql.analyzer.ExpressionAnalyzer$Visitor.visitFunctionCall(ExpressionAnalyzer.java:823)
> at com.facebook.presto.sql.analyzer.ExpressionAnalyzer$Visitor.visitFunctionCall(ExpressionAnalyzer.java:254)
> at com.facebook.presto.sql.tree.FunctionCall.accept(FunctionCall.java:109)
> at com.facebook.presto.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:26)
> at com.facebook.presto.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:273)
> at com.facebook.presto.sql.analyzer.ExpressionAnalyzer.analyze(ExpressionAnalyzer.java:230)
> at com.facebook.presto.sql.analyzer.ExpressionAnalyzer.analyzeExpression(ExpressionAnalyzer.java:1416)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.analyzeExpression(StatementAnalyzer.java:1791)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.analyzeSelect(StatementAnalyzer.java:1613)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:785)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuerySpecification(StatementAnalyzer.java:187)
> at com.facebook.presto.sql.tree.QuerySpecification.accept(QuerySpecification.java:125)
> at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:549)
> at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitQuery(StatementAnalyzer.java:187)
> at com.facebook.presto.sql.tree.Query.accept(Query.java:92)
> at com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:27)
> at com.facebook.presto.sql.analyzer.Analyzer.analyze(Analyzer.java:67)
> at com.facebook.presto.sql.analyzer.Analyzer.analyze(Analyzer.java:59)
> at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:285)
> at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:271)
> at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:229)
> at com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)
> ... 3 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4677) PrestoDB translator - date/time/timestamp values are pushed in Teiid's format ({d/t/ts '...'})
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4677?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4677.
-----------------------------------
Fix Version/s: 9.2
(was: 9.2.1)
Resolution: Done
Merged the pull request and updated the logic to use value directly.
> PrestoDB translator - date/time/timestamp values are pushed in Teiid's format ({d/t/ts '...'})
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-4677
> URL: https://issues.jboss.org/browse/TEIID-4677
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
> Fix For: 9.2
>
>
> Teiid pushes date/time/timestamp values in format *\{d/t/ts '...'\}* to PrestoDB. This is not proper format for PrestoDB. Query \[1\], source-specific command \[2\], exception \[3\].
> {code:sql|title=\[1\]}
> SELECT intkey FROM bqt1.smalla WHERE datevalue = cast('2012-01-01' as date)
> {code}
> {code:sql|title=\[2\]}
> SELECT g_0.intkey FROM smalla AS g_0 WHERE g_0.datevalue = {d '2012-01-01'}
> {code}
> {code:plain|title=\[3\]}
> 12:25:40,369 WARN [org.teiid.CONNECTOR] (Worker9_QueryProcessorQueue51) Connector worker process failed for atomic-request=A7WqBzZhsyYM.11.0.10: org.teiid.translator.jdbc.JDBCExecutionException: 1 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey FROM smalla AS g_0 WHERE g_0.datevalue = {d '2012-01-01'}]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_92]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_92]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy48.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> Caused by: java.sql.SQLException: Query failed (#20170106_112540_04080_k4ss5): line 1:60: no viable alternative at input '= {'
> at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799)
> at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:209)
> at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69)
> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> ... 18 more
> Caused by: com.facebook.presto.sql.parser.ParsingException: line 1:60: no viable alternative at input '= {'
> at com.facebook.presto.sql.parser.SqlParser$1.syntaxError(SqlParser.java:45)
> at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:65)
> at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:566)
> at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:308)
> at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:145)
> at com.facebook.presto.sql.parser.SqlBaseParser.predicate(SqlBaseParser.java:6378)
> at com.facebook.presto.sql.parser.SqlBaseParser.predicated(SqlBaseParser.java:5961)
> at com.facebook.presto.sql.parser.SqlBaseParser.booleanExpression(SqlBaseParser.java:5858)
> at com.facebook.presto.sql.parser.SqlBaseParser.querySpecification(SqlBaseParser.java:3773)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryPrimary(SqlBaseParser.java:3494)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryTerm(SqlBaseParser.java:3306)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryNoWith(SqlBaseParser.java:3162)
> at com.facebook.presto.sql.parser.SqlBaseParser.query(SqlBaseParser.java:2634)
> at com.facebook.presto.sql.parser.SqlBaseParser.statement(SqlBaseParser.java:1294)
> at com.facebook.presto.sql.parser.SqlBaseParser.singleStatement(SqlBaseParser.java:231)
> at com.facebook.presto.sql.parser.SqlParser.invokeParser(SqlParser.java:92)
> at com.facebook.presto.sql.parser.SqlParser.createStatement(SqlParser.java:65)
> at com.facebook.presto.execution.SqlQueryManager.createQuery(SqlQueryManager.java:289)
> at com.facebook.presto.server.StatementResource$Query.<init>(StatementResource.java:309)
> at com.facebook.presto.server.StatementResource.createQuery(StatementResource.java:172)
> at sun.reflect.GeneratedMethodAccessor474.invoke(Unknown Source) [:1.8.0_92]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
> at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
> at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
> at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
> at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
> at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
> at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
> at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
> at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689)
> at io.airlift.http.server.TraceTokenFilter.doFilter(TraceTokenFilter.java:63)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
> at io.airlift.http.server.TimingFilter.doFilter(TimingFilter.java:52)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
> at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:395)
> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1182)
> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
> at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
> at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)
> at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> at org.eclipse.jetty.server.Server.handle(Server.java:523)
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
> at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
> at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
> ... 1 more
> Caused by: org.antlr.v4.runtime.NoViableAltException
> at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:1886)
> at org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:486)
> at org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:412)
> at com.facebook.presto.sql.parser.SqlBaseParser.predicate(SqlBaseParser.java:6190)
> ... 68 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4325) ASSERTION FAILED: expected reference to be not null
by Tom Chen (JIRA)
[ https://issues.jboss.org/browse/TEIID-4325?page=com.atlassian.jira.plugin... ]
Tom Chen commented on TEIID-4325:
---------------------------------
Thank you for the clarification. I will discuss this issue with our developers to see how to proceed. We planed to use teiid 9.1 in our next product release but our user cannot wait until then. Have a good weekend!
> ASSERTION FAILED: expected reference to be not null
> ---------------------------------------------------
>
> Key: TEIID-4325
> URL: https://issues.jboss.org/browse/TEIID-4325
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1, 9.0.2, 8.13.7, 8.12.6.6_3
>
> Attachments: show_plan_debug.txt
>
>
> I'm using teiid 9.0.0 over h2 :
>
> I'm getting ASSERTION_FAILED over the following query and can not find what is causing this exception:
>
> select "Sheet1"."AvgAmoutRange" as "Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as "CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID" as "CEGlobalView_Customer_Gender1","Gender"."Gender" as "Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as "Sheet1_EBt_211215_Sheet1_EBt11" from "CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT JOIN "h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215" "Sheet1" ON ( ("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN "Sheet1"."Min" and "Sheet1"."Max") )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender" "Gender" ON "CEGlobalView"."Customer_GenderID" = "Gender"."GenderID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag" "CustomerTag" ON "CEGlobalView"."Customer_CustomerID" = "CustomerTag"."Customer_CustomerID" AND ( ( ("CustomerTag"."EndDateTime" > CURDATE()) OR ( ("CustomerTag"."EndDateTime" IS null ) ) ) )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue" "TagValue" ON "CustomerTag"."TagValue_TagValueID" = "TagValue"."TagValueID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName" "TagName" ON "TagValue"."TagName_TagNameID" = "TagName"."TagNameID" AND ( ( ("TagName"."TagType_TagTypeID" IN (1.0) ) ) AND ( ("TagName"."TagScope_TagScopeID" IN (1.0) ) ) )
> where ( ( ( ("TagName"."TagName" IN ('Behavior') ) ) ) AND ( ("Sheet1"."AvgAmoutRange" IS NOT null ) ) AND ( ("CEGlobalView"."Customer_GenderID" IS NOT null ) ) AND ( ("Gender"."Gender" IS NOT null ) ) ) group by "Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID" order by "Sheet1"."Sheet1_EBt_211215ID" ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender" DESC,"CEGlobalView"."Customer_GenderID" DESC
>
> The exception stack:
>
> ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) - - [TEIID30019 Unexpected exception for request rBDBCRYcUyyM.0]
> java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
> at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91)
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245)
> at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:177)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:175)
> at com.sun.proxy.$Proxy34.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
> you find attached the show plan debug
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4325) ASSERTION FAILED: expected reference to be not null
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4325?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4325:
---------------------------------------
You generally cannot just replace individual jars. Also Teiid 8.13 targets WildFly 9.0.2, so a full upgrade would be required. If you are trying to self-support a particular version, it you could also consider managing the patches on a fork.
> ASSERTION FAILED: expected reference to be not null
> ---------------------------------------------------
>
> Key: TEIID-4325
> URL: https://issues.jboss.org/browse/TEIID-4325
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1, 9.0.2, 8.13.7, 8.12.6.6_3
>
> Attachments: show_plan_debug.txt
>
>
> I'm using teiid 9.0.0 over h2 :
>
> I'm getting ASSERTION_FAILED over the following query and can not find what is causing this exception:
>
> select "Sheet1"."AvgAmoutRange" as "Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as "CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID" as "CEGlobalView_Customer_Gender1","Gender"."Gender" as "Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as "Sheet1_EBt_211215_Sheet1_EBt11" from "CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT JOIN "h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215" "Sheet1" ON ( ("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN "Sheet1"."Min" and "Sheet1"."Max") )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender" "Gender" ON "CEGlobalView"."Customer_GenderID" = "Gender"."GenderID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag" "CustomerTag" ON "CEGlobalView"."Customer_CustomerID" = "CustomerTag"."Customer_CustomerID" AND ( ( ("CustomerTag"."EndDateTime" > CURDATE()) OR ( ("CustomerTag"."EndDateTime" IS null ) ) ) )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue" "TagValue" ON "CustomerTag"."TagValue_TagValueID" = "TagValue"."TagValueID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName" "TagName" ON "TagValue"."TagName_TagNameID" = "TagName"."TagNameID" AND ( ( ("TagName"."TagType_TagTypeID" IN (1.0) ) ) AND ( ("TagName"."TagScope_TagScopeID" IN (1.0) ) ) )
> where ( ( ( ("TagName"."TagName" IN ('Behavior') ) ) ) AND ( ("Sheet1"."AvgAmoutRange" IS NOT null ) ) AND ( ("CEGlobalView"."Customer_GenderID" IS NOT null ) ) AND ( ("Gender"."Gender" IS NOT null ) ) ) group by "Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID" order by "Sheet1"."Sheet1_EBt_211215ID" ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender" DESC,"CEGlobalView"."Customer_GenderID" DESC
>
> The exception stack:
>
> ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) - - [TEIID30019 Unexpected exception for request rBDBCRYcUyyM.0]
> java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
> at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91)
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245)
> at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:177)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:175)
> at com.sun.proxy.$Proxy34.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
> you find attached the show plan debug
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4700) Google translator inconsistent behavior for DELETE and SELECT for null values
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4700?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4700:
----------------------------------
Component/s: Misc. Connectors
> Google translator inconsistent behavior for DELETE and SELECT for null values
> -----------------------------------------------------------------------------
>
> Key: TEIID-4700
> URL: https://issues.jboss.org/browse/TEIID-4700
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.2
> Environment: 9.2.0.Alpha2
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
>
> In teiid I observed following inconsistent behavior:
> Q1: select intnum, intkey from smalla where intnum > -10 AND intnum < 20
> Q2: delete from smalla where intnum > -10 AND intnum < 20
> Q1 returns rows without null values for intnum, but Q2 deletes also rows with null values for intnum.
> I observed that if I remove the lower boundary (ie. Q3: select intnum, intkey from smalla where intnum < 20 and similarly for delete), both selected and deleted rows contain null values, so the result is consistent.
> The server.log is empty, so I didn't attach it...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4684) PrestoDB translator - format* functions - invalid conversion to 'timestamp with timezone'
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4684?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4684:
---------------------------------------
I should add if you want to change the translator logic to rewrite to a specific format/parse that would be fine, but we also need to generally fix the type mapping/cast as using "timestamp with timezone" won't work.
> PrestoDB translator - format* functions - invalid conversion to 'timestamp with timezone'
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4684
> URL: https://issues.jboss.org/browse/TEIID-4684
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
> Fix For: 9.2.1
>
>
> When issuing query with formatdate or formattime, Teiid tries convert respective column to 'timestamp with timezone'. This conversion causes exception in PrestoDB. The proper conversion should be to 'timestamp'.
> {code:sql|title=Query}
> SELECT FORMATDATE(DateValue, 'MM-dd-yy') FROM BQT1.SmallA
> {code}
> {code:sql|title=Source command}
> SELECT format_datetime(cast(g_0.datevalue AS timestamp with timezone), 'MM-dd-yy') FROM smalla AS g_0
> {code}
> {code:plain|title=Exception}
> 14:41:32,061 WARN [org.teiid.CONNECTOR] (Worker30_QueryProcessorQueue143) Connector worker process failed for atomic-request=A7WqBzZhsyYM.50.0.34: org.teiid.translator.jdbc.JDBCExecutionException: 1 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT format_datetime(cast(g_0.datevalue AS timestamp with timezone), 'MM-dd-yy') FROM smalla AS g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
> at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) [:1.8.0_92]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy48.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_92]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> Caused by: java.sql.SQLException: Query failed (#20170106_134131_04118_k4ss5): line 1:56: mismatched input 'with' expecting {')', 'ARRAY'}
> at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799)
> at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:209)
> at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69)
> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> ... 17 more
> Caused by: com.facebook.presto.sql.parser.ParsingException: line 1:56: mismatched input 'with' expecting {')', 'ARRAY'}
> at com.facebook.presto.sql.parser.SqlParser$1.syntaxError(SqlParser.java:45)
> at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:65)
> at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:566)
> at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:325)
> at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:148)
> at com.facebook.presto.sql.parser.SqlBaseParser.type(SqlBaseParser.java:8691)
> at com.facebook.presto.sql.parser.SqlBaseParser.primaryExpression(SqlBaseParser.java:7817)
> at com.facebook.presto.sql.parser.SqlBaseParser.valueExpression(SqlBaseParser.java:6677)
> at com.facebook.presto.sql.parser.SqlBaseParser.predicated(SqlBaseParser.java:5955)
> at com.facebook.presto.sql.parser.SqlBaseParser.booleanExpression(SqlBaseParser.java:5858)
> at com.facebook.presto.sql.parser.SqlBaseParser.expression(SqlBaseParser.java:5613)
> at com.facebook.presto.sql.parser.SqlBaseParser.primaryExpression(SqlBaseParser.java:7613)
> at com.facebook.presto.sql.parser.SqlBaseParser.valueExpression(SqlBaseParser.java:6677)
> at com.facebook.presto.sql.parser.SqlBaseParser.predicated(SqlBaseParser.java:5955)
> at com.facebook.presto.sql.parser.SqlBaseParser.booleanExpression(SqlBaseParser.java:5858)
> at com.facebook.presto.sql.parser.SqlBaseParser.expression(SqlBaseParser.java:5613)
> at com.facebook.presto.sql.parser.SqlBaseParser.selectItem(SqlBaseParser.java:4706)
> at com.facebook.presto.sql.parser.SqlBaseParser.querySpecification(SqlBaseParser.java:3718)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryPrimary(SqlBaseParser.java:3494)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryTerm(SqlBaseParser.java:3306)
> at com.facebook.presto.sql.parser.SqlBaseParser.queryNoWith(SqlBaseParser.java:3162)
> at com.facebook.presto.sql.parser.SqlBaseParser.query(SqlBaseParser.java:2634)
> at com.facebook.presto.sql.parser.SqlBaseParser.statement(SqlBaseParser.java:1294)
> at com.facebook.presto.sql.parser.SqlBaseParser.singleStatement(SqlBaseParser.java:231)
> at com.facebook.presto.sql.parser.SqlParser.invokeParser(SqlParser.java:92)
> at com.facebook.presto.sql.parser.SqlParser.createStatement(SqlParser.java:65)
> at com.facebook.presto.execution.SqlQueryManager.createQuery(SqlQueryManager.java:289)
> at com.facebook.presto.server.StatementResource$Query.<init>(StatementResource.java:309)
> at com.facebook.presto.server.StatementResource.createQuery(StatementResource.java:172)
> at sun.reflect.GeneratedMethodAccessor474.invoke(Unknown Source) [:1.8.0_92]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
> at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
> at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
> at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
> at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
> at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
> at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
> at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
> at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
> at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689)
> at io.airlift.http.server.TraceTokenFilter.doFilter(TraceTokenFilter.java:63)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
> at io.airlift.http.server.TimingFilter.doFilter(TimingFilter.java:52)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
> at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
> at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:395)
> at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1182)
> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
> at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
> at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)
> at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
> at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> at org.eclipse.jetty.server.Server.handle(Server.java:523)
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
> at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
> at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
> at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
> ... 1 more
> Caused by: org.antlr.v4.runtime.InputMismatchException
> at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:268)
> at com.facebook.presto.sql.parser.SqlBaseParser.type(SqlBaseParser.java:8666)
> ... 77 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months