Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1709

Support mixing table columns with extended columns in DML

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:
      None

      Description

      Phoenix allows embedding dynamic column definitions in the UPDATE target column list whereas Calcite requires that extended columns be specified separately from the target columns.

      ie.
      Phoenix

      UPSERT INTO EventLog
      (eventId, eventTime, eventType, lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT)
      VALUES (1, CURRENT_TIME(), ‘abc’, CURRENT_TIME(), 512, 1024);
      

      Calcite

      UPSERT INTO EventLog
      (lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT)
      (eventId, eventTime, eventType, lastGCTime, usedMemory, maxMemory)
      VALUES (1, CURRENT_TIME(), ‘abc’, CURRENT_TIME(), 512, 1024);
      

      We should have a conformance setting for this feature. https://issues.apache.org/jira/browse/PHOENIX-3732?focusedCommentId=15930704&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15930704

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rajeshbabu Rajeshbabu Chintaguntla
                Reporter:
                kliew Kevin Liew
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: