[teiid-issues] [JBoss JIRA] (TEIID-4989) Impala - Select * fails with reserved words in query

[Don Krapohl (JIRA)]

Don Krapohl created TEIID-4989:
----------------------------------

             Summary: Impala - Select * fails with reserved words in query
                 Key: TEIID-4989
                 URL: https://issues.jboss.org/browse/TEIID-4989
             Project: Teiid
          Issue Type: Enhancement
          Components: JDBC Connector
    Affects Versions: 9.1.3
         Environment: Ubuntu linux 6+ x64
            Reporter: Don Krapohl
            Assignee: Steven Hawkins
            Priority: Minor


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;




--
This message was sent by Atlassian JIRA
(v7.2.3#72005)