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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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;



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