[PHOENIX-6148] [SchemaExtractionTool]DDL parsing exception in Phoenix in view name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Swaroopa Kadam
• Reporter: Swaroopa Kadam
• Created: 21/Sep/20 17:43
• Updated: 08/Feb/21 20:34
• Resolved: 08/Jan/21 22:03

Description

584 org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered ".0" at line 1, column 28.

585     at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)

586     at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)

Seeing this when parsing create view statement generated from SchemaExtractionTool as below: 

CREAT VIEW TEST.04KA AS SELECT * FROM TEST.TABLE_NAME;

Issue Links

• links to: GitHub Pull Request #900
• links to: GitHub Pull Request #1135