CDH 集群Impala-Shell 获取不到数据及相关问题

错误描述：在CDH 界面安装Impala 服务之后，进入到服务器的Impala-shell中运行查询语句获取不到数据
Client connection negotiation failed: client connection to 192.168.xxx.xx:27000
: unable to find SASL plugin: PLAIN
控制台运行查询打印信息如下：

[hddatanode02:21000] test> select * from test.ods_cdp_data_explore;
Query: select * from test.ods_cdp_data_explore
Query submitted at: 2021-05-11 12:37:59 (Coordinator: http://hddatanode02:25000)
Query progress can be monitored at: http://hddatanode02:25000/query_plan?query_id=30449dee01f496b3:a920b9a600000000
ERROR: Cancelled

错误定位：进入到impala的日志目录查看impalad 的错误日志：

cd /var/log/impalad/

more impalad.ERROR

E0511 12:39:25.519563 152802 query-state.cc:442] cf4d3e457784fe5f:1c23241500000000] Cancelling fragment instances due to failure to reach the
 coordinator. (ReportExecStatus() RPC failed: Invalid argument: Client connection negotiation failed: client connection to 192.168.5.65:27000
: unable to find SASL plugin: PLAIN
). Query cf4d3e457784fe5f:1c23241500000000 may hang. See IMPALA-2990.
E0511 12:46:42.245020 154611 query-state.cc:442] c6459a2eff45f5b7:3e35b62900000000] Cancelling fragment instances due to failure to reach the
 coordinator. (ReportExecStatus() RPC failed: Invalid argument: Client connection negotiation failed: client connection to 192.168.5.65:27000
: unable to find SASL plugin: PLAIN
). Query c6459a2eff45f5b7:3e35b62900000000 may hang. See IMPALA-2990.

错误原因：缺少一些依赖包

解决方式：使用yum 进行安装即可，安装如下依赖：

yum -y install gcc python-devel cyrus-sasl* 

HIVE新增表在Impala中不能及时查看

这里基于CDH部署安装的HIVE和Impala，当我们在HIVE中新增一张表时，我们发现在Impala中不能及时查看到新增表，这是因为元数据信息没有及时刷新，在impala里执行invalidate metadata命令刷新元数据即可。