Thanks Ashok :-),
I am not so much aware about regarding storage formats in hive(I am new to
hive).
Could you please list some of them except those.
1) space seprated ------> FIELDS TERMINATED BY " ";
2) Control-A seprated --------> FIELDS TERMINATED BY '\001'
3) Tab septared ----------> FIELDS TERMINATED BY '\t'
Please list some more.
Thanks & Regards
Yogesh Kumar
> From: ashok.sa...@wipro.com
> To: user@hive.apache.org
> Subject: RE: how to load TAB_SEPRATED file in hive table
> Date: Thu, 27 Sep 2012 05:20:11 +0000
>
> '\t'
> ________________________________________
> From: yogesh dhari [yogeshdh...@live.com]
> Sent: Thursday, September 27, 2012 10:42 AM
> To: hive request
> Subject: how to load TAB_SEPRATED file in hive table
>
> Hi all,
>
> I have a file in which records are Tab-Seprated,
> Please suggest me how to upload such file in Hive table.
>
> Like how to specify
>
> Create table XYZ (name STRING, roll INT)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ????
>
> Please suggest for "????" over here.
>
>
> Thanks & Regards
> Yogesh Kumar
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should
> check this email and any attachments for the presence of viruses. The company
> accepts no liability for any damage caused by any virus transmitted by this
> email.
>
> www.wipro.com
