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: [email protected]
For additional commands, e-mail: [email protected]
