[PHOENIX-3617] Fix CREATE TABLE DDL parsing issues in Phoenix Calcaite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 23/Jan/17 09:35
• Updated: 24/Jan/17 16:21
• Resolved: 24/Jan/17 06:17

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" ...