【StarRocks版本】3.1.13
【集群规模】fe与be混部
【联系方式】pangxuebing@sunline.cn
【问题】：使用hive_catalog建立连接查到库查不到表
【操作】：1、首先把hive数据库节点的文件hive-site.xml hdfs-site.xml core-site.xml 拷贝到starocks节点 fe/conf
2、修改 fe/conf/hadoop_env.sh be/conf/hadoop_env.sh开头增加 `export HADOOP_USER_NAME=“srdata”
3、重启starrocks
4、
CREATE EXTERNAL CATALOG hive_catalog_239_2
PROPERTIES
(
“type” = “hive”,
“enable_recursive_listing” = “true”,
“hive.metastore.type” = “hive”,
“hive.metastore.uris” = “thrift://10.22.82.239:9083”
);
SHOW CATALOGS;
SET CATALOG hive_catalog_239_2;
use srdata;
SHOW DATABASES FROM hive_catalog_239_2; – 可以查到hive所有数据库
select * from plf_activity_people_count limit 5;
报错：SQL 错误 [1051] [42S02]: Getting analyzing error. Detail message: Unknown table ‘srdata.plf_activity_people_count’.