Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3766

HBase - using timestamp value with ALL (quantified comparison predicate) throws IllegalArgumentException

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 8.7.1.6_2
    • None
    • None
    • Hide

      SELECT INTKEY, TIMESTAMPVALUE FROM BQT1.SMALLA WHERE TIMESTAMPVALUE <= ALL (SELECT TIMESTAMPVALUE FROM BQT1.SMALLA WHERE INTKEY = 40)

      Unable to find source-code formatter for language: text. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      07:51:56,741 WARN  [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue103) TEIID30020 Processing exception for request qvJ3png5LESA.37 'TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)]'. Originally TeiidProcessingException 'Unknown class: <null>' FastDateFormat.java:796.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)]
      	at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:381) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
      Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)]
      	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
      	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_40]
      	at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
      	... 6 more
      Caused by: java.sql.SQLException: Error
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.checkException(WrappedConnection.java:1648)
      	at org.jboss.jca.adapters.jdbc.WrappedStatement.checkException(WrappedStatement.java:1267)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:467)
      	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
      	... 12 more
      Caused by: java.lang.IllegalArgumentException: Unknown class: <null>
      	at org.apache.commons.lang.time.FastDateFormat.format(FastDateFormat.java:796)
      	at java.text.Format.format(Format.java:157) [rt.jar:1.8.0_40]
      	at org.apache.phoenix.schema.types.PDataType.toStringLiteral(PDataType.java:1078)
      	at org.apache.phoenix.schema.types.PTimestamp.toStringLiteral(PTimestamp.java:191)
      	at org.apache.phoenix.schema.types.PArrayDataType.toStringLiteral(PArrayDataType.java:1194)
      	at org.apache.phoenix.expression.LiteralExpression.toString(LiteralExpression.java:241)
      	at java.lang.String.valueOf(String.java:2982) [rt.jar:1.8.0_40]
      	at java.lang.StringBuilder.append(StringBuilder.java:131) [rt.jar:1.8.0_40]
      	at com.google.common.collect.RegularImmutableList.toString(RegularImmutableList.java:131)
      	at java.lang.String.valueOf(String.java:2982) [rt.jar:1.8.0_40]
      	at java.lang.StringBuilder.append(StringBuilder.java:131) [rt.jar:1.8.0_40]
      	at org.apache.phoenix.expression.BaseCompoundExpression.toString(BaseCompoundExpression.java:135)
      	at org.apache.phoenix.filter.BooleanExpressionFilter.toString(BooleanExpressionFilter.java:85)
      	at org.apache.phoenix.iterate.ExplainTable.explain(ExplainTable.java:142)
      	at org.apache.phoenix.iterate.BaseResultIterators.explain(BaseResultIterators.java:713)
      	at org.apache.phoenix.iterate.RoundRobinResultIterator.explain(RoundRobinResultIterator.java:153)
      	at org.apache.phoenix.execute.BaseQueryPlan.getPlanSteps(BaseQueryPlan.java:406)
      	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:263)
      	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:156)
      	at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:201)
      	at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:121)
      	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:265)
      	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:255)
      	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:254)
      	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery(PhoenixPreparedStatement.java:187)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
      
      Show
      SELECT INTKEY, TIMESTAMPVALUE FROM BQT1.SMALLA WHERE TIMESTAMPVALUE <= ALL (SELECT TIMESTAMPVALUE FROM BQT1.SMALLA WHERE INTKEY = 40) Unable to find source-code formatter for language: text. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml 07:51:56,741 WARN [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue103) TEIID30020 Processing exception for request qvJ3png5LESA.37 'TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)]' . Originally TeiidProcessingException 'Unknown class: < null >' FastDateFormat.java:796.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)] at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:381) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40] at java.lang. Thread .run( Thread .java:745) [rt.jar:1.8.0_40] Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.timestampvalue FROM smalla AS g_0 WHERE g_0.timestampvalue <= ALL (SELECT g_1.timestampvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)] at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_40] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] ... 6 more Caused by: java.sql.SQLException: Error at org.jboss.jca.adapters.jdbc.WrappedConnection.checkException(WrappedConnection.java:1648) at org.jboss.jca.adapters.jdbc.WrappedStatement.checkException(WrappedStatement.java:1267) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:467) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) ... 12 more Caused by: java.lang.IllegalArgumentException: Unknown class: < null > at org.apache.commons.lang.time.FastDateFormat.format(FastDateFormat.java:796) at java.text.Format.format(Format.java:157) [rt.jar:1.8.0_40] at org.apache.phoenix.schema.types.PDataType.toStringLiteral(PDataType.java:1078) at org.apache.phoenix.schema.types.PTimestamp.toStringLiteral(PTimestamp.java:191) at org.apache.phoenix.schema.types.PArrayDataType.toStringLiteral(PArrayDataType.java:1194) at org.apache.phoenix.expression.LiteralExpression.toString(LiteralExpression.java:241) at java.lang. String .valueOf( String .java:2982) [rt.jar:1.8.0_40] at java.lang.StringBuilder.append(StringBuilder.java:131) [rt.jar:1.8.0_40] at com.google.common.collect.RegularImmutableList.toString(RegularImmutableList.java:131) at java.lang. String .valueOf( String .java:2982) [rt.jar:1.8.0_40] at java.lang.StringBuilder.append(StringBuilder.java:131) [rt.jar:1.8.0_40] at org.apache.phoenix.expression.BaseCompoundExpression.toString(BaseCompoundExpression.java:135) at org.apache.phoenix.filter.BooleanExpressionFilter.toString(BooleanExpressionFilter.java:85) at org.apache.phoenix.iterate.ExplainTable.explain(ExplainTable.java:142) at org.apache.phoenix.iterate.BaseResultIterators.explain(BaseResultIterators.java:713) at org.apache.phoenix.iterate.RoundRobinResultIterator.explain(RoundRobinResultIterator.java:153) at org.apache.phoenix.execute.BaseQueryPlan.getPlanSteps(BaseQueryPlan.java:406) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:263) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:156) at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:201) at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:121) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:265) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:255) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:254) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery(PhoenixPreparedStatement.java:187) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

    Description

      If a timestamp value is used in combination with ALL predicate (quantified comparison predicate), then IllegalArgumentException is throw (by Phoenix driver).

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              jdurani Juraj DurĂ¡ni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: