-
1. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
rareddy Nov 30, 2017 9:20 AM (in response to paulus107)1 of 1 people found this helpfulHive 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..
-
2. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
shawkins Nov 30, 2017 9:37 AM (in response to rareddy)What is the teiid type for created_date? We should be using the untyped setObject call unless created_date is ojbect type.
-
3. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
paulus107 Nov 30, 2017 1:20 PM (in response to rareddy)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
-
4. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
rareddy Nov 30, 2017 6:33 PM (in response to paulus107)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.
-
5. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
paulus107 Dec 1, 2017 7:14 AM (in response to rareddy)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
-
6. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
paulus107 Dec 1, 2017 7:15 AM (in response to shawkins)Thanks Steven. I will change it
-
7. Re: java.sql.SQLException: Remote java.sql.SQLException: Method not supported -- HIVE
rareddy Dec 1, 2017 12:40 PM (in response to paulus107)Would need a complete error stack to see what is the issue?