Hi @turagittech,

The above error indicates that your table seems to be in DELTA format. Please check the table creation statement, if the table format is JSON or DELTA.

PS: By default, if you are not specifying any format while creating the table on top of your JSON files in external storage, the table will be created in DELTA format.

Following link indicates the error detail you are facing while doing MSCK Repair: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-alter-table-manage-partiti...

Please check over here for suitable create table statement for your use-case: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-table-using#syntax

Let us know if you find this helpful, or if more clarifications needed.


Best Regards,
Nivethan V