Is anyone faced this problem: %sql
create table if not exists gold_db.people_df_ext(
id INT,
firstname string,
lastname string,
birthdate date
) using delta
location "/FileStore/tables/delta-demo/people_df";
AnalysisException: The specified schema does not match the existing schema at dbfs:/FileStore/tables/delta-demo/people_df.
== Specified ==
root
|-- id: integer (nullable = true)
|-- firstname: string (nullable = true)
|-- lastname: string (nullable = true)
|-- birthdate: date (nullable = true)
== Existing ==
root
|-- id: integer (nullable = true)
|-- firstname: string (nullable = true)
|-- lastname: string (nullable = true)
|-- birthdate: date (nullable = true)
== Differences ==
- Specified metadata for field birthdate is different from existing schema:
Specified: {}
Existing: {"__detected_date_formats":"yyyy-M-d"} (edited)