11:01:10,103 DEBUG [org.teiid.TRANSPORT] (New I/O worker #6) processing message:MessageHolder: key=463 contents=Invoke interface org.teiid.client.DQP.executeRequest 11:01:10,104 DEBUG [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue327) Request Thread 4d7+Ql7u9+t9.28 with state NEW 11:01:10,104 DEBUG [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue327) 4d7+Ql7u9+t9.28 Non-cachable command. 11:01:10,104 DEBUG [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue327) 4d7+Ql7u9+t9.28 executing insert into hbase.smalla (intkey, bigintegervalue) values (55, -10) 11:01:10,106 DEBUG [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue327) ProcessTree for 4d7+Ql7u9+t9.28 AccessNode(0) output=[Count] INSERT INTO hbase.SmallA (IntKey, BigIntegerValue) VALUES (55, -10) 11:01:10,106 DEBUG [org.teiid.TXN_LOG] (Worker35_QueryProcessorQueue327) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@6872a6c1(4d7+Ql7u9+t9) 11:01:10,106 DEBUG [org.teiid.TXN_LOG] (Worker35_QueryProcessorQueue327) after getOrCreateTransactionContext : 4d7+Ql7u9+t9 NONE ID:NONE 11:01:10,106 DEBUG [org.teiid.BUFFER_MGR] (Worker35_QueryProcessorQueue327) Creating TupleBuffer: 95 [Count] [class java.lang.Integer] batch size 2048 of type PROCESSOR 11:01:10,106 DEBUG [org.teiid.CONNECTOR] (Worker35_QueryProcessorQueue327) 4d7+Ql7u9+t9.28.0.85 Create State 11:01:10,106 DEBUG [org.teiid.BUFFER_MGR] (Worker35_QueryProcessorQueue327) 4d7+Ql7u9+t9.28.0.85 Blocking on source query 4d7+Ql7u9+t9.28.0.85 11:01:10,106 DEBUG [org.teiid.BUFFER_MGR] (Worker35_QueryProcessorQueue327) 4d7+Ql7u9+t9.28 Blocking on source request(s). 11:01:10,106 DEBUG [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue327) Request Thread 4d7+Ql7u9+t9.28 - processor blocked 11:01:10,106 DEBUG [org.teiid.PROCESSOR] (Worker36_QueryProcessorQueue328) Running task for parent thread Worker35_QueryProcessorQueue327 11:01:10,106 DEBUG [org.teiid.CONNECTOR] (Worker36_QueryProcessorQueue328) 4d7+Ql7u9+t9.28.0.85 Processing NEW request: INSERT INTO hbase.SmallA (IntKey, BigIntegerValue) VALUES (55, -10) 11:01:10,107 DEBUG [org.teiid.CONNECTOR] (Worker36_QueryProcessorQueue328) Source-specific command: UPSERT INTO smalla (intkey, bigintegervalue) VALUES (55, -10) 11:01:10,107 DEBUG [org.teiid.CONNECTOR] (Worker36_QueryProcessorQueue328) 4d7+Ql7u9+t9.28.0.85 Obtained execution 11:01:10,108 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (Worker36_QueryProcessorQueue328) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3096e5b4[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@32ae08a4 connection handles=1 lastUse=1439283670107 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2ccc14c2 pool internal context=SemaphoreArrayListManagedConnectionPool@195ea4e8[pool=localHBase] xaResource=LocalXAResourceImpl@64667a14[connectionListener=3096e5b4 connectionManager=76a259b warned=false currentXid=null productName=Phoenix productVersion=4.5 jndiName=java:/localHBase] txSync=null]: java.lang.ClassCastException: java.lang.Long cannot be cast to java.math.BigDecimal at org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312) at org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:791) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeUpdate(PhoenixPreparedStatement.java:200) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:218) at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:79) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:362) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] 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-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] 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] 11:01:10,109 WARN [org.teiid.CONNECTOR] (Worker36_QueryProcessorQueue328) Connector worker process failed for atomic-request=4d7+Ql7u9+t9.28.0.85: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: UPSERT INTO smalla (intkey, bigintegervalue) VALUES (55, -10)] at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:247) at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:79) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:362) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:329) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] 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-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-4.jar:8.7.1.6_2-redhat-4] 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: 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.executeUpdate(WrappedPreparedStatement.java:497) at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:218) ... 14 more Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.math.BigDecimal at org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312) at org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:791) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeUpdate(PhoenixPreparedStatement.java:200) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) ... 15 more