[jira] [Resolved] (PHOENIX-3647) Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite

["Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org>]

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

Rajeshbabu Chintaguntla resolved PHOENIX-3647.
----------------------------------------------
    Resolution: Fixed

Pushed to calcite branch. Thanks for review [~maryannxue]. Yes the documentation is out dated. Will raise doc JIRA for that.

> Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite
> --------------------------------------------------------
>
>                 Key: PHOENIX-3647
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3647
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite
>         Attachments: PHOENIX-3647.patch
>
>
> {noformat}
> 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" ...
>     "[" ...
> {noformat}    



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)