[IMPALA-941] Impala Parser issue when using fully qualified table names that start with a number.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 1.2.4
• Fix Version/s: Impala 3.2.0
• Component/s: Frontend
• Labels: customer newbie
• Target Version: Product Backlog
• Assignee: Fredy Wijaya
• Reporter: Udai Kiran Potluri
• Created: 09/Apr/14 18:00
• Updated: 28/Sep/20 18:04
• Resolved: 14/Nov/18 14:57

Description

Impala Parser issue when using fully qualified table names that start with a number.
What is going wrong is that Impala is parsing the table name as a floating point literal since the text starts with a number and contains a period.

INVALIDATE METADATA db.571_market; 
Query: invalidate METADATA db.571_market 
ERROR: AnalysisException: Syntax error in line 1: 
invalidate METADATA db.571_market 
^ 
Encountered: FLOATING POINT LITERAL 
Expected: ADD, AS, CHANGE, COMMENT, CROSS, DROP, FULL, GROUP, HAVING, INNER, JOIN, LEFT, LIKE, LIMIT, LOCATION, ON, ORDER, PARTITION, RENAME, REPLACE, RIGHT, ROW, SELECT, SET, STORED, TBLPROPERTIES, UNION, USING, VALUES, WHERE, WITH, COMMA, IDENTIFIER 

Issue Links

• relates to: IMPALA-6848 Field Names Parsed as Decimal