Kris Mok created SPARK-31187:
--------------------------------

             Summary: Sort the whole-stage codegen debug output by 
codegenStageId
                 Key: SPARK-31187
                 URL: https://issues.apache.org/jira/browse/SPARK-31187
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.4.5, 2.4.4, 2.4.3, 2.4.2, 2.4.1, 2.4.0, 3.0.0
            Reporter: Kris Mok


Spark SQL's whole-stage codegen (WSCG) supports dumping the generated code to 
help with debugging. One way to get the generated code is through 
{{df.queryExecution.debug.codegen}}, or SQL {{explain codegen}} statement.

The generated code is currently printed without specific ordering, which can 
make debugging a bit annoying. This ticket tracks a minor improvement to sort 
the codegen dump by the {{codegenStageId}}, ascending.

After this change, the following query:
{code}
spark.range(10).agg(sum('id)).queryExecution.debug.codegen
{code}
will always dump the generated code in a natural, stable order.

The number of codegen stages within a single SQL query tends to be very small, 
most likely < 50, so the overhead of adding the sorting shouldn't be 
significant.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to