Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104 Enable Phoenix test cases with Calcite-Phoenix
  3. PHOENIX-3647

Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      testIndexOnViewWithChildView(org.apache.phoenix.compile.QueryCompilerTest)  Time elapsed: 0.07 sec  <<< ERROR!
      java.sql.SQLException: 
      Error while executing SQL "CREATE VIEW PLATFORM_ENTITY.GLOBAL_VIEW  (
          INT1 BIGINT NOT NULL,
          DOUBLE1 DECIMAL(12, 3),
          IS_BOOLEAN BOOLEAN,
          TEXT1 VARCHAR,
          CONSTRAINT PKVIEW PRIMARY KEY
          (
              INT1
          )
      )
      AS SELECT * FROM PLATFORM_ENTITY.GLOBAL_TABLE WHERE KEY_PREFIX = '123'": parse failed: Encountered ", CONSTRAINT" at line 5, column 18.
      Was expecting one of:
          ")" ...
          "," <IDENTIFIER> ...
          "," <QUOTED_IDENTIFIER> ...
          "," <BACK_QUOTED_IDENTIFIER> ...
          "," <BRACKET_QUOTED_IDENTIFIER> ...
          "," <UNICODE_QUOTED_IDENTIFIER> ...
          "NOT" ...
          "NULL" ...
          "PRIMARY" ...
          "ASC" ...
          "DESC" ...
          "ROW_TIMESTAMP" ...
          "(" ...
          "ARRAY" ...
          "[" ...
      

        Attachments

          Activity

            People

            • Assignee:
              rajeshbabu Rajeshbabu Chintaguntla
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment