beeline !sh source command not working

[#1]

Hi All,

In beeline hql file shell commands why source filename not working and cat filename works with no issues

!sh cat filename --working

!sh source filename -- giving error

Exception raised from Shell command java.lang.Exception: Failed to execute source filename

Any help would be great

[#2]

Hi @sundar_gampa,

Not sure, why the source command is not working.

But, rather than running the shell command from beeline, you can create a shell script which has beeline command after you have sourced the required file.

[#3]

Yes that is the approach we are following. Just wondering is there any list of commands that works in HQL -shell.

Tried for document on the same but with no luck.