[jira] [Assigned] (SPARK-51747) Data source cached plan should respect options

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

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

Gengliang Wang reassigned SPARK-51747:
--------------------------------------

    Assignee: Amanda Liu

> Data source cached plan should respect options
> ----------------------------------------------
>
>                 Key: SPARK-51747
>                 URL: https://issues.apache.org/jira/browse/SPARK-51747
>             Project: Spark
>          Issue Type: Task
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Amanda Liu
>            Assignee: Amanda Liu
>            Priority: Major
>              Labels: pull-request-available
>
> Before this, DataSourceStrategy caches the first query plan and does not respect options.
> For example,
>  
> {code:java}
> spark.sql("CREATE TABLE t(a string, b string) USING CSV".stripMargin)
> spark.sql("INSERT INTO TABLE t VALUES ('a;b', 'c')")
>  
> spark.sql("SELECT * FROM t").show()
> spark.sql("SELECT * FROM t WITH ('delimiter' = ';')"){code}
>  
>  
> Expected output:
>  
> {code:java}
> +----+----+
> |col1|col2|
> +----+----+
> | a;b|   c|
> +----+----+
> +----+----+
> |col1|col2|
> +----+----+
> |   a| b,c|
> +----+----+ {code}
>  
>  
> Output before this JIRA:
>  
> {code:java}
> +----+----+
> |col1|col2|
> +----+----+
> | a;b|   c|
> +----+----+
> +----+----+
> |col1|col2|
> +----+----+
> | a;b|   c|
> +----+----+ {code}
>  



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