I have a hql where I have to SET properties.
and when I try to execute name.hql it errors saying "SET: not found [No such file or directory]"
How to assign the properties in hql.
The error was I was not executing with -f option. Thanks. It is working.
To execute hql script you need to using -f with hive cli or beeline
#hive -f <File with hql> (or) with beeeline
#beeline -f <exec file>