时间戳

首页 > 解决方案 > 使用 jdbc 驱动程序插入配置单元失败

jdbc - 使用 jdbc 驱动程序插入配置单元失败

问题描述

我尝试使用 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]

标签： jdbchiveinsertdenodo

解决方案

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

推荐阅读