can you try putting a semicolon (;) at the end of the drop table statement?

I did that but still getting the same error.

Thanks @werners

can you try with CREATE OR REPLACE table1 (instead of drop and create)?

Thanks again @werners, I tried that but still getting the same error

strange,

can you try to execute both statements in separated cells?

Like that you can see where the problem exactly is

Thank you @Werner Stinckens I was able to resolve this issue. Your assistance is much appreciated

hi @Ambrose Walker​ ,

Here is the link to the docs https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-table-d...

Here is the syntax:

CREATE TABLE [ IF NOT EXISTS ] table_identifier

[ ( col_name1 col_type1 [ COMMENT col_comment1 ], ... ) ]

USING data_source

[ OPTIONS ( key1 [ = ] val1, key2 [ = ] val2, ... ) ]

[ PARTITIONED BY ( col_name1, col_name2, ... ) ]

[ CLUSTERED BY ( col_name3, col_name4, ... )

[ SORTED BY ( col_name [ ASC | DESC ], ... ) ]

INTO num_buckets BUCKETS ]

[ LOCATION path ]

[ COMMENT table_comment ]

[ TBLPROPERTIES ( key1 [ = ] val1, key2 [ = ] val2, ... ) ]

[ AS select_statement ]

Thanks Jose.