Also look at INSERT OVERWRITE LOCAL DIRECTORY feature with usage of concat function to create CSV output.
Thanks, Vinod On Mon, Apr 30, 2012 at 12:18 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: > 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 > >