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]<mailto:[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.
