[
https://issues.apache.org/jira/browse/KYLIN-3448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16556946#comment-16556946
]
Shaofeng SHI commented on KYLIN-3448:
-------------------------------------
I think prepared statement hasn't been supported. There is a PR about this, but
not merged yet: https://github.com/apache/kylin/pull/160
> 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
> Priority: Major
> 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)
