[ https://issues.apache.org/jira/browse/SPARK-16188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16131772#comment-16131772 ]
xianlongZhang commented on SPARK-16188: --------------------------------------- cen yuhai,thanks for your advice, but my company's data platform processed tens of thousands of sql query every day , it is not practical to modify each sql , so I think add a common mechanism to deal with this problem is the most suitable solution > Spark sql create a lot of small files > ------------------------------------- > > Key: SPARK-16188 > URL: https://issues.apache.org/jira/browse/SPARK-16188 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 1.6.0 > Environment: spark 1.6.1 > Reporter: cen yuhai > > I find that spark sql will create files as many as partition size. When the > results are small, there will be too many small files and most of them are > empty. > Hive have a function to detect the avg of file size. If avg file size is > smaller than "hive.merge.smallfiles.avgsize", hive will add a job to merge > files. -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org