You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org> on 2017/01/23 15:59:26 UTC

[jira] [Updated] (PHOENIX-3617) Fix CREATE TABLE DDL parsing issues in Phoenix Calcaite

     [ https://issues.apache.org/jira/browse/PHOENIX-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajeshbabu Chintaguntla updated PHOENIX-3617:
---------------------------------------------
    Attachment: PHOENIX-3617.patch

Here is the patch fixes couple of parsing issues in CREATE TABLE DDL queries. [~maryannxue] [~jamestaylor] please review.

> Fix CREATE TABLE DDL parsing issues in Phoenix Calcaite
> -------------------------------------------------------
>
>                 Key: PHOENIX-3617
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3617
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite
>         Attachments: PHOENIX-3617.patch
>
>
> Still there are parsing issues with CREATE TABLE DDL. Fix them as part of this JIRA.
> {noformat}
> 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" ...
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)