https://community.cloudera.com/t5/Support-Questions/How-to-merge-multiple-part-files-while-creating-hive-ORC/m-p/176332#M138584 <PRE>ALTER TABLE istari [PARTITION partition_spec] CONCATENATE; </PRE><P>reducing the tasks may impact the overall the performance(however alter also run mr and consume resources.) </P><P>post to your insert you can run a alter table statement.</P><P>more on the same can be found at ORC documentation</P><P><A href="https://orc.apache.org/docs/hive-ddl.html" target="_blank">https://orc.apache.org/docs/hive-ddl.html</A></P> Tue, 25 Jul 2017 11:47:52 GMT bkosaraju 2017-07-25T11:47:52Z