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.g...@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:nitinpawar...@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.g...@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