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

[paulus107]

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)

[rareddy]

Hive JDBC Driver does not support prepared statements, thus the issue. We would need to turn off the prepared statements at this translator. To do that depending on how you are building VDB, if you are using the Designer, on the VDB explorer panel, you need to define a translator override with "Use Bind Variables" to "false" like below

Then use the created translator override as the "translator" name on your Hive model, then re-deploy the VDB and test.

If you are using the Dynamic VDB, see this Translators · Teiid Documentation  at "override execution properties" section. Here also the property you are overriding must be "UseBindVariables" to "false". After modification redeploy VDB and  test.

Ramesh..

[shawkins]

What is the teiid type for created_date? We should be using the untyped setObject call unless created_date is ojbect type.

[paulus107]

Hi Ramesh,

Thanks for help.

Not able to the below line. Can you please explain it?

Then use the created translator override as the "translator" name on your Hive model

Because,  I tried to SET Translator NAME in sourcemodel .But not able to find created translator override

[rareddy]

The name you gave to the updated property configuration from above picture, ex: "hive-override" in my picture. use that name instead of "hive" on source model Translator name.

[paulus107]

Hi Ramesh,

Thanks. prepared statement  error is gone

After giving the URL : http://localhost:8080/hivevdb/hiveview/get/174 in the browser.

I am getting new error in the console

06:57:40,910 ERROR [stderr] (Worker1_QueryProcessorQueue6) qsRPoFYi4g7G 17/12/01 06:57:40 INFO jdbc.Utils: Supplied authorities: 10.18.41.188:10000

06:57:40,910 ERROR [stderr] (Worker1_QueryProcessorQueue6) qsRPoFYi4g7G 17/12/01 06:57:40 INFO jdbc.Utils: Resolved authority: 10.18.41.188:10000

06:57:41,164 INFO  [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue6) qsRPoFYi4g7G TEIID11002 Failed to report the JDBC driver and connection information

[paulus107]

Thanks Steven. I will change it

[rareddy]

Would need a complete error stack to see what is the issue?