https://community.cloudera.com/t5/Support-Questions/How-to-merge-multiple-part-files-while-creating-hive-ORC/m-p/176330#M138582 <P>HI </P><P>I' am using INSERT OVERWRITE DIRECTORY to create a ORC file as shown below.</P><P>insert overwrite directory '/hdfs/temp_table/' stored as ORC </P><P>select COL_1 ,COL_2, COL_3...FROM TMP_TABLE;</P><P>I' am getting multiple part files in the results when i run this query , which i want to reduce to 1 single ORC file.</P><P>How can i merge all the small partfiles into a single file?</P><P>Thanks</P> Wed, 17 May 2017 16:51:33 GMT saravanan_p1 2017-05-17T16:51:33Z