question Re: impala-shell -f No such file or directory in Archives of Support Questions (Read Only)

impala-shell -f No such file or directory

AlinaGHERMAN — Fri, 16 Sep 2022 09:20:17 GMT

Hello,

I'm having a script file that I want to run with impala-shell.

When I do :

hadoop dfs -ls /user/developer/scripts/Impala/

I can see my file

However, when I try to do it in impala I get no such file or directory.

impala-shell -f /user/developer/scripts/Impala/myFile

What should I check? Why is impala not finding my file?

Thank you!

Re: impala-shell -f No such file or directory

HenryR — Mon, 26 Jan 2015 15:47:29 GMT

Hi -

The Impala shell is looking for the file in your *local* filesystem, not on HDFS. It does not currently support reading input scripts from HDFS. So to make this work, copy the file locally with hdfs -fs get <path to your file> <local path>, and then run impala-shell -f <local path>.

Best,

Henry

Re: impala-shell -f No such file or directory

AlinaGHERMAN — Tue, 27 Jan 2015 10:28:04 GMT

However, with this solution I have a problem… I do not know on which instance from my cluster is the file downloaded (I want shedule my task with oozie)

Re: impala-shell -f No such file or directory

jackssqcyy — Fri, 13 Feb 2015 06:51:45 GMT

I had the same issue , I have to make each statement in SQL file to be impala-shell -q *.

Even it can work but I think it is so ugly and will be disaster when you have lots of statements !

I had raised the issue at this post before :

http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-schedule-with-oozie-tutorial/m-p/24604#M727