flink1.16集成hive3.1.2

创建初始化sql

[root@master flink-1.16.1]# pwd
/usr/local/flink/flink-1.16.1
[root@master flink-1.16.1]# cat conf/sql-conf.sql
CREATE CATALOG myhive WITH (
    'type' = 'hive',
    'default-database' = 'bigdata',
    'hive-conf-dir' = '/usr/local/hive/conf',
    'hadoop-conf-dir'='/usr/local/hadoop-3.2.1/etc/hadoop/'
);
-- set the HiveCatalog as the current catalog of the session
USE CATALOG myhive;

bin/sql-client.sh embedded -i conf/sql-conf.sql

依赖

flink-connector-hive_2.12-1.16.1.jar
flink-sql-connector-hive-3.1.2_2.12-1.16.1.jar
hive-exec-3.1.3.jar