[
https://issues.apache.org/jira/browse/LENS-126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14247821#comment-14247821
]
Sushil Mohanty commented on LENS-126:
-------------------------------------
{CODE}
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Lens Checkstyle Rules ............................. SUCCESS [10.824s]
[INFO] Lens .............................................. SUCCESS [31.838s]
[INFO] Lens API .......................................... SUCCESS [35.641s]
[INFO] Lens API for server and extensions ................ SUCCESS [32.562s]
[INFO] Lens Cube ......................................... SUCCESS [46.595s]
[INFO] Lens DB storage ................................... SUCCESS [13.170s]
[INFO] Lens Query Library ................................ SUCCESS [12.709s]
[INFO] Lens Hive Driver .................................. SUCCESS [20.515s]
[INFO] Lens Driver for Cloudera Impala ................... SUCCESS [6.646s]
[INFO] Lens Driver for JDBC .............................. SUCCESS [16.543s]
[INFO] Lens Server ....................................... SUCCESS [2:05.237s]
[INFO] Lens client ....................................... SUCCESS [13.653s]
[INFO] Lens CLI .......................................... SUCCESS [30.433s]
[INFO] Lens Examples ..................................... SUCCESS [6.379s]
[INFO] Lens Distribution ................................. SUCCESS [35.124s]
[INFO] Lens Client Distribution .......................... SUCCESS [1:03.126s]
[INFO] Lens ML Lib ....................................... SUCCESS [48.235s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
{CODE}
> jdbc rewrite error while using alias name in order by
> -----------------------------------------------------
>
> Key: LENS-126
> URL: https://issues.apache.org/jira/browse/LENS-126
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Raghavendra Singh
> Assignee: Sushil Mohanty
> Fix For: 2.0
>
> Attachments: LENS-126.patch
>
>
> for a query having:
> select col1 as alias1 . . . order by alias1 desc limit 10
> the rewritten query misses the alias name and is rewritten as:-
> order by desc limit 10
> error message:-
> {CODE}
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'desc limit 10'
> at line 1
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
> at com.mysql.jdbc.Statement.execute(Statement.java:727)
> at
> com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
> at
> org.apache.lens.driver.jdbc.JDBCDriver$QueryCallable.call(JDBCDriver.java:299)
> at
> org.apache.lens.driver.jdbc.JDBCDriver.executeInternal(JDBCDriver.java:694)
> at org.apache.lens.driver.jdbc.JDBCDriver.explain(JDBCDriver.java:573)
> ... 5 more
> {CODE}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
