Details

    • Sub-task
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.8.0
    • Impala 2.9.0
    • Infrastructure
    • None

    Description

      After all the INSERT upfront work, UPSERT should be relatively straightforward.

      • Modify Query object to have an UPSERT statement, and implement UpsertClause.
      • Modify QueryProfile to choose columns to be upserted
      • Modify QueryGenerator to generate UPSERT statements
      • Modify SqlWriter to write UPSERT SQL in Impala
      • Modify SqlWriter to write UPSERT SQL in PostgresQL. Note this is really “INSERT ... ON CONFLICT DO UPDATE”.
      • Hook in the same DB comparison after UPSERT that is used for INSERT

      Attachments

        Activity

          People

            mikeb Michael Brown
            mikeb Michael Brown
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: