[KYLIN-2815] Empty results with prepareStatement but OK with KylinStatement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: v2.1.0
• Fix Version/s: v2.2.0
• Component/s: Driver - JDBC
• Labels: scope
• Assignee: Wang Cheng
• Reporter: youcheng.zhang
• Created: 25/Aug/17 13:23
• Updated: 03/Nov/17 16:48
• Resolved: 12/Oct/17 14:10

Description

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：

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();

Return no results, and after that I change the query to statement

Statement state = conn.createStatement();
ResultSet resultSet = state.executeQuery("select XX where XX = 1")

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.

Issue Links

• is duplicated by: KYLIN-2806 Empty results from JDBC with Date filter in prepareStatement
• is duplicated by: KYLIN-2842 在升级到KYLIN 2.1之后，我使用JDBC，preparedstatement, 无法查询出任何数据。