[
https://issues.apache.org/jira/browse/SPARK-44437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18129426#comment-18129426
]
Zhiwei Niu commented on SPARK-44437:
------------------------------------
I want to work on this, can it be assigned to me? Thanks!
> ALTER COLUMN to increase VARCHAR size fails
> -------------------------------------------
>
> Key: SPARK-44437
> URL: https://issues.apache.org/jira/browse/SPARK-44437
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.3.2
> Reporter: David Xiao
> Priority: Major
>
> I tried to expand a VARCHAR column by running the following commands but ran
> into an error when doing so.
>
> {code:java}
> spark.sql("DROP TABLE IF EXISTS default.test_table")
> spark.sql("CREATE TABLE default.test_table (test_col VARCHAR(10))")
> spark.sql("ALTER TABLE default.test_table ALTER COLUMN test_col TYPE
> VARCHAR(25)") {code}
>
> The error I get:
> pyspark.sql.utils.AnalysisException: ALTER TABLE CHANGE COLUMN is not
> supported for changing column 'test_col' with type 'VarcharType(10)' to
> 'test_col' with type 'VarcharType(25)'
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
