question how to use loop in hive in Support Questions

how to use loop in hive

anbu_eswaran — Wed, 19 Oct 2016 17:52:11 GMT

I want to insert the table more than 100. Is it possible to do it in for loop in hql. if yes, please share it

grajagopal — Wed, 19 Oct 2016 23:48:34 GMT

Just add the records to a file and LOAD the file to Hive.

maheshmsh88 — Fri, 21 Oct 2016 13:16:26 GMT

HI,

Please refer below example.

With a little bash we can loop through all our tables, appending the results to a file: #get a list of the files

hive -e "show tables;" > hivetables.txt

Now — cool stuff:

for line in $(cat hivetables.txt) ; 
do 
     results=$(hive -hiveconf tablename=$line -f test.hql) 
     echo $results >> tablecounts.txt

done

Hope this will be helpful.

Thanks,

Mahesh

anbu_eswaran — Thu, 22 Dec 2016 21:47:22 GMT

Thanks its working fine now. sorry for the delay reply

aervits — Fri, 23 Dec 2016 00:20:40 GMT

@Anbu Eswaran please select the best answer as we don't know which answer helped most.

vamsi123 — Sun, 08 Jan 2017 00:25:10 GMT

what is the purpose of test.hql? logic behind it?