09:19:15,184 DEBUG [org.teiid.TRANSPORT] (New I/O worker #4) processing message:MessageHolder: key=246 contents=Invoke interface org.teiid.client.DQP.executeRequest 09:19:15,190 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue117) Request Thread M3Pp7caJkMw1.21 with state NEW 09:19:15,190 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue117) M3Pp7caJkMw1.21 Non-cachable command. 09:19:15,190 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue117) M3Pp7caJkMw1.21 executing insert into hbase.smalla (intkey, timestampvalue) values (55, '2000-01-02 03:04:05') 09:19:15,193 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue117) ProcessTree for M3Pp7caJkMw1.21 AccessNode(0) output=[Count] INSERT INTO hbase.SmallA (IntKey, TimestampValue) VALUES (55, {ts'2000-01-02 03:04:05.0'}) 09:19:15,194 DEBUG [org.teiid.TXN_LOG] (Worker12_QueryProcessorQueue117) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@6872a6c1(M3Pp7caJkMw1) 09:19:15,194 DEBUG [org.teiid.TXN_LOG] (Worker12_QueryProcessorQueue117) after getOrCreateTransactionContext : M3Pp7caJkMw1 NONE ID:NONE 09:19:15,194 DEBUG [org.teiid.BUFFER_MGR] (Worker12_QueryProcessorQueue117) Creating TupleBuffer: 31 [Count] [class java.lang.Integer] batch size 2048 of type PROCESSOR 09:19:15,195 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue117) M3Pp7caJkMw1.21.0.31 Create State 09:19:15,195 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue118) Running task for parent thread Worker12_QueryProcessorQueue117 09:19:15,195 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue118) M3Pp7caJkMw1.21.0.31 Processing NEW request: INSERT INTO hbase.SmallA (IntKey, TimestampValue) VALUES (55, {ts'2000-01-02 03:04:05.0'}) 09:19:15,196 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue118) Source-specific command: UPSERT INTO smalla (intkey, timestampvalue) VALUES (55, {ts '2000-01-02 03:04:05.0'}) 09:19:15,196 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue118) M3Pp7caJkMw1.21.0.31 Obtained execution 09:19:15,200 DEBUG [org.teiid.BUFFER_MGR] (Worker12_QueryProcessorQueue117) M3Pp7caJkMw1.21.0.31 Blocking on source query M3Pp7caJkMw1.21.0.31 09:19:15,203 DEBUG [org.teiid.BUFFER_MGR] (Worker12_QueryProcessorQueue117) M3Pp7caJkMw1.21 Blocking on source request(s). 09:19:15,203 DEBUG [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue117) Request Thread M3Pp7caJkMw1.21 - processor blocked 09:19:15,198 WARN [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue118) Connector worker process failed for atomic-request=M3Pp7caJkMw1.21.0.31: org.teiid.translator.jdbc.JDBCExecutionException: 604 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: UPSERT INTO smalla (intkey, timestampvalue) VALUES (55, {ts '2000-01-02 03:04:05.0'})] 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: org.apache.phoenix.exception.PhoenixParserException: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting "LPAREN", got "{" at line 1, column 57. at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111) at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1282) at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1363) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.(PhoenixPreparedStatement.java:95) at org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:634) at org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:660) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:748) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:734) at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405) at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:184) at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:182) ... 14 more Caused by: MismatchedTokenException(83!=90) at org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:351) at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115) at org.apache.phoenix.parse.PhoenixSQLParser.not_expression(PhoenixSQLParser.java:6425) at org.apache.phoenix.parse.PhoenixSQLParser.and_expression(PhoenixSQLParser.java:6245) at org.apache.phoenix.parse.PhoenixSQLParser.or_expression(PhoenixSQLParser.java:6182) at org.apache.phoenix.parse.PhoenixSQLParser.expression(PhoenixSQLParser.java:6147) at org.apache.phoenix.parse.PhoenixSQLParser.one_or_more_expressions(PhoenixSQLParser.java:8372) at org.apache.phoenix.parse.PhoenixSQLParser.upsert_node(PhoenixSQLParser.java:4649) at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:774) at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:499) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108) ... 24 more