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

Switch to Plain View
Hive >> mail # user >> Any column search in HIVE


+
Garg, Rinku 2012-04-19, 12:18
+
shashwat shriparv 2012-04-19, 17:24
+
Garg, Rinku 2012-04-30, 05:58
+
Nitin Pawar 2012-04-30, 06:48
+
Garg, Rinku 2012-04-30, 07:20
+
Ashwanth Kumar 2012-04-30, 08:43
Copy link to this message
-
Re: Any column search in HIVE
or if you want the query output directly in csv format as Vinod said,

you can do

select concat(column1,","), concat(column2,",") from table
On Mon, Apr 30, 2012 at 2:13 PM, Ashwanth Kumar <
[EMAIL PROTECTED]> wrote:

> 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 <[EMAIL PROTECTED]>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:[EMAIL PROTECTED]]
>> *Sent:* 30 April 2012 12:18
>> *To:* [EMAIL PROTECTED]
>> *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 <[EMAIL PROTECTED]>
>> 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
>
>
>
--
Nitin Pawar
+
Vinod Singh 2012-04-30, 06:49