DeltaLakeCRUDSpec: A Delta table - should be created and populated + Given a table created with SQL CREATE TABLE DeltaLakeCRUDSpec ( id int, label String, partitionKey long, date Date, timestamp Timestamp ) USING DELTA + When we write 20 rows to DeltaLakeCRUDSpec + Then the table indeed contains all the data + And the metastore contains a reference to the table DeltaLakeCRUDSpec + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - should support updates with 'update DeltaLakeCRUDSpec set label='ipse locum'' + Given SQL update DeltaLakeCRUDSpec set label = 'ipse locum' + When we execute it + Then all rows are updated + And look like: Datum(10,ipse locum,0,2023-12-01,2023-12-11 13:43:17.664) Datum(11,ipse locum,1,2023-11-30,2023-12-11 13:43:17.864) Datum(12,ipse locum,2,2023-11-29,2023-12-11 13:43:18.064) ... + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - should be able to have its schema updated + Given SQL ALTER TABLE DeltaLakeCRUDSpec ADD COLUMNS (new_string string comment 'new_string docs') + When we execute it + Then all rows are updated + And look like: [10,ipse locum,0,2023-12-01,2023-12-11 13:43:17.664,null] [11,ipse locum,1,2023-11-30,2023-12-11 13:43:17.864,null] [12,ipse locum,2,2023-11-29,2023-12-11 13:43:18.064,null] ... + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Run completed in 51 seconds, 680 milliseconds. Total number of tests run: 8 Suites: completed 4, aborted 0 Tests: succeeded 8, failed 0, canceled 0, ignored 0, pending 0 All tests passed.