在当前用户的家目录下有个.hivestory文件,里面存放了用户执行的hive操作记录,如下:
[hadoop@hadoop1 hive-0.14]$ cat ~/.hivehistory
show databases;
quit
;
quit;
create table pokes(foo int, bar string);
load data local inpath 'examples/files/kv1.txt' into table pokes
;
show tables;
show databases;
use default
;
show tables;
select * from pokes
;
select count(*) from pokes;
select * from pokes where foo=86
;
select bar from pokes where foo=86;
select bar from pokes where foo=238;