1. desc extended/formated tablename
描述表结构,如:
desc extended im;
desc formatted im;
2. bin/hive -e -f
-e 不进入hive命令行执行sql语句,如:
bin/hive -e "select * from im" --database jiazu > ~/Desktop/im.txt
-f 执行外部sql文件,如:
bin/hive -f ~/Desktop/1.sql > ~/Desktop/im.txt
! [命令] 不退出hive执行shell命令,如:
! pwd;
dfs 操作hdfs文件系统命令,如:
dfs -ls;
create external table location 创建外部表,如:
hive (jiazu)> create external table if not exists im_external (
> id int,
> fuid int,
> tuid int,
> ctime date
> ) row format delimited fields terminated by '\t'
> location '/user/hive/warehouse/jiazu.db/im';
通过子查询建表,如:
create table im_select as select fuid, tuid from im_external;
like建表,如:
create table im_like like im_select;
数据导出
insert overwrite local directory '~/Desktop/im' row format delimited fields terminated by ',' select * from im_count;