1. $ hive -S -e "set" | grep warehouse
hive.metastore.warehouse.dir=/user/hive/warehouse
hive.warehouse.subdir.inherit.perms=false
2. hive -S -e "select * FROM mytable LIMIT 3" > /tmp/myquery
3.hive -f /path/to/file/withqueries.hql
or $ cat /path/to/file/withqueries.hql
SELECT x.* FROM src x;
$ hive
hive> source /path/to/file/withqueries.hql;
4. You don’t need to leave the hive CLI to run simple bash shell commands. Simply
type ! followed by the command and terminate the line with a semicolon (;):
hive> ! /bin/echo "what up dog";
"what up dog"
hive> ! pwd;
/home/me/hiveplay
5. hive> dfs -ls / ;
Found 3 items
drwxr-xr-x - root supergroup
drwxr-xr-x
- edward supergroup
drwxrwxr-x - hadoop supergroup
0 2011-08-17 16:27 /etl
0 2012-01-18 15:51 /flag
0 2010-02-03 17:50 /users
6. Comments in Hive Scripts
As of Hive v0.8.0, you can embed lines of comments that start with the string --, for
example:
-- Copyright (c) 2012 Megacorp, LLC.
-- This is the best Hive script evar!!
SELECT * FROM massive_table;
7.hive> set hive.cli.print.header=true;
hive> SELECT * FROM system_logs
tstamp severity server message
1335667117.337715 ERROR server1
1335667117.338012 WARN server1
1335667117.339234 WARN server2
LIMIT 3;
Hard drive hd1 is 90% full!
Slow response from server2.
Uh, Dude, I'm kinda busy right now...