Blog

--define or –hivevar Options

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

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

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

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

Connecting Remote Hive Server

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

 hive -f /home/hdfs/test.hql

Hive Batch Mode Commands

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

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.