Hi #delta-community, QQ, what happens when I try a merge operation with

whenNotMatchedInsert

in a partitioned delta table? Will the newly inserted records fall under their partitions? What if a new partition should be created? Thank you!

Will delta lake support vector data(e.g. text embedding or image embedding) ? In general, it needs semantic search indexing like HNSW or ANN.

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"}