容器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')