配置kettle连接CDH集群的HiveServer

268 阅读1分钟

配置kettle环境

拷贝mysql-connector-java-5.1.46.jar至data-integration\Data Service JDBC Driver

拷贝mysql-connector-java-5.1.46.jar至data-integration\lib

从CDH集群/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars拷贝以下Hadoop驱动至data-integration\lib

从CDH集群/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hive/lib/拷贝所有hive相关jar包至:data-integration\plugins\pentaho-big-data-plugin\hadoop-configurations\cdh61\lib

 拷贝CDH集群/etc/hive/conf/*.xml 配置至:data-integration\plugins\pentaho-big-data-plugin\hadoop-configurations\cdh61

 修改data-integration\plugins\pentaho-big-data-plugin目录下的plugin.properties文件

 启动Spoon.bat

创建数据库连接