无法使用jdbc驱动程序插入配置单元

wtlkbnrh  于 2021-06-24  发布在  Hive
关注(0)|答案(1)|浏览(288)

我尝试使用jdbc驱动程序'hive-jdbc-2.1.1-cdh6.3.0-standalone.jar'(通过denodo工具)插入到配置单元中,但它总是无法插入,并且错误显示该方法不受支持。。我检索数据成功,但未能插入…有什么帮助吗?

ERROR 2020-04-27T11:56:06.642 com.denodo.scheduler.core.exporter.jdbc.JDBCExporter [] - Connection error in JDBCExporter.  
com.denodo.scheduler.core.dataSource.connection.ServerConnectionException: Method not supported
    at com.denodo.scheduler.core.dataSource.connection.JDBCConnection.commit(Unknown Source) ~[denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.exporter.jdbc.JDBCExporter.export(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.ExportationJob.exportDocuments(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.ExportationJob.doProcess(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.AbstractDatabaseExtractionJob.processDocuments(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.AbstractDatabaseExtractionJob.extractDocuments(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.AbstractDatabaseExtractionJob.extractDocuments(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.task.QueryJob.call(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at com.denodo.scheduler.core.job.task.QueryJob.call(Unknown Source) [denodo-scheduler-core.jar:7.0.5]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162]
x33g5p2x

x33g5p2x1#

我解决了。问题是hivejdbc不支持插入方法,所以我更改了jdbc驱动程序并使用最新的hivejdbccloudera

相关问题