[jira] [Assigned] (KYLIN-2815) No results with prepareStatement but OK with KylinStatement

["Billy Liu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-2815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Billy Liu reassigned KYLIN-2815:
--------------------------------

    Assignee: hongbin ma

> No results with prepareStatement but OK with KylinStatement
> -----------------------------------------------------------
>
>                 Key: KYLIN-2815
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2815
>             Project: Kylin
>          Issue Type: Bug
>          Components: Driver - JDBC
>    Affects Versions: v2.1.0
>            Reporter: youcheng.zhang
>            Assignee: hongbin ma
>
> Actually, my prepareStatement queries works well with kylin version v2.0.
> After I upgrade kylin to version v2.1, all queries have no results return,
> Then I write test：
> {code:java}
> Driver driver = (Driver) Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
> Properties info = new Properties();
> info.put("user", "ADMIN");
> info.put("password", "KYLIN");
> Connection conn = driver.connect("jdbc:kylin://IP:7070/project_name", info);
> PreparedStatement pst = conn.prepareStatement("select XX where XX = ? ")
> pst.setInt(1, 1);
> ResultSet resultSet = pst.executeQuery();
> {code}
> Return no results, and after that I change the query to statement
> {code:java}
> Statement state = conn.createStatement();
> ResultSet resultSet = state.executeQuery("select XX where XX = 1")
> {code}
> Finally, I got return values.
> I have no idea whether it is a bug or I have done something wrong with upgrade?
> As I have removed HBase tables “kylin_metadata_user” and “kylin_metadata_acl", I think 
> I can't come back to version v2.0 any more:(
> I also try changed dependency kylin-jdbc to version 2.1.0 but help nothing.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)