You can use one of those query to reduce num of file in insert query, so it will increase the file size: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#LanguageManualSortBy-SyntaxofClusterByandDistributeBy ... View more

issue resolved with your solution, thanks   CDH 6.3.3 ... View more