kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: No result from JDBC with Date filter in prepareStatement
Date Mon, 21 Aug 2017 05:14:22 GMT
THank you for reporting. Could you check the kylin.log first?

2017-08-21 11:15 GMT+08:00 程 万胜 <chivise.cn@hotmail.com>:

>
> 大家好:
>
> 用kylin的JDBC查询,查询条件是date类型的,如果通过prepareStatement、setDate是查询不出数据
> 的,然而直接用SQL可以查出数据
>
> 我用的是kylin版本:apache-kylin-1.6.0-cdh5.7-bin,jdbc版本:kylin-jdbc-1.6.0.jar
> ,java版本:java version "1.8.0_92"
>
>
> 代码1
>
>         Driver driver = (Driver) Class.forName("org.apache.
> kylin.jdbc.Driver").newInstance();
>
>         Properties info = new Properties();
>         info.put("user", "xxx");
>         info.put("password", "xxx");
>         Connection conn = driver.connect("jdbc:kylin://xxx/learn_kylin",
> info);
>         PreparedStatement state = conn.prepareStatement(
>                 "select " + "part_dt, sum(price) as total_selled,
> count(distinct seller_id) as sellers "
>                         + "from kylin_sales where part_dt <= '2013-01-01'
> " + "group by part_dt " + "order by part_dt limit 100");
>
>         ResultSet resultSet = state.executeQuery();
>         System.out.print("结果:");
>         while (resultSet.next()) {
>             System.out.print(resultSet.getString(1) + "\n");
>         }
>
> 运行结果
>
> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
> SLF4J: Defaulting to no-operation (NOP) logger implementation
> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
> details.
> 结果:2011-12-31
> 2012-01-01
> 2012-01-02
> 2012-01-03
> 2012-01-04
> 2012-01-05
> 2012-01-06
> 2012-01-07
> 2012-01-08
> 2012-01-09
>
> 代码2
>
>         Driver driver = (Driver) Class.forName("org.apache.
> kylin.jdbc.Driver").newInstance();
>
>         Properties info = new Properties();
>         info.put("user", "xxx");
>         info.put("password", "xxx");
>         Connection conn = driver.connect("jdbc:kylin://xxx/learn_kylin",
> info);
>         PreparedStatement state = conn.prepareStatement(
>                 "select " + "part_dt, sum(price) as total_selled,
> count(distinct seller_id) as sellers "
>                         + "from kylin_sales where part_dt <= ? " + "group
> by part_dt " + "order by part_dt limit 100");
>         SimpleDateFormat simpleTime = new SimpleDateFormat("yyyy-MM-dd");
>         java.util.Date passUtilDate = simpleTime.parse("2013-01-01");
>         java.sql.Date passSqlDate = new java.sql.Date(passUtilDate.
> getTime());
>         System.out.print("条件是:" + passSqlDate + "\n");
>         state.setDate(1, passSqlDate);
>
>         ResultSet resultSet = state.executeQuery();
>         System.out.print("结果:");
>         while (resultSet.next()) {
>             System.out.print(resultSet.getString(1) + "\n");
>         }
>
> 运行结果
>
> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
> SLF4J: Defaulting to no-operation (NOP) logger implementation
> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
> details.
> 条件是:2013-01-01
> 结果:
>
>
>
>
>

Mime
View raw message