hive > set hive.io.output.fileformat=CSVTextFile; hive > insert overwrite local directory '/usr/home/hadoop/da1/' select * from customers
*** customers is a Hive table ________________________________ From: Edward Capriolo <[email protected]> To: "[email protected]" <[email protected]> Sent: Friday, July 5, 2013 12:10 AM Subject: Re: How Can I store the Hive query result in one file ? Normally if use set mapred.reduce.tasks=1 you get one output file. You can also look at hive.merge.mapfiles, mapred.reduce.tasks, hive.merge.reducefiles also you can use a separate tool https://github.com/edwardcapriolo/filecrush On Thu, Jul 4, 2013 at 6:38 AM, Nitin Pawar <[email protected]> wrote: will hive -e "query" > filename or hive -f query.q > filename will do ? > > >you specially want it to write into a named file on hdfs only? > > > >On Thu, Jul 4, 2013 at 3:12 PM, Matouk IFTISSEN <[email protected]> >wrote: > >Hello Hive users, >>Is there a manner to store the Hive query result (SELECT *.....) in a >>specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL >>DIRECTORY '/directory_path_name/')? >>Thanks for your answers >> >> >> > > > >-- >Nitin Pawar >
