Versions Compared

Old Version 3

changes.mady.by.user Young-Seok Kim

Saved on

compared with

New Version 4

changes.mady.by.user Young-Seok Kim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Syntax
    The syntax of the Upsert statement is similar to the syntax of the Insert statement and it is constructed as follows:

        upsert into dataset datasetname(
            query()
        );

  • Semantics
    An Upsert upsert operation couples a delete "if exists" with an insert based on the primary key of the record. The two operations are run atomically but the execution of the query doesn't happen under the same transaction context and a materialized result might be computed before upserting records into the dataset.

...