[JBoss JIRA] (TEIID-3768) HBase - Phoenix does not evaluate query correctly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3768?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3768:
---------------------------------------
I can't reproduce this if charvalue is a varchar in phoenix. With charvalue as a char(1) column, then I get no results. I'm not sure we have an immediate workaround to this. Perhaps just a KI to avoid the phoenix char type.
> HBase - Phoenix does not evaluate query correctly
> -------------------------------------------------
>
> Key: TEIID-3768
> URL: https://issues.jboss.org/browse/TEIID-3768
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> This specific query \[1\] is not evaluated correctly (especially MAX(charvalue); e.g. there is no problem with MAX(longnum)). It seems like bug in Phoenix.
> \[1\]
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3781) Queries are not killed even if the client sends a cancel request
by Salvatore R (JIRA)
Salvatore R created TEIID-3781:
----------------------------------
Summary: Queries are not killed even if the client sends a cancel request
Key: TEIID-3781
URL: https://issues.jboss.org/browse/TEIID-3781
Project: Teiid
Issue Type: Bug
Reporter: Salvatore R
Assignee: Steven Hawkins
I have different behaviors when I try to cancel the following queries:
{code:sql}
SELECT COUNT(*)
FROM
(SELECT * FROM my.address) as x1,
(SELECT * FROM my.address) as y1
{code}
and
{code:sql}
SELECT COUNT(*)
FROM
(SELECT * FROM my.address limit 10000) as x1,
(SELECT * FROM my.address limit 10000) as y1
{code}
where "my.address" is a table with around 20000 rows in MySQL.
The first query is immediately cancelled but the second one continues to run until the end and it is never killed.
Looking at the generated plans, the main difference is that the first query is fully pushed down to MySQL while the second one is not.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3769) Teiid throws exception while reading result from HBase (Phoenix JDBC driver)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3769?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3769:
---------------------------------------
can you provide the ddl (source and teiid) used to create smalla and the row (or anything representative) that is triggering the error?
> Teiid throws exception while reading result from HBase (Phoenix JDBC driver)
> ----------------------------------------------------------------------------
>
> Key: TEIID-3769
> URL: https://issues.jboss.org/browse/TEIID-3769
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Teiid throws an exception \[2\] while reading result of query \[1\] from HBase (Phoenix JDBC driver). Execution of source-specific command via SQuirreL directly on HBase ends correctly.
> \[1\]
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA WHERE CHARVALUE < ALL (SELECT CHARVALUE FROM BQT1.SMALLA WHERE INTKEY = 40)
> \[2\]
> {code:text}
> 09:54:44,893 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) Source-specific command: SELECT g_0.intkey, g_0.charvalue FROM smalla AS g_0 WHERE g_0.charvalue < ALL (SELECT g_1.charvalue FROM smalla AS g_1 WHERE g_1.intkey = 40)
> 09:54:44,893 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) qvJ3png5LESA.42.1.26 Obtained execution
> 09:54:45,947 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) qvJ3png5LESA.42.1.26 Executed command
> 09:54:45,948 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) qvJ3png5LESA.42.1.26 Processing MORE request
> 09:54:45,948 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) qvJ3png5LESA.42.1.26 Getting results from connector
> 09:54:46,083 WARN [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue117) Connector worker process failed for atomic-request=qvJ3png5LESA.42.1.26: org.teiid.translator.TranslatorException: 08000 Unexpected exception while translating results: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:351)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:388) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:206) [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:301) [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]
> 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.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
> at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:773)
> at org.jboss.jca.adapters.jdbc.WrappedResultSet.next(WrappedResultSet.java:1862)
> at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338)
> ... 13 more
> Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at java.util.concurrent.FutureTask.report(FutureTask.java:122) [rt.jar:1.8.0_40]
> at java.util.concurrent.FutureTask.get(FutureTask.java:206) [rt.jar:1.8.0_40]
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:549)
> ... 18 more
> Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
> at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:70)
> at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:88)
> at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:79)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:105)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:100)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_40]
> at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
> ... 3 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_40]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_40]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_40]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [rt.jar:1.8.0_40]
> at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:322)
> at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:380)
> at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
> at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
> at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
> at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:369)
> at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:343)
> at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
> ... 3 more
> Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1196)
> at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
> at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
> at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
> ... 10 more
> 09:54:46,091 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue118) Request Thread qvJ3png5LESA.42 with state PROCESSING
> 09:54:46,091 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue118) qvJ3png5LESA.42.1.26 Remove State
> 09:54:46,091 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue118) qvJ3png5LESA.42.1.26 Processing Close : SELECT g_0.IntKey, g_0.CharValue FROM Source.SmallA AS g_0 WHERE g_0.CharValue < ALL (SELECT g_1.CharValue FROM Source.SmallA AS g_1 WHERE g_1.IntKey = 40)
> 09:54:46,091 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue118) qvJ3png5LESA.42.1.26 Closed execution
> 09:54:46,092 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue118) qvJ3png5LESA.42.1.26 Closed connection
> 09:54:46,092 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue118) QueryProcessor: closing processor
> 09:54:46,093 WARN [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue118) TEIID30020 Processing exception for request qvJ3png5LESA.42 'TEIID30504 Source: 08000 Unexpected exception while translating results: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> '. Originally TeiidProcessingException RpcClientImpl.java:1196.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 08000 Unexpected exception while translating results: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> 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.TranslatorException: 08000 Unexpected exception while translating results: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:351)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:388) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:206) [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:301) [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: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
> at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:773)
> at org.jboss.jca.adapters.jdbc.WrappedResultSet.next(WrappedResultSet.java:1862)
> at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338)
> ... 13 more
> Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at java.util.concurrent.FutureTask.report(FutureTask.java:122) [rt.jar:1.8.0_40]
> at java.util.concurrent.FutureTask.get(FutureTask.java:206) [rt.jar:1.8.0_40]
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:549)
> ... 18 more
> Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
> at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:70)
> at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:88)
> at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:79)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:105)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:100)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_40]
> at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
> ... 3 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_40]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_40]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_40]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [rt.jar:1.8.0_40]
> at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:322)
> at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:380)
> at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
> at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
> at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
> at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:369)
> at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:343)
> at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
> ... 3 more
> Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1196)
> at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
> at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
> at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
> ... 10 more
> 09:54:46,101 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue118) Removing tuplesource for the request qvJ3png5LESA.42
> 09:54:46,101 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue118) Removing TupleBuffer: 48
> 09:54:46,102 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue118) org.teiid.core.TeiidProcessingException: TEIID30504 Source: 08000 Unexpected exception while translating results: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toScan(ProtobufUtil.java:991)
> at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 8 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:396)
> ... 13 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.reflect.InvocationTargetException
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1464)
> at org.apache.hadoop.hbase.filter.FilterList.parseFrom(FilterList.java:393)
> ... 13 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.hbase.protobuf.ProtobufUtil.toFilter(ProtobufUtil.java:1460)
> ... 14 more
> Caused by: org.apache.hadoop.hbase.exceptions.DeserializationException: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:55)
> ... 19 more
> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: BooleanExpressionFilter failed during reading: null
> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
> at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:52)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:108)
> at org.apache.phoenix.filter.SingleKeyValueComparisonFilter.readFields(SingleKeyValueComparisonFilter.java:136)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:131)
> at org.apache.hadoop.hbase.util.Writables.getWritable(Writables.java:101)
> at org.apache.phoenix.filter.SingleCQKeyValueComparisonFilter.parseFrom(SingleCQKeyValueComparisonFilter.java:53)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1123)
> at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:338)
> at org.apache.phoenix.schema.types.PCharArray.toObject(PCharArray.java:64)
> at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:967)
> at org.apache.phoenix.expression.LiteralExpression.readFields(LiteralExpression.java:306)
> at org.apache.phoenix.expression.BaseCompoundExpression.readFields(BaseCompoundExpression.java:110)
> at org.apache.phoenix.filter.BooleanExpressionFilter.readFields(BooleanExpressionFilter.java:106)
> ... 23 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3765) HBase - Phoenix does not support scalar subquery
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3765?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3765.
-----------------------------------
Resolution: Done
Added a new capability to control if scalar subqueries can be projected.
> HBase - Phoenix does not support scalar subquery
> ------------------------------------------------
>
> Key: TEIID-3765
> URL: https://issues.jboss.org/browse/TEIID-3765
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 8.12.1, 8.13
>
>
> Phoenix driver does not support a scalar subquery in a SELECT - E.g. SELECT a, (SELECT...) ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3765) HBase - Phoenix does not support scalar subquery
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3765?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3765:
---------------------------------------
A link to the root issue https://issues.apache.org/jira/browse/PHOENIX-1392
> HBase - Phoenix does not support scalar subquery
> ------------------------------------------------
>
> Key: TEIID-3765
> URL: https://issues.jboss.org/browse/TEIID-3765
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 8.12.1, 8.13
>
>
> Phoenix driver does not support a scalar subquery in a SELECT - E.g. SELECT a, (SELECT...) ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3748) Impala translator - SELECT and HAVING statements are translating differently for Case statements
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3748?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3748.
-----------------------------------
Resolution: Cannot Reproduce Bug
Marking as not reproducible for now. Will reopen if needed.
> Impala translator - SELECT and HAVING statements are translating differently for Case statements
> ------------------------------------------------------------------------------------------------
>
> Key: TEIID-3748
> URL: https://issues.jboss.org/browse/TEIID-3748
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.11.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Labels: Impala_Translator, Translators
>
> Error from Impala-
> all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE CAST(NULL AS STRING) END))
> deviating function: count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE NULL END))
> Query:
> SELECT user_key, sum(firstcol),count(distinct case when secondcol >= 0 then 1 end)
> FROM sometable
> WHERE customer_key=6
> GROUP BY user_key
> HAVING sum(firstcol)>100
> AND count(distinct case when secondcol >= 0 then 1 end)=0
>
> Query explanation:
> For all users
> Add up values in the firstcol column (integer column)
> count distinct values in secondcol where secondcol value zero or more
> otherwise return null (output is string)
> Translated Teiid query:
> SELECT user_key, SUM(firstcol) as `EXPR_0`, COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE CAST(NULL AS STRING) END)) as `EXPR_1`
> FROM sometable
> WHERE customer_key` = 6
> HAVING (EXPR_0 > 100) AND (COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE NULL END)) = 0))
> Note the difference between the select and having for EXPR_1:
> Select - THEN '1' ELSE CAST(NULL AS STRING) END
> Having - THEN '1' ELSE NULL END
> Impala doesn't accept that these are the same aggregate function. Aliases aren't accepted in the HAVING.
> One further observation- if we swap the translation and write the statement in the select as
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE NULL END*))
> Teiid translates the SELECT to
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE CAST(NULL AS STRING) END*))
> So it always makes these mismatched.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3748) Impala translator - SELECT and HAVING statements are translating differently for Case statements
by Don Krapohl (JIRA)
[ https://issues.jboss.org/browse/TEIID-3748?page=com.atlassian.jira.plugin... ]
Don Krapohl commented on TEIID-3748:
------------------------------------
Sorry, no. Stuck in my own stories at the moment. We can close and I'll reopen when I have time to collect logs.
> Impala translator - SELECT and HAVING statements are translating differently for Case statements
> ------------------------------------------------------------------------------------------------
>
> Key: TEIID-3748
> URL: https://issues.jboss.org/browse/TEIID-3748
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.11.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Labels: Impala_Translator, Translators
>
> Error from Impala-
> all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE CAST(NULL AS STRING) END))
> deviating function: count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE NULL END))
> Query:
> SELECT user_key, sum(firstcol),count(distinct case when secondcol >= 0 then 1 end)
> FROM sometable
> WHERE customer_key=6
> GROUP BY user_key
> HAVING sum(firstcol)>100
> AND count(distinct case when secondcol >= 0 then 1 end)=0
>
> Query explanation:
> For all users
> Add up values in the firstcol column (integer column)
> count distinct values in secondcol where secondcol value zero or more
> otherwise return null (output is string)
> Translated Teiid query:
> SELECT user_key, SUM(firstcol) as `EXPR_0`, COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE CAST(NULL AS STRING) END)) as `EXPR_1`
> FROM sometable
> WHERE customer_key` = 6
> HAVING (EXPR_0 > 100) AND (COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE NULL END)) = 0))
> Note the difference between the select and having for EXPR_1:
> Select - THEN '1' ELSE CAST(NULL AS STRING) END
> Having - THEN '1' ELSE NULL END
> Impala doesn't accept that these are the same aggregate function. Aliases aren't accepted in the HAVING.
> One further observation- if we swap the translation and write the statement in the select as
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE NULL END*))
> Teiid translates the SELECT to
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE CAST(NULL AS STRING) END*))
> So it always makes these mismatched.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3748) Impala translator - SELECT and HAVING statements are translating differently for Case statements
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3748?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3748:
---------------------------------------
Any update on this?
> Impala translator - SELECT and HAVING statements are translating differently for Case statements
> ------------------------------------------------------------------------------------------------
>
> Key: TEIID-3748
> URL: https://issues.jboss.org/browse/TEIID-3748
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.11.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Labels: Impala_Translator, Translators
>
> Error from Impala-
> all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE CAST(NULL AS STRING) END))
> deviating function: count(DISTINCT (CASE WHEN (secondcol >= 0) THEN 1 ELSE NULL END))
> Query:
> SELECT user_key, sum(firstcol),count(distinct case when secondcol >= 0 then 1 end)
> FROM sometable
> WHERE customer_key=6
> GROUP BY user_key
> HAVING sum(firstcol)>100
> AND count(distinct case when secondcol >= 0 then 1 end)=0
>
> Query explanation:
> For all users
> Add up values in the firstcol column (integer column)
> count distinct values in secondcol where secondcol value zero or more
> otherwise return null (output is string)
> Translated Teiid query:
> SELECT user_key, SUM(firstcol) as `EXPR_0`, COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE CAST(NULL AS STRING) END)) as `EXPR_1`
> FROM sometable
> WHERE customer_key` = 6
> HAVING (EXPR_0 > 100) AND (COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' ELSE NULL END)) = 0))
> Note the difference between the select and having for EXPR_1:
> Select - THEN '1' ELSE CAST(NULL AS STRING) END
> Having - THEN '1' ELSE NULL END
> Impala doesn't accept that these are the same aggregate function. Aliases aren't accepted in the HAVING.
> One further observation- if we swap the translation and write the statement in the select as
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE NULL END*))
> Teiid translates the SELECT to
> COUNT(DISTINCT (CASE WHEN (secondcol >= 0) THEN '1' *ELSE CAST(NULL AS STRING) END*))
> So it always makes these mismatched.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3771.
-----------------------------------
Resolution: Done
There were two issues here. When using a semi-join plan we were not updating the nested correlated references and we were not associating a plan with the nested subquery (thus the npe).
> Teiid throws an NPE while executing query with nested subquery IN predicate
> ---------------------------------------------------------------------------
>
> Key: TEIID-3771
> URL: https://issues.jboss.org/browse/TEIID-3771
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 8.12.1, 8.13
>
>
> Teiid throws an NPE while executing query with double IN predicate. Example query:
> SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM))
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0
[JBoss JIRA] (TEIID-3780) Hive: Convert "UseDatabaseMetaData: to be an translator import property
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3780?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3780:
----------------------------------
Issue Type: Quality Risk (was: Bug)
> Hive: Convert "UseDatabaseMetaData: to be an translator import property
> -----------------------------------------------------------------------
>
> Key: TEIID-3780
> URL: https://issues.jboss.org/browse/TEIID-3780
> Project: Teiid
> Issue Type: Quality Risk
> Components: Misc. Connectors
> Affects Versions: 8.11
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 8.12.1
>
>
> Currently "UseDatabaseMetadata" as been designed as Translator property, may be this should be designed as translator importer property?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
- 1
- 0