[ 
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)

Reply via email to