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 <matouk.iftis...@ysance.com>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