[PHOENIX-3647] Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 02/Feb/17 16:20
• Updated: 03/Feb/17 22:43
• Resolved: 03/Feb/17 07:45

Description

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" ...
    "[" ...