1.执行select查询
$HIVE_HOME/bin/hive -e 'select a.col from tab1 a'
$HIVE_HOME/bin/hive -e "use mydb;select a.col from tab1 a where a.dt='2015-01-07';"
2.加入配置变量的查询
$HIVE_HOME/bin/hive -e 'select a.col from tab1 a' -hiveconf hive.exec.scratchdir=/home/my/hive_scratch -hiveconf mapred.reduce.tasks=32
3.查询结果输出为文本
$HIVE_HOME/bin/hive -S -e 'select a.col from tab1 a' > a.txt
4.执行sql语句文件
$HIVE_HOME/bin/hive -f /home/my/hive-script.sql
#!/bin/bash
#设置日志文件存放目录
cd /
cd /home/deploy/recsys/workspace
yesterday=$(date -d '-1 day' '+%Y-%m-%d')
$HIVE_HOME/bin/hive -e "use mydb;ALTER TABLE mytable ADD PARTITION (dt = '$yesterday') LOCATION '/user/hive/warehouse/tail/$yesterday/';"
#$HIVE_HOME/bin/hive -e "use mydb;select msec from mytable where dt='2015-01-07'"