[
https://issues.apache.org/jira/browse/SPARK-48338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871248#comment-17871248
]
David Milicevic edited comment on SPARK-48338 at 8/6/24 8:56 AM:
-----------------------------------------------------------------
[~maxgekk] nope, it was accidentally done - it was closed instead of this one:
https://issues.apache.org/jira/browse/SPARK-48345 because the
[https://github.com/apache/spark/pull/47404] had wrong tag by accident... Could
you please close the proper one and reopen this one?
EDIT: sorted it out myself, didn't know I had permissions :)
was (Author: JIRAUSER304692):
[~maxgekk] nope, it was accidentally done - it was closed instead of this one:
https://issues.apache.org/jira/browse/SPARK-48345 because the
[https://github.com/apache/spark/pull/47404] had wrong tag by accident... Could
you please close the proper one and reopen this one?
> Sql Scripting support for Spark SQL
> -----------------------------------
>
> Key: SPARK-48338
> URL: https://issues.apache.org/jira/browse/SPARK-48338
> Project: Spark
> Issue Type: Epic
> Components: Spark Core
> Affects Versions: 4.0.0
> Reporter: Aleksandar Tomic
> Assignee: Aleksandar Tomic
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: Sql Scripting - OSS.odt, [Design Doc] Sql Scripting -
> OSS.pdf
>
>
> Design doc for this feature is in attachment.
> High level example of Sql Script:
> ```
> BEGIN
> DECLARE c INT = 10;
> WHILE c > 0 DO
> INSERT INTO tscript VALUES (c);
> SET c = c - 1;
> END WHILE;
> END
> ```
> High level motivation behind this feature:
> SQL Scripting gives customers the ability to develop complex ETL and analysis
> entirely in SQL. Until now, customers have had to write verbose SQL
> statements or combine SQL + Python to efficiently write business logic.
> Coming from another system, customers have to choose whether or not they want
> to migrate to pyspark. Some customers end up not using Spark because of this
> gap. SQL Scripting is a key milestone towards enabling SQL practitioners to
> write sophisticated queries, without the need to use pyspark. Further, SQL
> Scripting is a necessary step towards support for SQL Stored Procedures, and
> along with SQL Variables (released) and Temp Tables (in progress), will allow
> for more seamless data warehouse migrations.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
