[
https://issues.apache.org/jira/browse/LENS-850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Archana H closed LENS-850.
--------------------------
verified
> Queries with column name alias like "year" fails on some DBs
> ------------------------------------------------------------
>
> Key: LENS-850
> URL: https://issues.apache.org/jira/browse/LENS-850
> Project: Apache Lens
> Issue Type: Improvement
> Components: cube
> Affects Versions: 2.0, 2.1, 2.3
> Reporter: Puneet Gupta
> Assignee: Puneet Gupta
> Fix For: 2.5
>
> Attachments: lens-850.patch
>
>
> "Select column_year year from Test_Table"
> fails on some DBs.
> Reason:
> This is because "year" is a keyword in some DBs and the query needs to be
> rewritten with alias name quoted before it is executed.
> "Select coulm_year as `year` from Test_Table"
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
