Hive notes
来源:互联网 发布:mmap文件阅读器 mac 编辑:程序博客网 时间:2024/06/08 06:35
hive commond:
1.hive -e “select * from mytable limit 3;
2.hive -S -e “select * from mytable limit 3” > /tmp/myquery
(no useless information like “OK Time taken:xxx seconds”)
3.hive -S -e ‘set’ | grep warehouse
(search hive ‘set’ information by bash commond)
4.hive -f /path/…/hsqlcommond.hql ——–bash commond
hive> source /path/…/hsqlcommond.hql ———-hive shell
Use hive -i filename;
1.first:search for filename.hiverc in $HIVE_HOME then excute the file;
eg:
set hive.cli.print.current.db=true; —–show current database
set hive.exec.mode.local.auto=true; ——-use local mode
set hive.cli.print.header=true —-show header
Execute bash shell commond in hive shell
hive>! echo “hello my best friend jackeylove4”;
hive>! pwd
Use hadoop dsf commond in hive shell (more efficient)
hive>dfs -ls /;
hive>dfs -put filepath hdfspath;
Hive script explain code:
--copyright (c) 2012.......--This is the best Hive script ever!select * from mytable;
- hive notes
- Hive notes
- Notes
- notes
- Notes
- notes
- notes
- notes
- notes
- Notes
- notes
- Notes
- notes
- Notes
- notes
- Notes
- Notes
- Notes
- Eclipse中配置SVN
- C++学习笔记-primer-第7章类
- CSDN图片显示不出解决方法!(新手之坑)
- IT业的风险投资
- 关于VB中的WithEvents关键字理解
- Hive notes
- 蓝桥杯java计算圆的面积
- 【软考学习】设计模式——装饰模式
- 工厂模式之简单工厂、工厂方法、抽象工厂分析对比
- Eclipse最常用快捷键
- python 3 笔记2
- Spring MVC 从实例读源码
- 20171216_C语言学习_MyfirstCode
- Hibernate主键生成celue