title: Hive query - INSERT OVERWRITE LOCAL DIRECTORY creates multiple files for a single table
body: <p>I do the following from a hive table myTable.</p>
  
  <p>INSERT OVERWRITE LOCAL DIRECTORY '/myDir/out' SELECT concat_ws('',NAME,PRODUCT,PRC,field1,field2,field3,field4,field5) FROM myTable;</p>
  
  <p>So, this command generates 2 files 000000_0 and 000001_0 inside the folder out/.</p>
  
  <p>But, I need the contents as a single file. What should I do? </p>