impala的基本操作------持续更新中

容器impala命令行执行任务

kubectl exec  $(kubectl get pod -n spacename| grep impala|grep server|awk '{print $1}'|head -n 1) -n spacename -i -t -- impala-shell.sh -l -q "show databases" --user username --auth_creds_ok_in_clear --ldap_password_cmd="echo -n password"

impala shell 登入命令带密码

./impala-shell.sh -l -u root --auth_creds_ok_in_clear --ldap_password_cmd=‘echo -n passwd’

impala自动定时同步元数据

配置hms_event_polling_interval_s 参数

设置资源队列

set request_pool=devalopment

impala创建kudu内部表

create table test_impala_kudu(name string, id int, PRIMARY KEY(name) )
PARTITION BY HASH PARTITIONS 16 
STORED AS KUDU TBLPROPERTIES ( 'kudu.num_tablet_replicas' = '1' );

impala 创建kudu外部表

create EXTERNAL TABLE impala_kudu_test
          STORED AS KUDU
          TBLPROPERTIES ('kudu.table_name' = 'kudu_table')