How can we pass multiple hql files to hive/beeline?

Question

I want to run file_1.hql and file_2.hql in one hive session. How can I do that? I was thinking of passing both files as hive -f file_1.hql file_2.hql. But -f only takes one file. Any suggestion?

Use `source` hive command: https://stackoverflow.com/a/46847977/2700344 You can include many `source` commands in your script — leftjoin, Feb 14 '18 at 21:43

parisni · Answer 1 · 2018-02-15T09:28:36.410

3

What about using bash:

hive -e "$(cat file1.hql file2.hql)"

edited Feb 15 '18 at 09:28

answered Feb 14 '18 at 23:13

parisni

920
7
20

Updated solution works, but cat showdata1.sql showdata.sql | hive -f - never worked – roh Feb 15 '18 at 14:16
glad your tests succeed; do not hesitate to star – parisni Feb 15 '18 at 16:48

How can we pass multiple hql files to hive/beeline?

1 Answers1