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
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 abhis...@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
Re: Hive CLI (v0.8.1) -f option returns if even if just single query fails
Hi, I have a big list of data to be loaded into hive and I create a .hql file with all load statements. Problem number 1.) This fails with exception in copy files Failed with exception copyFiles: error while checking/creating destination directory!!! FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Here is what hive.log says (http://pastie.org/private/nxsvlhbunirhtcwscovzug ) Problem number 2.) even if one among all queries fail it should still go ahead and execute further queries, is there a way to not exit if the one of the statement in HQL file has failed? Is there any other way I could bulk load the data into hive table? -v_abhi_v
答复: Hive CLI (v0.8.1) -e option trowing parse error all the time
Try hive -e ‘desc temp_logs’ Whitout “;” Best regards Ransom. 发件人: Abhishek Parolkar [mailto:abhis...@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_timestring namespace string jsonstring ds string hourstring 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
