Impala 常用

impala与LDAP集成后的登录

impala-shell -i 127.0.0.1:21000 -u root -l --auth_creds_ok_in_clear

[root@AAA ~]$ impala-shell -i 127.0.0.1:21000 -u root -l --auth_creds_ok_in_clear
Starting Impala Shell using LDAP-based authentication
LDAP password for root : 
Connected to 127.0.0.1:21000
Server version: impalad version 3.0.0-cdh6.0.1 RELEASE (build 9a74a5053de5f7b8dd983802e6d75e58d31472db)
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v3.0.0-cdh6.0.1 (9a74a50) built on Wed Sep 19 11:27:37 PDT 2018)

You can run a single query from the command line using the '-q' option.
***********************************************************************************

LDAP authentication is enabled, but the connection to Impala is not secured by TLS.
ALL PASSWORDS WILL BE SENT IN THE CLEAR TO IMPALA.
[127.0.0.1:21000] default> 

手动刷新HIVE 表

[127.0.0.1:21000] root> invalidate metadata table_name;
Query: invalidate metadata table_name
Query submitted at: 2021-05-27 15:09:21 (Coordinator: http://localhost:25000)
Query progress can be monitored at: http://localhost:25000/query_plan?query_id=4b4aa69270524980:856a442700000000
Fetched 0 row(s) in 0.05s
[127.0.0.1:21000] root> show tables;