ALTER Not Working in Databricks for external Table.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Hi Team,
i am getting error alter not suported .
col1 DOUBLE NOT CONVERTING TO col1 DECIMAL(31,5) VIA ALTER STATEMENT.
ERROR-
liquibase.exception.DatabaseException: [Databricks][JDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: 0A000, Query:
ALTER TABL***, Error message from Server: org.apache.hive.service.cli.HiveSQLException: Error running query: [NOT_SUPPORTED_CHANGE_COLUMN]
org.apache.spark.sql.catalyst.ExtendedAnalysisException: [NOT_SUPPORTED_CHANGE_COLUMN] ALTER TABLE ALTER/CHANGE COLUMN is not supported for.. Any suggestion , would be appreciate.