1. 安装

flink-1.19.2
hive-3.1.3
hadoop-3.3.6

hive的lib 放入 flink-sql-jdbc-driver-bundle-1.18.0.jar

fink的lib 放入
antlr-runtime-3.5.2.jar
flink-connector-hive_2.12-1.19.2.jar
flink-connector-jdbc-3.2.0-1.19.jar
hadoop-mapreduce-client-core-3.3.6.jar
hive-common-3.1.3.jar
hive-exec-3.1.3.jar
hive-service-rpc-3.1.3.jar
libfb303-0.9.3.jar

2. 配置

FLINK_HOME/bin/config.sh 增加
export HIVE_CLASSPATH=/data0/hive-3.1.3/lib/
export FLINK_CLASSPATH=/data0/flink-1.19.2/lib/
export FLINK_CLASSPATH=$FLINK_CLASSPATH:$HIVE_CLASSPATH

3.启动

bin/yarn-session.sh -d
sql-gateway.sh start -Dsql-gateway.endpoint.type=hiveserver2 -Dsql-gateway.endpoint.hiveserver2.catalog.hive-conf-dir=/data0/hive-3.1.3/conf

4. 访问

$HIVE_HOME/bin/beeline -u "jdbc:hive2://localhost:10000/default;auth=noSasl" -n ubuntu

报错

Caused by: java.lang.ClassNotFoundException: org.antlr.runtime.tree.Tree
        at java.net.URLClassLoader.findClass(URLClassLoader.java:387)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
        at org.apache.flink.core.classloading.ComponentClassLoader.loadClassFromComponentOnly(ComponentClassLoader.java:150)
        at org.apache.flink.core.classloading.ComponentClassLoader.loadClass(ComponentClassLoader.java:113)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
        ... 19 more (state=,code=0)
0: jdbc:hive2://localhost:10000/default> Closing: 0: jdbc:hive2:
2.