[SPARK-29441] Unable to Alter table column type in spark.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.3.1
• Component/s: Spark Shell
• Labels: bulk-closed

Environment

spark -2.3

hadoop -2.4

• Assignee: Unassigned
• Reporter: prudhviraj
• Created: 11/Oct/19 15:19
• Updated: 25/May/21 01:50
• Resolved: 25/May/21 01:40

Description

Unable to alter table column type in spark.
scala> spark.sql("""alter table tablename change col1 col1 string""")
org.apache.spark.sql.AnalysisException: ALTER TABLE CHANGE COLUMN is not supported for changing column 'col1' with type 'LongType' to 'col1' with type 'StringType';