[ https://issues.apache.org/jira/browse/HIVE-15368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15890216#comment-15890216 ]
Steve Loughran commented on HIVE-15368: --------------------------------------- If you can use {{FileSystem.listFiles(path, recursive=true}} then s3a on Hadoop 2.8 can give you an O(files/5000) listing, rather than the treewalk you can get today. I'd recommend trying to use it; the other object stores can no doubt implement the same operation. > consider optimizing Utilities::handleMmTableFinalPath > ----------------------------------------------------- > > Key: HIVE-15368 > URL: https://issues.apache.org/jira/browse/HIVE-15368 > Project: Hive > Issue Type: Sub-task > Affects Versions: 0.3.0 > Reporter: Rajesh Balamohan > Attachments: HIVE-15368.branch.14535.1.patch > > > Branch: hive-14535 > https://github.com/apache/hive/blob/hive-14535/ql/src/java/org/apache/hadoop/hive/ql/exec/Utilities.java#L4049 > When running "insert overwrite...on partitioned table" with 2000+ partitions, > good amount of time (~245 seconds) was spent in iterating every mmDirectory > entry and checking its file listings in S3. Creating this jira to consider > optimizing this codepath, as information from {{getMmDirectoryCandidates}} > could be used in terms of reducing the number of times S3 needs to be > contacted. -- This message was sent by Atlassian JIRA (v6.3.15#6346)