[SPARK-31048] alter hive column datatype is not supported

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.2.2
• Component/s: Spark Shell, SQL
• Labels: test

Environment

spark sql with hive metadata store.

• Assignee: Unassigned
• Reporter: Sunil Aryal
• Created: 05/Mar/20 06:38
• Updated: 12/Dec/22 18:10
• Resolved: 11/Mar/20 06:34

Description

describe tb2;
Getting log thread is interrupted, since query is done!
-----------------------------------------------+

col_name

data_type

comment

-----------------------------------------------+

fn	int	NULL
ln	string	NULL
age	int	NULL
Partition Information
col_name	data_type	comment
age	int	NULL

-----------------------------------------------+
6 rows selected (0.213 seconds)
 alter table tb2 change fn fn bigint;
Getting log thread is interrupted, since query is done!
Error: org.apache.spark.sql.AnalysisException: ALTER TABLE CHANGE COLUMN is not supported for changing column 'fn' with type 'IntegerType' to 'fn' with type 'LongType'; (state=,code=0)
java.sql.SQLException: org.apache.spark.sql.AnalysisException: ALTER TABLE CHANGE COLUMN is not supported for changing column 'fn' with type 'IntegerType' to 'fn' with type 'LongType';
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
at org.apache.hive.beeline.Commands.execute(Commands.java:848)
at org.apache.hive.beeline.Commands.sql(Commands.java:713)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:973)
at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:813)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:771)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467)