how to use loop in hive

[#1]

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

[#2]

@Anbu Eswaran

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

[#3]

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

[#4]

Hi @Mahesh Mallikarjunappa

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

[#5]

Thanks its working fine now. sorry for the delay reply

[#6]

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