1 of 1 people found this helpful
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.
What is the teiid type for created_date? We should be using the untyped setObject call unless created_date is ojbect type.
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
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.
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
Thanks Steven. I will change it
Would need a complete error stack to see what is the issue?