hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashwanth Kumar <ashwanthku...@googlemail.com>
Subject Re: Any column search in HIVE
Date Mon, 30 Apr 2012 08:43:21 GMT
Try this option - In order to achieve that, create the table with ROW
FORMAT DELIMITED FIELDS TERMINATED BY ',' Now create any data you insert
into that TABLE is stored internally as CSV.

Do a $ hadoop dfs -cat /path/to/table/part-* > frequired_file.csv

It might be simpler for you to start off with, else you can use linux sed
command to replace the field separation value with , in the file that you
have at hand.

On Mon, Apr 30, 2012 at 12:50 PM, Garg, Rinku <Rinku.Garg@fisglobal.com>wrote:

>  Hi Nitin,****
>
> ** **
>
> Thanks for the quick reply. I executed the below mentioned query,  it
> creates the CSV file successfully  but data of different  columns in a row
>  is not comma separated.****
>
> ** **
>
> How can we achieve this.****
>
> ** **
>
> ** **
>
> Thanks & Regards,****
>
> *Rinku Garg*
>
> ****
>
> *From:* Nitin Pawar [mailto:nitinpawar432@gmail.com]
> *Sent:* 30 April 2012 12:18
> *To:* user@hive.apache.org
> *Subject:* Re: Any column search in HIVE****
>
> ** **
>
> you can write your query in a file ****
>
> ** **
>
> then execute the query like hive -f hive.hql > some_output_file ****
>
> ** **
>
> Thanks,****
>
> Nitin****
>
> ** **
>
> On Mon, Apr 30, 2012 at 11:28 AM, Garg, Rinku <Rinku.Garg@fisglobal.com>
> wrote:****
>
> Hi All,****
>
> We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also
> loaded a large number of CSV files into HDFS successfully. We can query
> through hive CLI.  Now we want to store the hive query output result to an
> CSV file.****
>
> Any help is appreciated.****
>
> Thanks****
>
> Rinku Garg****
>
> _____________
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.****
>
>
>
> ****
>
> ** **
>
> --
> Nitin Pawar****
>   _____________
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
>



-- 

Ashwanth Kumar / ashwanthkumar.in

Mime
View raw message