You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2017/02/03 22:38:51 UTC
[jira] [Issue Comment Deleted] (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 ]
Maryann Xue updated PHOENIX-3647:
---------------------------------
Comment: was deleted
(was: Thank you, [~rajeshbabu]! I will open a JIRA for the documentation. But looks like your CI has caused some regression (~30 tests), could you please take a look? As a quick example, there's one regression in CalciteDDLIT.)
> 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)