CDH_impala

CDH中安装impala
连接impala

[[email protected] bin]# impala-shell -i hadoop122
Starting Impala Shell without Kerberos authentication
Connected to hadoop122:21000
Server version: impalad version 2.9.0-cdh5.12.1 RELEASE (build 5131a031f4aa38c1e50c430373c55ca53e0517b9)
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v2.9.0-cdh5.12.1 (5131a03) built on Thu Aug 24 09:27:32 PDT 2017)

When you set a query option it lasts for the duration of the Impala shell session.
***********************************************************************************

建表

[hadoop122:21000] > create table student(id int, name string)
                  > row format delimited
                  > fields terminated by '\t';
Query: create table student(id int, name string)
row format delimited
fields terminated by '\t'

Fetched 0 row(s) in 0.69s

插入数据

[hadoop122:21000] > insert into table student values(1001, 'ruirui');
Query: insert into table student values(1001, 'ruirui')
Query submitted at: 2019-05-31 14:47:18 (Coordinator: http://hadoop122:25000)
Query progress can be monitored at: http://hadoop122:25000/query_plan?query_id=5d41e31aac4f7aee:7cac8be500000000
Modified 1 row(s) in 0.95s