You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Abhishek Parolkar <ab...@viki.com> on 2012/02/20 04:52:46 UTC

Hive CLI (v0.8.1) -e option trowing parse error all the time

Hi All:

  I am trying to get -e option in hive CLI work for me. Looks like it isn't
straight forward.


hadoopnode1:~ hadoop$ hive
hive> desc temp_logs;
OK
log_time string
namespace string
json string
ds string
hour string
Time taken: 2.832 seconds
hive> exit;



hadoopnode1:~ hadoop$ hive -e "desc temp_logs;"
FAILED: Parse Error: line 1:0 cannot recognize input near 'desc' '<EOF>'
'<EOF>' in describe statement



What is -e expecting the query to be?



-v_abhi_v

答复: Hive CLI (v0.8.1) -e option trowing parse error all the time

Posted by "hezhiqiang (Ransom)" <ra...@huawei.com>.

Try hive -e ‘desc temp_logs’
Whitout  “;”



Best regards
Ransom.

发件人: Abhishek Parolkar [mailto:abhishek@viki.com] 
发送时间: 2012年2月20日 11:53
收件人: user@hive.apache.org
主题: Hive CLI (v0.8.1) -e option trowing parse error all the time

Hi All:

  I am trying to get -e option in hive CLI work for me. Looks like it isn't straight forward.


hadoopnode1:~ hadoop$ hive
hive> desc temp_logs;
OK
log_time	string	
namespace	string	
json	string	
ds	string	
hour	string	
Time taken: 2.832 seconds
hive> exit; 


          
hadoopnode1:~ hadoop$ hive -e "desc temp_logs;"
FAILED: Parse Error: line 1:0 cannot recognize input near 'desc' '<EOF>' '<EOF>' in describe statement



What is -e expecting the query to be?



-v_abhi_v

Re: Hive CLI (v0.8.1) -e option trowing parse error all the time

Posted by Edward Capriolo <ed...@gmail.com>.

Someone just mentioned this.

[root@etl02 ~]# cat /usr/bin/hive
export HADOOP_HOME=/opt/hadoop-0.20.2-shell-prod
exec /opt/hive-0.7.0/bin/hive --config /opt/hive-conf/prod "$@"

Make sure it ends with "$@" no $@

On Sun, Feb 19, 2012 at 10:52 PM, Abhishek Parolkar <ab...@viki.com> wrote:
> Hi All:
>
>   I am trying to get -e option in hive CLI work for me. Looks like it isn't
> straight forward.
>
>
> hadoopnode1:~ hadoop$ hive
> hive> desc temp_logs;
> OK
> log_time string
> namespace string
> json string
> ds string
> hour string
> Time taken: 2.832 seconds
> hive> exit;
>
>
>
> hadoopnode1:~ hadoop$ hive -e "desc temp_logs;"
> FAILED: Parse Error: line 1:0 cannot recognize input near 'desc' '<EOF>'
> '<EOF>' in describe statement
>
>
>
> What is -e expecting the query to be?
>
>
>
> -v_abhi_v
>
>