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

当在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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值