Hi,
I have setup a two node hadoop cluster, and tested it by
running examples provided with Hadoop. Examples are working fine. then I tried
to run hive on the cluster. I was able to create tables and load data into
tables. And also the query : "select * from tablename" is working fine. But
when I try to run a query with where option :
hive> select * from tablename where column_name='Value';
I get the following error
Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver
The jobdetails.jsp shows the following:
java.lang.RuntimeException: java.util.NoSuchElementException
at org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities.
java:168)
at
org.apache.hadoop.hive.ql.io.HiveInputFormat.init(HiveInputFormat.java:235)
at
org.apache.hadoop.hive.ql.io.HiveInputFormat.initColumnsNeeded(HiveInputForm
at.java:311)..............
............
I am using hive's derby only and not MySQL or any other DB for metastore. And
most of the settings are having their default values in Hadoop, except for the
minimum changes needed to run the cluster. There is no hive-site.xml as I
haven't changed any of the hive's properties.
Please tell me what is wrong and what do I need to do.
Regards,
Aditya Singh
Infosys, India.
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not
to copy, disclose, or distribute this e-mail or its contents to any other
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has
taken
every reasonable precaution to minimize this risk, but is not liable for any
damage
you may sustain as a result of any virus in this e-mail. You should carry out
your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this
e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
