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

Fix CREATE TABLE DDL parsing issues in Phoenix Calcaite

    XMLWordPrintableJSON

    Details

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

      Description

      Still there are parsing issues with CREATE TABLE DDL. Fix them as part of this JIRA.

      testAddDropColumns[AutoPartitionViewsIT_salted=true,multi-tenant=true](org.apache.phoenix.end2end.AutoPartitionViewsIT)  Time elapsed: 0.005 sec  <<< ERROR!
      java.sql.SQLException: 
      Error while executing SQL "CREATE TABLE T000055 (tenantId VARCHAR NOT NULL,  metricId INTEGER NOT NULL, val1 DOUBLE, CONSTRAINT PK PRIMARY KEY( tenantId,  metricId))  AUTO_PARTITION_SEQ="T000056", SALTED=4 , MULTI_TENANT=true ": parse failed: Encountered "\"T000056\"" at line 1, column 160.
      Was expecting one of:
          "+" ...
          "-" ...
          <UNSIGNED_INTEGER_LITERAL> ...
          <DECIMAL_NUMERIC_LITERAL> ...
          <APPROX_NUMERIC_LITERAL> ...
          <BINARY_STRING_LITERAL> ...
          <PREFIXED_STRING_LITERAL> ...
          <QUOTED_STRING> ...
          <UNICODE_STRING_LITERAL> ...
          "TRUE" ...
          "FALSE" ...
          "UNKNOWN" ...
          "NULL" ...
          <LBRACE_D> ...
          <LBRACE_T> ...
          <LBRACE_TS> ...
          "DATE" ...
          "TIME" ...
          "TIMESTAMP" ...
          "INTERVAL" ...
      

        Attachments

        1. PHOENIX-3617.patch
          4 kB
          Rajeshbabu Chintaguntla
        2. PHOENIX-3617_addendum.patch
          2 kB
          Rajeshbabu Chintaguntla

          Activity

            People

            • Assignee:
              rajeshbabu Rajeshbabu Chintaguntla
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: