Hi,
when i query data by kylin insight(dimension table join column in hive
is date type,data is 20170731),query result is rigth(have setting
:kylin.web.timezone=GMT+8)
but query by jdbc the result data is 20170330.
After setting in jdbc connect .
Properties info = new Properties();
info.put("timeZone", "GMT +08");
rs.getDate(part_dt) ,result is 20170731
rs.getString(part_dt),result is 20170330.
rs is java resultset
What's the reason?
How can I set the result right(getString(part_dt) is 20170331)?
[email protected]
From: [email protected]
Date: 2017-08-29 15:50
To: dev
Subject: Re: How to set timezone in JDBC parameter?
Hi,
This problem have now been sorted, Thinks
Properties info = new Properties();
info.put("timeZone", "GMT +08");
[email protected]
From: [email protected]
Date: 2017-08-29 11:57
To: dev
Subject: How to set timezone in JDBC parameter?
Hi,
when i query data by kylin insight(dimension table join column in hive
is date type,data is 20170731),query result is rigth(have setting
:kylin.web.timezone=GMT+8)
but query by jdbc the result data is 20170329.
How to set time zone in JDBC parameter?
Thinks.
[email protected]
