[ 
https://issues.apache.org/jira/browse/HDDS-8289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wei-Chiu Chuang resolved HDDS-8289.
-----------------------------------
    Fix Version/s: 1.4.0
       Resolution: Fixed

> Get splits in tpcds queries are way higher (10-30+ seconds) causing slowness 
> on FSO bucket
> ------------------------------------------------------------------------------------------
>
>                 Key: HDDS-8289
>                 URL: https://issues.apache.org/jira/browse/HDDS-8289
>             Project: Apache Ozone
>          Issue Type: Bug
>            Reporter: Rajesh Balamohan
>            Assignee: Ritesh Shukla
>            Priority: Critical
>              Labels: pull-request-available
>             Fix For: 1.4.0
>
>
> *Context:*
> Some queries run in Ozone were much slower than HDFS (1 TB tpcds orc format).
> *Issue:*
> getSplits in AM is super slow causing the slowness. Though getSplits run in 
> multithreaded mode for ORC, it is still slower due to internal "listStatus" 
> calls. Yet to get details on why listStatus calls are slow from Ozone side.
> Attaching AM logs here for later reference.
> Attaching AM log snippet for Q44; spent 36+ seconds in getSplits:
> Q44:
> {noformat}
> 2023-03-26 21:10:04,421 [INFO] [App Shared Pool - #25] |orc.OrcInputFormat|: 
> getSplits finished (#splits: 44). duration: 36595 ms
> 2023-03-26 21:10:04,594 [INFO] [App Shared Pool - #24] |orc.OrcInputFormat|: 
> getSplits finished (#splits: 1917). duration: 36727 ms
> 2023-03-26 21:10:04,698 [INFO] [App Shared Pool - #27] |orc.OrcInputFormat|: 
> getSplits finished (#splits: 44). duration: 36816 ms
> 2023-03-26 21:10:04,855 [INFO] [App Shared Pool - #26] |orc.OrcInputFormat|: 
> getSplits finished (#splits: 1917). duration: 36907 ms
> 2023-03-26 21:10:05,051 [INFO] [App Shared Pool - #28] |orc.OrcInputFormat|: 
> getSplits finished (#splits: 1917). duration: 37070 ms                
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to