[
https://issues.apache.org/jira/browse/SPARK-42407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693723#comment-17693723
]
Pablo Langa Blanco commented on SPARK-42407:
--------------------------------------------
In my opinion, "WITH AS" syntax is intended to simplify sql queries, but not to
act at the execution level. To get what you want you can use "CACHE TABLE"
combined with 'WITH AS'.
> `with as` executed again
> ------------------------
>
> Key: SPARK-42407
> URL: https://issues.apache.org/jira/browse/SPARK-42407
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.2.3
> Reporter: yiku123
> Priority: Major
>
> When 'with as' is used multiple times, it will be executed again each time
> without saving the results of' with as', resulting in low efficiency.
> Will you consider improving the behavior of 'with as'
>
--
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
