[
https://issues.apache.org/jira/browse/LENS-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14976617#comment-14976617
]
Hudson commented on LENS-850:
-----------------------------
SUCCESS: Integrated in Lens-Commit #1118 (See
[https://builds.apache.org/job/Lens-Commit/1118/])
LENS-850: Queries with column name alias like "year" fails on some DBs
(rajatgupta59: rev 6c4dba51bfebba2bd019508d2e44850ef964d150)
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestJoinResolver.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestBaseCubeQueries.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestCubeRewriter.java
* lens-driver-jdbc/src/test/java/org/apache/lens/driver/jdbc/TestJDBCFinal.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestExpressionResolver.java
*
lens-driver-jdbc/src/test/java/org/apache/lens/driver/jdbc/TestColumnarSQLRewriter.java
* lens-cube/src/main/java/org/apache/lens/cube/parse/HQLParser.java
* lens-cube/src/test/java/org/apache/lens/cube/parse/TestHQLParser.java
> 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)
