你好：
代码如下
Driver driver = (Driver)
Class.forName("org.apache.kylin.jdbc.Driver").newInstance();
Properties p = new Properties();
p.put("user" , "ADMIN");
p.put("password" , "KYLIN");
//控制查询结果的显示。
p.put("timeZone", "UTC");
Connection c = driver.connect(
"jdbc:kylin://spark1:7070/learn_kylin",
p
);
PreparedStatement ps = c.prepareStatement(
"SELECT part_dt , sum(price) FROM KYLIN_SALES where part_dt
= ? group by part_dt"
);
Date d = new Date(112,0,12);
java.sql.Date dd = new java.sql.Date(d.getTime());
ps.setDate(1,dd);
ResultSet rs = ps.executeQuery();
后台LOG如下，没有显示有查询结果
Query Id: 01a75351-73eb-41eb-94c5-9845d5f83a01
SQL: SELECT part_dt , sum(price) FROM KYLIN_SALES where part_dt = ? group by
part_dt
User: ADMIN
Success: true
Duration: 0.125
Project: learn_kylin
Realization Names: [kylin_sales_cube]
Cuboid Ids: [16384]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: null
但通过INSIGHT查询是有相关结果。
<http://apache-kylin.74782.x6.nabble.com/file/n7592/INSIGHT.jpg>
请问该如何解决？
谢谢！
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/KYLIN-JDBC-Date-PreparedStatement-tp7592.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
