连接方式

kerberos 连接

kerberos 认证（Simple 不需要执行）

klist -kt /var/krb5kdc/emr.keytab 
kinit -kt /var/krb5kdc/emr.keytab hadoop/{IP}@TBDS-{域名}

使用 hostname 连接

  impala-shell -i {impalad_hostname}:27009 -s hadoop

使用 ip 连接

• hostname 为 ip

  impala-shell -i {impalad_ip}:27009 -s hadoop

• hostname 不为 ip

  impala-shell -i {impalad_ip}:27009 -s hadoop -b {impalad_hostname}

ldap 连接

impala-shell -i {impalad_hostname} -l -u user --auth_creds_ok_in_clear

命令示例

• 查看数据库

[10.206.0.90:27009] default> show databases;
Query: show databases
+------------------+----------------------------------------------+
| name             | comment                                      |
+------------------+----------------------------------------------+
| _impala_builtins | System database for Impala builtin functions |
| default          | Default Hive database                        |
+------------------+----------------------------------------------+

• 创建数据库

[10.206.0.90:27009] default> create database impala_test;
Query: create database impala_test
+----------------------------+
| summary                    |
+----------------------------+
| Database has been created. |
+----------------------------+

• 切换到 impala_test 数据库

[10.206.0.90:27009] default> use impala_test;
Query: use impala_test

• 查看当前用户

[10.206.0.90:27009] impala_test> select current_user();
Query: select current_user()
Query submitted at: 2023-11-28 19:21:57 (Coordinator: http://10.206.0.90:27004)
Query progress can be monitored at: http://10.206.0.90:27004/query_plan?query_id=8f41325d0ded69d8:ca8b3db500000000
+----------------------------------+
| current_user()                   |
+----------------------------------+
| hadoop/10.206.0.67@TBDS-3AP6176L |
+----------------------------------+

• 创建hive表

[10.206.0.90:27009] impala_test> create table t1 (id int, name string);
Query: create table t1 (id int, name string)
+-------------------------+
| summary                 |
+-------------------------+
| Table has been created. |
+-------------------------+

• 查看库中的表

[10.206.0.90:27009] impala_test> show tables;
Query: show tables
+------+
| name |
+------+
| t1   |
+------+

• 查看hive表结构

[10.206.0.90:27009] impala_test> show create table t1;
Query: show create table t1
+------------------------------------------------------------------------+
| result                                                                 |
+------------------------------------------------------------------------+
| CREATE TABLE impala_test.t1 (                                          |
|   id INT,                                                              |
|   name STRING                                                          |
| )                                                                      |
| STORED AS TEXTFILE                                                     |
| LOCATION 'hdfs://HDFS78000002/usr/hive/warehouse/impala_test.db/t1'    |
| TBLPROPERTIES ('OBJCAPABILITIES'='EXTREAD,EXTWRITE', 'accessType'='8') |
+------------------------------------------------------------------------+

• 插入数据

[10.206.0.90:27009] impala_test> insert into t1 values(1,'a');

• 查询hive表

[10.206.0.90:27009] impala_test> select * from t1;
Query: select * from t1
Query submitted at: 2023-11-28 19:26:06 (Coordinator: http://10.206.0.90:27004)
Query progress can be monitored at: http://10.206.0.90:27004/query_plan?query_id=ff47e59f75f2c718:81190e4900000000
+----+------+
| id | name |
+----+------+
| 1  | a    |
+----+------+

• 增量刷新hive表的元数据

[10.206.0.90:27009] impala_test> refresh t1;

• 销毁impala中的元数据缓存，下次使用该表将全量拉取

[10.206.0.90:27009] impala_test> invalidate metadata t1;