Puneet Gupta created LENS-850:
---------------------------------

             Summary: 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.3, 2.1, 2.0
            Reporter: Puneet Gupta


"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)

Reply via email to