https://delta.io logo
a

Ananda_de

07/16/2023, 8:12 PM
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)