However, you do not need to update all values. You must specify a value for every column in your table when you perform an INSERT operation (for example, when there is no matching row in the existing dataset). This assumes that the source table has the same columns as those in the target table, otherwise the query will throw an analysis error. If you specify *, this updates or inserts all columns in the target table. id WHEN MATCHED THEN UPDATE SET * WHEN NOT MATCHED THEN INSERT * property ( "description", "table with people data" ). addColumn ( "lastName", "STRING", comment = "surname" ). execute () // Create or replace table with path and add properties DeltaTable. Create table in the metastore DeltaTable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |