#使用参数-e

[hadoop@bigdata-senior01 ~]$ hive -e "select * from busdata.weather_count"

OK

1990    900

1991    887

1992    909

1993    923

1994    873

1995    866

1996    987

1997    961

1998    853

1999    914

2000    927

Time taken: 3.221 seconds, Fetched: 11 row(s)

#加上静默开关-S，过滤ok和tim taken

[hadoop@bigdata-senior01 ~]$ hive -S -e "select * from busdata.weather_count"

1990    900

1991    887

1992    909

1993    923

1994    873

1995    866

1996    987

1997    961

1998    853

1999    914

2000    927

#结果导入到本地文件中

[hadoop@bigdata-senior01 ~]$ hive -S -e "select * from busdata.weather_count" > weather_max.txt

[hadoop@bigdata-senior01 ~]$ hive -S -e "set" | grep warehouse

hive.metastore.warehouse.dir=/hive/warehouse

[hadoop@bigdata-senior01 ~]$ cat weather_query.hql

select * from busdata.weather_count;

select * from busdata.weather_max;

[hadoop@bigdata-senior01 ~]$ hive -f /home/hadoop/weather_query.hql

#静默执行，然后结果导入文件

[hadoop@bigdata-senior01 ~]$ hive -S -f /home/hadoop/weather_query.hql >weather_mix.txt