Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Parse Error


Copy link to this message
-
RE: Hive Parse Error
Don't bother trying to do Hive on Cygwin w/ Windows.

I tried a million different configurations and could never get it to
work.

I'd recommend downloading the Cloudera VM and the free VMWare player
instead for development work, since those are tried-and-true work
environments.

Travis Powell / [EMAIL PROTECTED]
-----Original Message-----
From: Sal Scalisi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 28, 2011 4:31 PM
To: [EMAIL PROTECTED]
Subject: Hive Parse Error

Hi,

I'm new to Hive and hoping someone can help me resolve an issue.  I've
Googled it, but have not been able to find a solution.
Below is my configuration info:

Windows XP SP3
Cygwin 1.7.9
Hadoop 0.20.2 (running on a single-node in a pseudo-distributed mode)
Hive 0.7.1
Java 1.6.0_26

I've been able to get Hadoop up and running, and have run several of the

sample hadoop jobs (ie wordcount).  I've installed hive and configured
it as described on the Apache Hive Getting Started page:

https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingS
tarted-Hive%2CMapReduceandLocalMode

I've configure the hadoop file system as follows:

$HADOOP_HOME/bin/hadoop fs -mkdir       /tmp
$HADOOP_HOME/bin/hadoop fs -mkdir       /user/hive/warehouse
$HADOOP_HOME/bin/hadoop fs -chmod g+w   /tmp
$HADOOP_HOME/bin/hadoop fs -chmod g+w   /user/hive/warehouse

I've set $HIVE_HOME to the hive install directory.

I kept the default configuration for the metadata store.

When I run hive, I get the 'hive>' prompt as expected.

When I try to execute SHOW TABLES;, I get the following error:

hive> SHOW TABLES;
FAILED: Parse Error: line 1:0 cannot recognize input near 'SWTABLES'
'<EOF>' '<EOF>'

The log shows the following error:
2011-06-28 16:11:59,234 ERROR ql.Driver
(SessionState.java:printError(343)) - FAILED: Parse Error: line 1:0
cannot recognize input near 'SWTABLES' '<EOF>' '<EOF>'

org.apache.hadoop.hive.ql.parse.ParseException: line 1:0 cannot
recognize input near 'SWTABLES' '<EOF>' '<EOF>'

     at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:438)
     at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:327)
     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
     at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
     at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

I've tried to reinstall hive, but that has not helped.  Any suggestions
anyone might have is greatly appreciated.

-Sal
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB