前言
dolphinscheduler安装版本：3.1.8
hive版本：2.1.1-cdh6.3.2
发现问题&分析问题
- 添加数据源报错
[ERROR] 2021-01-08 10:55:40.553 org.apache.dolphinscheduler.api.service.DataSourceService:
[433] - Could not establish connection to jdbc:hive2://10.0.4.78:10000/vfs_dw: Required field 'client_protocol' is unset!
Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=vfs_dw})
java.sql.SQLException: Could not establish connection to jdbc:hive2://10.0.4.78:10000/vfs_dw:
Required field 'client_protocol' is unset!
Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=vfs_dw})
2.运行任务报错
1.Dolphinscheduler任务启动报错，协议错误
2.Dolphinscheduler任务全部启动异常，所有实例都变成提交成功，但是没有日志，也不会提交
解决办法
解决1：将hive-jdbc-2.1.1-cdh6.3.2-standalone.jar 放到api和work的lib目录，删除多余hive jar包
发现Hive数据可以配置成功，但是ds所有工作流启动不了了，启动就变成提交成功，没有日志。
解决2：将cdh所有hive-*.jar都放到api和work的lib目录，删除多余hive jar包
发现work启动异常，日志出现hive-jdbc-2.1.1-cdh6.3.2-standalone相关报错
Exception in thread "Worker-Server" java.lang.IllegalArgumentException:
LoggerFactory is not a Logback LoggerContext but Logback is on the classpath.
Either remove Logback or the competing implementation
(class org.apache.logging.slf4j.Log4jLoggerFactory loaded from file:/opt/software/dolphinscheduler-3.1.8/worker-server/libs/hive-jdbc-2.1.1-cdh6.3.2-standalone.jar).
If you are using WebLogic you will need to add 'org.slf4j' to prefer-application-packages in WEB-INF/weblogic.xml: org.apache.logging.slf4j.Log4jLoggerFactory
解决3：将cdh hive包选择性替换到api和work的lib目录
成功解决
#api-server
#备份libs
cp -ar /opt/software/dolphinscheduler-3.1.8/api-server/libs/ /opt/software/dolphinscheduler-3.1.8/api-server/libs-bac
#复制到api-server
cp /opt/cloudera/parcels/CDH/jars/hive-jdbc-2.1.1-cdh6.3.2-standalone.jar /opt/software/dolphinscheduler-3.1.8/api-server/libs/
#权限改为dolphinscheduler
chown dolphinscheduler:dolphinscheduler /opt/software/dolphinscheduler-3.1.8/api-server/libs/hive-*.jar
#删除ds自带的所有hive错误版本相关驱动依赖
rm -rf /opt/software/dolphinscheduler-3.1.8/api-server/libs/hive-*2.3.9.jar
#check
ll /opt/software/dolphinscheduler-3.1.8/api-server/libs/|grep hive
#备份libs
cp -ar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/ /opt/software/dolphinscheduler-3.1.8/worker-server/libs-bac
#worker-server
#删除ds自带的所有hive错误版本相关驱动依赖
rm -rf /opt/software/dolphinscheduler-3.1.8/worker-server/libs/hive-*.jar
#复制到worker-server
cp -n /opt/cloudera/parcels/CDH/jars/hive-common*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-jdbc-2.1.1-cdh6.3.2.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-metastore*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-serde*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-service*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-service-rpc*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
cp -n /opt/cloudera/parcels/CDH/jars/hive-storage-api*.jar /opt/software/dolphinscheduler-3.1.8/worker-server/libs/
#权限改为dolphinscheduler
chown dolphinscheduler:dolphinscheduler /opt/software/dolphinscheduler-3.1.8/worker-server/libs/hive-*.jar
#check
ll /opt/software/dolphinscheduler-3.1.8/worker-server/libs/|grep hive
