]
Steven Hawkins resolved TEIID-4989.
-----------------------------------
Resolution: Done
Added the missing quoting.
We should probably change the default import to use JDBC DatabaseMetaData now that support
has matured.
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;