flashput created KYLIN-3448:
-------------------------------

             Summary: Syntax error when pushing down query with 
PreparedStatement 
                 Key: KYLIN-3448
                 URL: https://issues.apache.org/jira/browse/KYLIN-3448
             Project: Kylin
          Issue Type: Bug
    Affects Versions: v2.4.0
         Environment: server : apache-kylin-2.4.0-bin-cdh57
client: kylin-jdbc 2.3.2
            Reporter: flashput
         Attachments: image-2018-07-13-13-00-57-925.png, 
image-2018-07-13-13-01-15-453.png, image-2018-07-13-13-02-44-384.png, 
image-2018-07-13-13-04-06-413.png

h3. Query with PreparedStatement other that concat all parameters to sql

 

Client Test Code: 

set query parameters through PreparedStatement.setInt()

!image-2018-07-13-13-01-15-453.png!

Query failed to utilize pre-calculation, routing to other engines

!image-2018-07-13-13-00-57-925.png!

 

!image-2018-07-13-13-01-47-899.png!

Query pushdown to underlying data source then Exception occured

org.apache.hive.service.cli.HiveSQLException: AnalysisException: Syntax error

!image-2018-07-13-13-02-44-384.png!

!image-2018-07-13-13-04-06-413.png!

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to