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

Support mixing table columns with extended columns in DML

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.11.0
    • 1.14.0
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment