You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sam William <sa...@stumbleupon.com> on 2012/02/16 20:58:20 UTC
hive -e '' not working in 0.8.0
We recently upgraded to Hive-0.8.0 and noticed that all queries fail when run as hive -e <query> with the error ,
sampd@face:~$ hive -e "show tables;"
FAILED: Parse Error: line 1:0 cannot recognize input near 'show' '<EOF>' '<EOF>' in ddl statement
hive -f option works though . Has anyone else faced this ?
Sam William
sampd@stumbleupon.com
Re: hive -e '' not working in 0.8.0
Posted by Sam William <sa...@stumbleupon.com>.
Sorry guys, I figured this out. We have a shell script that sets the env variables and then calls the standard hive-0.8.0/bin/hive "$@" . The problem was that the quotes around $@ were missing and the hive executable was just getting the first word .
It was just my bad.
Thanks,
Sam
On Feb 16, 2012, at 12:07 PM, Carl Steinbach wrote:
> Hi Sam,
>
> I tried running this against the hive-0.8.0 release tarball and did not encounter any problems.
> Is it possible that you have some old JARs or shell scripts hanging around from a previous Hive install?
>
> On Thu, Feb 16, 2012 at 11:58 AM, Sam William <sa...@stumbleupon.com> wrote:
> We recently upgraded to Hive-0.8.0 and noticed that all queries fail when run as hive -e <query> with the error ,
>
>
> sampd@face:~$ hive -e "show tables;"
>
> FAILED: Parse Error: line 1:0 cannot recognize input near 'show' '<EOF>' '<EOF>' in ddl statement
>
>
> hive -f option works though . Has anyone else faced this ?
>
> Sam William
> sampd@stumbleupon.com
>
>
>
>
Sam William
sampd@stumbleupon.com
Re: hive -e '' not working in 0.8.0
Posted by Carl Steinbach <ca...@cloudera.com>.
Hi Sam,
I tried running this against the hive-0.8.0 release tarball and did not
encounter any problems.
Is it possible that you have some old JARs or shell scripts hanging around
from a previous Hive install?
On Thu, Feb 16, 2012 at 11:58 AM, Sam William <sa...@stumbleupon.com> wrote:
> We recently upgraded to Hive-0.8.0 and noticed that all queries fail
> when run as hive -e <query> with the error ,
>
>
> sampd@face:~$ hive -e "show tables;"
>
> FAILED: Parse Error: line 1:0 cannot recognize input near 'show' '<EOF>'
> '<EOF>' in ddl statement
>
>
> hive -f option works though . Has anyone else faced this ?
>
> Sam William
> sampd@stumbleupon.com
>
>
>
>