select * will just hdfs cat your file when you are using serde, do you have column separator in place? if not can you do select * from table limit 1
to get normally a single coulmn you should do select column from table where column=value On Mon, Dec 17, 2012 at 1:51 PM, Mohit Chaudhary01 < mohit_chaudhar...@infosys.com> wrote: > Hi**** > > I am using serde in hive to store data into hive table from xml file. **** > > Whenever I retrieve data using command select * from table it give all > records from table.**** > > ** ** > > But when I want to extract an individual column it gives error .**** > > *Please Tell me how can I retrieve a single column from this table.* > > * * > > *Thanks * > > *Mohit chaudhary* > > **************** 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*** > > -- Nitin Pawar
