Creating a delta table Mismatch Input Error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2021 07:09 PM
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.
Labels:
- Labels:
-
Delta Table Mismatch
-
Delta-lake
-
SQL