You can translate the question and the replies:

fail to export data from jdbc source to hhive

I try to export data from mysql into hive using denodo scheduler and I create the 2 tables same structure but when I execute the job error appears "Group0#JDBCExporter0: Document 1: Method not supported" ..any help why this happen ? full error 1929530 [extract_from_sql_into_hive_12 (default).DenodoSched_Worker-6] ERROR 2020-04-22T19:59:55.329 com.denodo.scheduler.core.dataSource.connection.JDBCConnection [] - Error rollbacking transaction. java.sql.SQLException: Method not supported at org.apache.hive.jdbc.HiveConnection.rollback(HiveConnection.java:1021) ~[?:?] at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368) ~[commons-dbcp.jar:1.4] at com.denodo.scheduler.core.dataSource.connection.JDBCConnection.rollback(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.exporter.jdbc.JDBCExporter.close(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.exporter.jdbc.JDBCExporter.close(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.job.ExportationJob.closeAllExporters(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.job.AbstractDatabaseExtractionJob.doExecute(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.job.BaseJob.normalExecute(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at com.denodo.scheduler.core.job.BaseJob.execute(Unknown Source) [denodo-scheduler-core.jar:7.0.5] at org.quartz.core.JobRunShell.run(JobRunShell.java:223) [quartz.jar:?] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [quartz.jar:?]
user
22-04-2020 13:45:19 -0400

4 Answers

Hi, The error [**Method not supported**](https://docs.cloudera.com/HDPDocuments/HDP1/HDP-1.2.0/ds_Hive/jdbc-hs2.html) usually occurs from the [HIVE](https://issues.apache.org/jira/browse/HIVE-11501) JDBC driver when one of the unsupported methods is called. If I come across this error, I would perform the following checks: * I would ensure that I use the **latest** version of HIVE JDBC Driver. * Check the **vdp.log** and **scheduler.log** files under the location "<DENODO_HOME>\logs\vdp" and "<DENODO_HOME>\logs\scheduler" folders respectively to know more information about the error. Hope this helps!
Denodo Team
24-04-2020 09:01:18 -0400
I used hive driver found at denodo at folder spark 1.6 ... and my hive version is 2.3... it's not comaptiable? what hive jdbc jars needed ?
user
24-04-2020 14:06:45 -0400
I installed the latest version but still method not allowed
user
26-04-2020 07:59:32 -0400
Hi, The "method not supported" error usually occurs when PreparedStatement is not supported by the Hive JDBC Driver that is establishing the connection. If I want to connect to Hive Server, I would choose the necessary **Database Adapter** and download the JDBC Driver from the Vendor's official site as Denodo **does** **not** provide the Hive [**JDBC Driver**](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#supported-jdbc-data-sources) for connecting to Hive. In case I encounter "method not supported" error when connecting to Hive, I would check if the downloaded Hive JDBC Driver supports PreparedStatement. If you have more questions and you are a user with a valid support account, then I would suggest you raise a support case in the [**Denodo Support Site**](https://support.denodo.com/) with more detailed information. Hope this helps!
Denodo Team
06-05-2020 00:48:44 -0400
You must sign in to add an answer. If you do not have an account, you can register here