[ 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|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,] 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|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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org