[
https://issues.apache.org/jira/browse/SPARK-39971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Felipe updated SPARK-39971:
---------------------------
Description:
I'm using TPCDS to run benchmarks, and after running ANALYZE TABLE (without the
FOR ALL COLUMNS) some queries became really slow. For example query24 -
https://raw.githubusercontent.com/Agirish/tpcds/master/query24.sql takes
between 10~15min before running the ANALYZE TABLE.
After running ANALYZE TABLE I waited 24h before cancelling the execution.
If I disable spark.sql.cbo.joinReorder.enabled or
spark.sql.cbo.enabled it becomes fast again.
It seems something in join reordering is not working well when we have table
stats, but not column stats.
was:
I'm using TPCDS to run benchmarks, and after running ANALYZE TABLE (without the
FOR ALL COLUMNS) some queries became really slow. For example query24 -
[https://raw.githubusercontent.com/Agirish/tpcds/master/query24.sql|https://raw.githubusercontent.com/Agirish/tpcds/master/query24.sql,],takes
between 10~15min before running the ANALYZE TABLE.
After running ANALYZE TABLE I waited 24h before cancelling the execution.
If I disable spark.sql.cbo.joinReorder.enabled or
spark.sql.cbo.enabled it becomes fast again.
It seems something in join reordering is not working well when we have table
stats, but not column stats.
> ANALYZE TABLE makes some queries run forever
> --------------------------------------------
>
> Key: SPARK-39971
> URL: https://issues.apache.org/jira/browse/SPARK-39971
> Project: Spark
> Issue Type: Bug
> Components: Optimizer
> Affects Versions: 3.2.2
> Reporter: Felipe
> Priority: Major
>
> I'm using TPCDS to run benchmarks, and after running ANALYZE TABLE (without
> the FOR ALL COLUMNS) some queries became really slow. For example query24 -
> https://raw.githubusercontent.com/Agirish/tpcds/master/query24.sql takes
> between 10~15min before running the ANALYZE TABLE.
> After running ANALYZE TABLE I waited 24h before cancelling the execution.
> If I disable spark.sql.cbo.joinReorder.enabled or
> spark.sql.cbo.enabled it becomes fast again.
> It seems something in join reordering is not working well when we have table
> stats, but not column stats.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
