Hive hql

[Hadoop大数据]——Hive连接JOIN用例详解

http://www.cnblogs.com/xing901022/p/5804836.html

 

清空表数据

insert overwrite table t_table1 select * from t_table1 where 1=0;

 

建表

create table test_part (id int,name string,no int) partitioned by (dt string)  row format delimited fields terminated by '\t'  stored as textfile ;

 

hive中的参数传递实例

 http://blog.sina.com.cn/s/blog_7097d08d0102wc9d.html

 hive -e "select * from database_name.table_name where p_log_date= '${e_date}' limit 10;"

#使用-f选项执行hql脚本

hive -hivevar where_date=$s_date -f test.sql

---------------------------------------------------------------------------------------------------------

以下为test.sql内容：

---------------------------------------------------------------------------------------------------------

select * from database_name.table_name where p_log_date >= '${where_date}' limit 10;

 

#!/bin/sh

echo `date +%Y-%m-%d`

echo `date --date="-24 hour" +%Y-%m-%d`

echo $cur

 

para=2

database=default

#hive -e "use ${database}; select * from test2;" > log.txt

hive -hivevar tid=$para -f test.sql > log.txt

echo 'successfully'