How to run hive script from hive cli

Question

I have hive script custsales.hql now I want to run it from hive cli as

hive (pract5)> run /user/training/hdfs_location/custsales.hql

but it does not execute. Please guide. I know we can run it from command line with

$ hive -f /home/training/local_location/custsales.hql

but this is not my requirement.

Thank you very much leftjoin it is working with source command.What is AFAIK. — user8167344, Oct 20 '17 at 10:21

score 4 · Accepted Answer · answered Oct 20 '17 at 11:15

4

Use source path/to/script command.

answered Oct 20 '17 at 11:15

leftjoin

1 Answers1