[
https://issues.apache.org/jira/browse/LENS-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14976527#comment-14976527
]
Hadoop QA commented on LENS-850:
--------------------------------
Applied patch:
[lens-850.patch|https://issues.apache.org/jira/secure/attachment/12768988/lens-850.patch]
and ran command: mvn clean install. Result: Success. Build Job:
https://builds.apache.org/job/PreCommit-Lens-Build/155/
> 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
> 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)
