phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3647) Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite
Date Fri, 03 Feb 2017 22:43:51 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15852246#comment-15852246
] 

Maryann Xue commented on PHOENIX-3647:
--------------------------------------

Doc issue created as https://issues.apache.org/jira/browse/PHOENIX-3653.

> 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)

Mime
View raw message