]
Steven Hawkins updated TEIID-4989:
----------------------------------
Issue Type: Bug (was: Enhancement)
Fix Version/s: 10.0
9.3.2
Impala - Select * fails with reserved words in query
----------------------------------------------------
Key: TEIID-4989
URL:
https://issues.jboss.org/browse/TEIID-4989
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 9.1.3
Environment: Ubuntu linux 6+ x64
Reporter: Don Krapohl
Assignee: Steven Hawkins
Priority: Minor
Fix For: 10.0, 9.3.2
Impala translator can handle reserved words in queries by quoting but doing select * the
query fails in an unhelpful way. Example:
--succeeds
select calendar_type,
start_date,
calendar_year,
quarter_structure,
date_key,
'month',
week,
day_of_month
from warehouse.dim_advertiser_calendar;
fails due to reserved word "month" as a column in the virtual table:
select * from warehouse.dim_advertiser_calendar;