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