hey Aditya!! col values is case sensitive so u have to put exact value .
select * from table where col_name=*'EXACT_VALUE'* regards Vikas Srivastava On Tue, Nov 8, 2011 at 5:17 PM, Aditya Singh30 <aditya_sing...@infosys.com>wrote: > 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*** > > -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
