- 2716 Views
- 2 replies
- 3 kudos
Resolved! Error creating delta table over an existing delta schema
I created a delta table through a cluster over a dbfs location .Schema :create external table tmp_db.delta_data(delta_id int ,delta_name varchar(20) , delta_variation decimal(10,4) ,delta_incoming_timestamp timestamp,delta_date date generated always ...
- 2716 Views
- 2 replies
- 3 kudos
- 3 kudos
varchartype is only available as from spark 3.1 I think.https://spark.apache.org/docs/latest/sql-ref-datatypes.htmlThe link is for spark 3.2, and 3.1 also has varchartype. So can you check your spark version?Also if the table definition still exists...
- 3 kudos
- 12872 Views
- 9 replies
- 2 kudos
Creating a delta table Mismatch Input Error
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;%sqlDROP TABLE IF EXISTS ...
- 12872 Views
- 9 replies
- 2 kudos
- 2 kudos
@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.
- 2 kudos