Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> reg : reteriveing a single column from hive serde table


Copy link to this message
-
Re: reg : reteriveing a single column from hive serde table
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 <
[EMAIL PROTECTED]> 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