[ https://issues.apache.org/jira/browse/KYLIN-2815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16142520#comment-16142520 ]
Billy Liu commented on KYLIN-2815: ---------------------------------- Thanks for reporting. It's an issue, introduced by Prepare logic refactor in the backend. > 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)