You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Felipe (Jira)" <ji...@apache.org> on 2022/08/03 23:32:00 UTC

[jira] [Created] (SPARK-39971) ANALYZE TABLE makes some queries run forever

Felipe created SPARK-39971:
------------------------------

             Summary: 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


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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org