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

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    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_addendum.patch
          2 kB
          Rajeshbabu Chintaguntla
        2. PHOENIX-3617.patch
          4 kB
          Rajeshbabu Chintaguntla

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: