impala命令总结:
登陆命令: impala-shell
查看所有数据库: show databases;
使用数据库: use databasename;
查看所有数据表: show tables;
查询表: select * from tablename limit 10;
表结构: desc tablename;
刷新表: refresh tablename;
创建表:
create table (id string,size int)
partitioned by (date string) #指定字段分区
row format delimited fields terminated by "`" #指定字段分隔符
stored as parquet/textfile #指定数据库表存储格式
location 'hdfs path'; #指定表对应的hdfs文件目录
删除表: drop table tablename;
清空表: truncate tablename;
条件删除数据: delete from tablename where 1=1;
创建分区: alter table tablename add partition (date='2019-2-27');
查看分区: show partitions tablename;
修改表名: alter table oldtable rename to newtable;
表数据拷贝: insert into tablea select * from tableb;
表拷贝:create table tablea like tableb;
查询表状态:show table stats tableName;