3 Replies Latest reply on Jun 22, 2018 2:04 PM by shawkins

    org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException

    gopal.goel
    gopal.goel Jun 22, 2018 8:38 AM

      Hello,

       

      After creating view from hive table , while i am going to view it's data using preview. below exception is coming.

      I'm using teiid 9.0.6 and wildfly 9.0.2

       

      error on jboss developers studio :-

       

      org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 hive15: 10001 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.`total_accounts`, g_0.`derogatory_marks`, g_0.`account_mix`, g_0.`hard_inquiries`, g_0.`payment_history`, g_0.`accound_id`, g_0.`account_mix_values`, g_0.`transunion`, g_0.`equifax`, g_0.`name` FROM `risk_data` g_0]

       

       

      warning on console:-

      @

      17:46:23,392 WARN  [org.teiid.RUNTIME] (Worker0_async-teiid-threads0)  TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: Method not supported: org.teiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: Method not supported

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:68)

              at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)

              at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)

              at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)

              at org.teiid.jboss.VDBService$6.run(VDBService.java:398)

              at org.teiid.jboss.VDBService$7.run(VDBService.java:449)

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

              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:1149)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

              at java.lang.Thread.run(Thread.java:748)

      Caused by: java.sql.SQLException: Method not supported

              at org.apache.hive.jdbc.HiveDatabaseMetaData.getIndexInfo(HiveDatabaseMetaData.java:382)

              at org.teiid.translator.jdbc.JDBCMetdataProcessor.getIndexes(JDBCMetdataProcessor.java:647)

              at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:163)

              at org.teiid.translator.hive.HiveMetadataProcessor.getConnectorMetadata(HiveMetadataProcessor.java:65)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:307)

              ... 12 more

       

      error logs file are not creating even i tried

      <logger category="org.teiid.COMMAND_LOG">

                   <level name="DEBUG"/>

      </logger>

      to get the error log file but its showing parsing error

       

      Can someone please help me with this, thanks in advance.