I am running the following query to write my select query o/p into a HDFS location. But ot creating multiple part file rather 1 single part file. Please let me know how would I create a single o/p file from this Select statement. Also let me know is there any other efficient way to save query results into a file , redirecting the SQL output using beeline or hive is having info and log detail. I just wanted to store the query o/p results only.
insert overwrite directory '/user/hive/warehouse/plane' STORED as TEXTFILE select * from planes distribute by ( tailnum);