Aleksei Shishkin created SPARK-50262:
----------------------------------------

             Summary: Forbid change complex types during altering collation
                 Key: SPARK-50262
                 URL: https://issues.apache.org/jira/browse/SPARK-50262
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Aleksei Shishkin


SPARK-48413 has brought ability to change collation on table.
But it seems to be too wide, because people couldn't change the whole 
StructType/MapType/ArrayType by altering before.
Right now there is found problem with altering collation when table has 
metadata. Altering will be failed because of a metadata mismatch between user's 
type (that doesn't have metadata) and existing schema.
So I suggest to shrink the feature to only leaf string types.
People will be able to change any collation still, but they need to use full 
column path:

{code:sql}
ALTER TABLE table ALTER COLUMN full.column.path TYPE STRING COLLATE UNICODE
{code}




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

Reply via email to