7 Replies Latest reply on Dec 1, 2017 12:40 PM by Ramesh Reddy

    java.sql.SQLException: Remote java.sql.SQLException: Method not supported   -- HIVE

    Paulus Paulus Newbie

      Hello All

       

       

      Iam  working in REST API with hive connection . When passiing the parameter from the browser. Iam getting below error.

       

      URL : http://localhost:8080/hivevdb/hiveview/get/174

       

      ERROR LOG:

       

      caused by: org.teiid.core.TeiidException: 0 Remote
      org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error
      executing statement(s): [Prepared Values: ['174'] SQL: SELECT g_0.c3,
      g_0.user_id, g_0.loginfo, g_0.created_date FROM `docbase_logs` g_0 WHERE
      g_0.created_date = ?]
              at
      org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
              at
      org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:365)
              at
      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at
      java.lang.reflect.Method.invoke(Method.java:498)
              at
      org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
              at
      com.sun.proxy.$Proxy63.execute(Unknown Source)
              at
      org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
              at
      org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
              at
      org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
              at
      java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at
      org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
              ... 6 more
      Caused by: java.sql.SQLException: Remote
      java.sql.SQLException: Method not supported
              at
      org.apache.hive.jdbc.HivePreparedStatement.setObject(HivePreparedStatement.java:601)
              at
      org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:1033)
              at
      org.teiid.translator.jdbc.JDBCExecutionFactory.bindValue(JDBCExecutionFactory.java:1005)
              at
      org.teiid.translator.hive.BaseHiveExecutionFactory.bindValue(BaseHiveExecutionFactory.java:287)
              at
      org.teiid.translator.jdbc.JDBCBaseExecution.bind(JDBCBaseExecution.java:107)
              at
      org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:122)