David Xiao created SPARK-44437: ---------------------------------- Summary: 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
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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org