.hivehistory

在当前用户的家目录下有个.hivestory文件，里面存放了用户执行的hive操作记录，如下：

1. [hadoop@hadoop1 hive-0.14]$ cat ~/.hivehistory
2. show databases;
3. quit
4. ;
5. quit;
6. create table pokes(foo int, bar string);
7. load data local inpath 'examples/files/kv1.txt' into table pokes
8. ;
9. show tables;
10. show databases;
11. use default
12. ;
13. show tables;
14. select * from pokes
15. ;
16. select count(*) from pokes;
17. select * from pokes where foo=86
18. ;
19. select bar from pokes where foo=86;
20. select bar from pokes where foo=238;

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/lishouguang/p/4560587.html