You can append new data into existing scrambles.
Syntax for Appending Data to an Existing Scramble¶
[INSERT|APPEND] SCRAMBLE existingSchema.existingTable WHERE condition
- VerdictDB obtains new data from the original table used to create the scramble
existingSchema.existingTablethat satisfty given
- The same method (e.g., uniform or hash) used to create the existing scramble will be used to append new data.
- It is user's responsibility to make sure that (s)he does not append duplicate data into existing schema.
Example of Appending Data to an Existing Scramble¶
For example, if you want to add new data collected in the year of 2019 into existing scramble
ourSchema.scrmableTable (assuming the scramble only contains data up to 2018), you may issue the following query to VerdictDB:
APPEND SCRAMBLE ourSchema.scrambleTable WHERE year=2019;