kettle-linux中执行hive的ktr报错：Error connecting to database: using class org.apache.hive.jdbc.HiveDriver

最新推荐文章于 2023-08-14 10:26:24 发布

lisery_nj

最新推荐文章于 2023-08-14 10:26:24 发布

阅读量1.1w

点赞数

分类专栏： kettle 文章标签： kettle hive kettle 驱动

本文链接：https://blog.csdn.net/m0_37618809/article/details/81118375

版权

当在Linux环境中使用Kettle执行从Windows生成的KTR文件时，遇到错误：Error connecting to database: using class org.apache.hive.jdbc.HiveDriver。问题在于Kettle无法解析Hive2连接类型，且缺少数据库连接信息及Hive驱动。尝试将Windows的.kettle文件夹、hadoop-configurations文件夹复制到Linux对应路径，并调整不同版本的hive-jdbc.jar，最终发现使用hive-jdbc-1.2.1.jar或1.2.2.jar才能成功执行KTR文件。

摘要由CSDN通过智能技术生成

1.将windows环境中产生的ktr文件上传到linux环境中执行

[root@lx02 data-integration]# ./pan.sh -file=/opt/cm/hadoop/pdi-ce-7.1.0.0-12/data-integration/workspace/hivetorizhi.ktr >> /opt/cm/hadoop/pdi-ce-7.1.0.0-12/data-integration/workspace/log/kettle5.log

2.查看执行文件

[root@lx02 data-integration]# cat /opt/cm/hadoop/pdi-ce-7.1.0.0-12/data-integration/workspace/log/kettle.log 
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
11:09:27,192 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
11:09:28,727 INFO  [KarafInstance] 
*******************************************************************************
*** Karaf Instance Number: 1 at /opt/cm/hadoop/pdi-ce-7.1.0.0-12/data-integ ***
***   ration/./system/karaf/caches/pan/data-1                               ***
*** FastBin Provider Port:52901                                             ***
*** Karaf Port:8802                                                         ***
*** OSGI Service Port:9051                                                  ***
*******************************************************************************
七月 17, 2018 11:09:37 上午 org.apache.karaf.main.Main$KarafLockCallback lockAquired
信息: Lock acquired. Setting startlevel to 100
2018-07-17 11:11:45.388:INFO:oejs.Server:jetty-8.1.15.v20140411
2018-07-17 11:11:45.510:INFO:oejs.AbstractConnector:Started NIOSocketConnectorWrapper@0.0.0.0:9051
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing
七月 17, 2018 11:11:52 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (152) [org.apache.cxf.management.InstrumentationManager]
七月 17, 2018 11:11:53 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (189) [org.apache.cxf.wsdl.WSDLManager]
七月 17, 2018 11:11:53 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (203) [org.apache.cxf.ws.policy.PolicyEngine, org.apache.cxf.policy.PolicyDataEngine, org.apache.cxf.ws.policy.AssertionBuilderRegistry, org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry, org.apache.cxf.ws.policy.PolicyBuilder, org.apache.cxf.ws.policy.PolicyAnnotationListener, org.apache.cxf.ws.poli