[jira] [Commented] (SPARK-37098) Alter table properties should invalidate cache

["Apache Spark (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-37098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17432891#comment-17432891 ] 

Apache Spark commented on SPARK-37098:
--------------------------------------

User 'ulysses-you' has created a pull request for this issue:
https://github.com/apache/spark/pull/34365

> Alter table properties should invalidate cache
> ----------------------------------------------
>
>                 Key: SPARK-37098
>                 URL: https://issues.apache.org/jira/browse/SPARK-37098
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.0.3, 3.1.2, 3.2.0, 3.3.0
>            Reporter: XiDuo You
>            Priority: Major
>
> The table properties can change the behavior of wriing. e.g. the parquet table with `parquet.compression`.
> If you execute the following SQL, we will get the file with snappy compression rather than zstd.
> {code:java}
> CREATE TABLE t (c int) STORED AS PARQUET;
> // cache table metadata
> SELECT * FROM t;
> ALTER TABLE t SET TBLPROPERTIES('parquet.compression'='zstd');
> INSERT INTO TABLE t values(1);
> {code}
> So we should invalidate the table cache after alter table properties.



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

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