Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.8.0
    • Fix Version/s: Impala 2.9.0
    • Component/s: Infrastructure
    • Labels:
      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

            • Assignee:
              mikesbrown Michael Brown
              Reporter:
              mikesbrown Michael Brown
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: