[jira] [Assigned] (SPARK-34735) Add modified configs for SQL execution in UI

["Gengliang Wang (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-34735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gengliang Wang reassigned SPARK-34735:
--------------------------------------

    Assignee: XiDuo You

> Add modified configs for SQL execution in UI
> --------------------------------------------
>
>                 Key: SPARK-34735
>                 URL: https://issues.apache.org/jira/browse/SPARK-34735
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 3.2.0
>            Reporter: XiDuo You
>            Assignee: XiDuo You
>            Priority: Minor
>             Fix For: 3.3.0
>
>         Attachments: sql-ui.jpg
>
>
> For SQL user, it's very common to add some config to optimize sql. Within a script, it would look like this
> {code:java}
> set k1=v1;
> set k2=v2;
> set ...
> INSERT INTO TABLE t1
> SELECT ...
> {code}
>  
>  It's hard to find the configs used by sql without the raw sql string. Current UI provide a `Environment` tab that we can only get some global initial config, however it's not enough.
> Some use case:
>  * Jar based job, we might set config many times due to many sql execution.
>  * SQL server e.g. (SparkThriftServer), we might execute thousands scripts every day with different session.
> We expect a feature that can list the modified configs which could affect the sql execution.
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

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