flink 1.12.0 sql 运行需要的包,配置文件

1.所需包文件放置在lib目录下

• -rw-r--r-- 1 root root 58005 Jul 16 17:02 flink-connector-clickhouse-1.0-SNAPSHOT.jar
• -rw-r--r-- 1 root root 6813472 May 14 09:44 flink-connector-clickhouse-1.12.0.jar
• -rw-r--r-- 1 root root 6319023 Jan 21 2021 flink-connector-hive_2.11-1.12.0.jar
• -rw-r--r-- 1 root root 196416 Dec 16 2020 flink-connector-jdbc_2.11-1.12.0.jar
• -rw-r--r-- 1 501 games 91553 Dec 2 2020 flink-csv-1.12.0.jar
• -rw-r--r-- 1 501 games 114120165 Dec 2 2020 flink-dist_2.11-1.12.0.jar
• -rw-r--r-- 1 root root 19301 Jan 28 2021 flink-format-changelog-json-1.1.0.jar
• -rw-r--r-- 1 501 games 136663 Dec 2 2020 flink-json-1.12.0.jar
• -rw-r--r-- 1 root root 41368997 Jun 24 13:50 flink-shaded-hadoop-2-uber-2.7.5-10.0.jar
• -rw-r--r-- 1 501 games 7709741 Sep 30 2020 flink-shaded-zookeeper-3.4.14.jar
• -rw-r--r-- 1 root root 3650212 Dec 16 2020 flink-sql-connector-kafka_2.11-1.12.0.jar
• -rw-r--r-- 1 root root 26592480 Jan 28 2021 flink-sql-connector-mysql-cdc-1.0.0.jar
• -rw-r--r-- 1 501 games 36147819 Dec 2 2020 flink-table_2.11-1.12.0.jar
• -rw-r--r-- 1 501 games 40286358 Dec 2 2020 flink-table-blink_2.11-1.12.0.jar
• -rw-r--r-- 1 root root 16023609 Jul 8 09:25 flinkx-connector-clickhouse-1.12_beta.jar
• -rw-r--r-- 1 root root 7447149 Jul 8 09:25 flinkx-core-1.12_beta.jar
• -rw-r--r-- 1 root root 41516460 Jan 21 2021 hive-exec-3.1.0.3.1.0.0-78.jar
• -rw-r--r-- 1 root root 313702 Jan 21 2021 libfb303-0.9.3.jar
• -rw-r--r-- 1 501 games 67114 Feb 22 2020 log4j-1.2-api-2.12.1.jar
• -rw-r--r-- 1 501 games 276771 Feb 22 2020 log4j-api-2.12.1.jar
• -rw-r--r-- 1 501 games 1674433 Feb 22 2020 log4j-core-2.12.1.jar
• -rw-r--r-- 1 501 games 23518 Feb 22 2020 log4j-slf4j-impl-2.12.1.jar
• -rw-r--r-- 1 root root 1007502 Apr 10 2019 mysql-connector-java-5.1.47.jar

2.conf文件配置 catalogs:

• name: hive

  type: hive

  hive-conf-dir: /usr/hdp/3.1.0.0-78/hive/conf

  default-database: default

3.脚本启动测试（test.sh） cd /opt/flink-1.12.0

./bin/sql-client.sh embedded -d conf/sql-client-hive.yaml << flink

use catalog hive;

show databases;

use ods;
select * from  test;

flink