Hive CLI Command

--define or –hivevar Options

1 2 3 4 5 6 7 8 9 10

hdfs@ubuntu1:~$ hive --define address='country, state, city, post' hive> select ${address} from temp_hdfs limit 5; OK country     state   city         post AU        TA        Leith       7315 AU        QL        Proston   4613 AU        WA        Hame     l  6215 AU        NS        Talmalmo    2640 Time taken: 0.57 seconds, Fetched: 5 row(s) hive>

-- database Option

1 2 3 4 5

hdfs@ubuntu1 $ hive --database testdb               or    hive> use testdb;

-s, -e Options, Environment variables & Redirecting Output to File

1 2	$ export VAR1='London' $ hive -S -e "SELECT firstname, state, city FROM temp_hdfs WHERE city='${VAR1}'" > temp_out.txt

Connecting Remote Hive Server

1 2 3 4 5 6 7 8 9 10

hdfs@tri03ws-386:~$ hive -h 172.16.3.78 -p 10000    Logging initialized using configuration in jar:file:/home/hdfs/bigdata/apache-hive-0.14.0-bin/lib/hive-common-0.14.0.jar!/hive-log4j.properties ............... [172.16.3.78:10000] hive> show tables; adapter mytest page_view page_view14 emp

Running Queries from file

1	hive -f /home/hdfs/test.hql

Hive Batch Mode Commands

1 2	hive -e "<query-string>" hive -f <filepath>  – executes one or more SQL queries from a file