Creating a delta table Mismatch Input Error

[Brose]

I am trying to create a delta table for streaming data, but I am getting the following error; Error in SQL statement: ParseException:

mismatched input 'CREATE' expecting {<EOF>, ';'}(line 2, pos 0).

My statement is as follows;

%sql

DROP TABLE IF EXISTS table1

CREATE TABLE table1 (

  col_1 STRING,

  col_2 STRING,

  col_date_1 DATE,

  col_dat_2 DATE,

  col_3 Double,

  col_4 Double,

) USING DELTA

I can't figure out why I am getting this error.

[-werners-]

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

[Brose]

I did that but still getting the same error.

Thanks @werners

[-werners-]

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

[Brose]

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

[-werners-]

strange,

can you try to execute both statements in separated cells?

Like that you can see where the problem exactly is

[Brose]

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

[jose_gonzalez]

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 ]

[Brose]

Thanks Jose.

[Anonymous]

@Ambrose Walker​ - If Jose's answer resolved your issue, would you be happy to mark that post as best? That will help others find the solution more quickly.