Problem with Hive dates
dnicodemus Nov 25, 2015 3:35 PMUsing Embedded Teiid 8.12.2. Querying a VDB to Hive, we get the error and stack below when trying to select any date field. Can anyone help me understand what is happening here ?
Thanks,
Dave
2015-11-25 12:31:16,103 WARN PROCESSOR [Worker2_QueryProcessorQueue73] - TEIID30020 Processing exception for request GYK0e2JQPEB+.21 'TEIID30504 /sonar/spider/e0f53211-1554-41a0-92e3-11d64fcdcc2f: Unexpected exception while translating results: Method not supported'. Originally TeiidProcessingException HiveBaseResultSet.java:275. Enable more detailed logging to see the entire stacktrace.
2015-11-25 12:31:18,662 WARN CONNECTOR [Worker3_QueryProcessorQueue83] - Connector worker process failed for atomic-request=GYK0e2JQPEB+.24.0.14
org.teiid.translator.TranslatorException: Unexpected exception while translating results: Method not supported
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:352)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:419)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:220)
at sun.reflect.GeneratedMethodAccessor468.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy123.more(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Method not supported
at org.apache.hive.jdbc.HiveBaseResultSet.getDate(HiveBaseResultSet.java:275)
at org.teiid.translator.jdbc.JDBCExecutionFactory.retrieveValue(JDBCExecutionFactory.java:1023)
at org.teiid.translator.hive.BaseHiveExecutionFactory.retrieveValue(BaseHiveExecutionFactory.java:247)
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:344)