JDBC query result Date column get wrong value

[Yiming Liu]

Hi Kylin devs,

Running against the sample learn_kylin project on the latest master
branch: select part_dt, sum(price) as total_selled, count(distinct
seller_id) as sellers from kylin_sales where part_dt = DATE'2012-01-01'
group by part_dt order by part_dt;

I got the result from Web GUI:
2012-01-01
466.9037
12



But if I run the same query through JDBC Driver,

try {
    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://192.168.1.108:7070/learn_kylin", info);
    final String sql = "select part_dt, sum(price) as total_selled,
count(distinct seller_id) as sellers from kylin_sales where part_dt =
DATE'2012-01-01' group by part_dt order by part_dt";

    PreparedStatement stmt = conn.prepareStatement(sql);
    try {
        try (ResultSet rs = stmt.executeQuery()) {
            while (rs.next()) {

System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
            }
        }
    } finally {
        stmt.close();
    }

I got the result:
2011-12-31 466.9037 12

It seems something wrong when JDBC parse the result.

-- 
With Warm regards

Yiming Liu (刘一鸣)