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
