# 1. Kerberos认证
//kerberos认证
klist -kt /etc/xxx.keytab
kinit -kt /etc/xxx.keytab xx@TBDS-MD3Y2ZV9
klist
# 2. 创建连接
bin/beeline -u "jdbc:hive2://172.16.12.14:10009/default;principal=hadoop/tbds-4ewgkc73@TBDS-MD3Y2ZV9;#kyuubi.engine.type=SPARK_SQL;kyuubi.engine.share.level=CONNECTION"
# 2.1 创建TEMPORARY VIEW
CREATE TEMPORARY VIEW temp_view AS SELECT array(1, 2, 3) as numbers;
+---------+
| Result |
+---------+
+---------+
# 2.2 下面使用explode函数将数组展开为多行 这将返回三行数据，每行包含一个数字
SELECT explode(numbers) as number FROM temp_view;
+---------+
| number |
+---------+
| 1 |
| 2 |
| 3 |
+---------+
# 3. 使用collect_list函数将这些数字重新组合成一个数组 将返回一个包含一个数组的行，这个数组包含我们原来的数字
SELECT collect_list(number) as numbers FROM (SELECT explode(numbers) as number FROM temp_view);
+----------+
| numbers |
+----------+
| [1,2,3] |
+----------+
