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/02/03 04:25:52 UTC
[jira] [Updated] (PHOENIX-3647) Fix parsing issues in CREATE VIEW
DDL in Phoenix-Calcite
[ https://issues.apache.org/jira/browse/PHOENIX-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajeshbabu Chintaguntla updated PHOENIX-3647:
---------------------------------------------
Attachment: PHOENIX-3647.patch
[~maryannxue] Here is the patch fixes view ddl parsing issue. Please review.
> 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)