consider this thread first: http://apache-kylin.74782.x6.nabble.com/JDBC-query-result-Date-column-get-wrong-value-td5370.html
2017-04-05 22:24 GMT+08:00 zhongyuhai <[email protected]>: > 你好： > > 代码如下 > > 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. >
