You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kudu.apache.org by "chengyanan@idengyun.com" <ch...@idengyun.com> on 2019/12/03 11:53:36 UTC
请教Java Api写入Kudu中关于Timestamp类型数据的问题
请教，我有一张kudu表，表字段为uuid:String类型，date:String类型和time:TimeStamp类型
数据写入代码如下：
KuduUtils kuduUtils = new KuduUtils();
KuduTable aa = kuduUtils.kuduClient.openTable("impala::analysis.events_kudu_aa");
KuduSession session = kuduUtils.kuduClient.newSession();
Insert insert = aa.newInsert();
PartialRow row = insert.getRow();
row.addString("uuid", UUID.randomUUID().toString());
row.addString("date", LocalDate.now().toString());
Timestamp timestamp = TimestampUtil.microsToTimestamp(System.currentTimeMillis() * 1000);
row.addTimestamp("time",timestamp);
session.apply(insert);
for (ColumnSchema column : aa.getSchema().getColumns()) {
System.out.println(column.getType());
}
现在遇到了一个问题，写入的TimeStamp类型用Impala查出来比实际少了8个小时，
如上,最右一列时间应该为 18:48:07 18:56:47 18:54:00
我已经在Impala参数上加上了 -use_local_tz_for_unix_timestamp_conversions=true 配置，但是还是没有用
请问java api写入Kudu表中TimeStamp类型应该怎样设置才能按照中国时区显示
谢谢！！！
回复: 回复: 请教Java Api写入Kudu中关于Timestamp类型数据的问题
Posted by "chengyanan@idengyun.com" <ch...@idengyun.com>.
Thanks for your answer, I will try it later!
发件人： hzhelifu@corp.netease.com
发送时间： 2019-12-03 20:40
收件人： user@kudu.apache.org
主题： 回复: 请教Java Api写入Kudu中关于Timestamp类型数据的问题
Hi Yanan,
I think that’s impala’s problem. You can refer to this issue: https://issues.apache.org/jira/browse/IMPALA-5539, and it was fixed in impala-2.10.0.
发件人: user-return-1750-hzhelifu=corp.netease.com@kudu.apache.org <us...@kudu.apache.org> 代表 chengyanan@idengyun.com
发送时间: 2019年12月3日 19:54
收件人: user <us...@kudu.apache.org>
抄送: 程亚楠 <ch...@idengyun.com>
主题: 请教Java Api写入Kudu中关于Timestamp类型数据的问题
请教，我有一张kudu表，表字段为uuid:String类型，date:String类型和time:TimeStamp类型
数据写入代码如下：
KuduUtils kuduUtils = new KuduUtils();
KuduTable aa = kuduUtils.kuduClient.openTable("impala::analysis.events_kudu_aa");
KuduSession session = kuduUtils.kuduClient.newSession();
Insert insert = aa.newInsert();
PartialRow row = insert.getRow();
row.addString("uuid", UUID.randomUUID().toString());
row.addString("date", LocalDate.now().toString());
Timestamp timestamp = TimestampUtil.microsToTimestamp(System.currentTimeMillis() * 1000);
row.addTimestamp("time",timestamp);
session.apply(insert);
for (ColumnSchema column : aa.getSchema().getColumns()) {
System.out.println(column.getType());
}
现在遇到了一个问题，写入的TimeStamp类型用Impala查出来比实际少了8个小时，
如上,最右一列时间应该为 18:48:07 18:56:47 18:54:00
我已经在Impala参数上加上了 -use_local_tz_for_unix_timestamp_conversions=true 配置，但是还是没有用
请问java api写入Kudu表中TimeStamp类型应该怎样设置才能按照中国时区显示
谢谢！！！
回复: 请教Java Api写入Kudu中关于Timestamp类型数据的问题
Posted by hz...@corp.netease.com.
Hi Yanan,
I think that’s impala’s problem. You can refer to this issue:
https://issues.apache.org/jira/browse/IMPALA-5539, and it was fixed in
impala-2.10.0.
发件人: user-return-1750-hzhelifu=corp.netease.com@kudu.apache.org
<us...@kudu.apache.org> 代表
chengyanan@idengyun.com
发送时间: 2019年12月3日 19:54
收件人: user <us...@kudu.apache.org>
抄送: 程亚楠 <ch...@idengyun.com>
主题: 请教Java Api写入Kudu中关于Timestamp类型数据的问题
请教，我有一张kudu表，表字段为uuid:String类型，date:String类型和
time:TimeStamp类型
数据写入代码如下：
KuduUtils kuduUtils = new KuduUtils();
KuduTable aa =
kuduUtils.kuduClient.openTable("impala::analysis.events_kudu_aa");
KuduSession session = kuduUtils.kuduClient.newSession();
Insert insert = aa.newInsert();
PartialRow row = insert.getRow();
row.addString("uuid", UUID.randomUUID().toString());
row.addString("date", LocalDate.now().toString());
Timestamp timestamp =
TimestampUtil.microsToTimestamp(System.currentTimeMillis() * 1000);
row.addTimestamp("time",timestamp);
session.apply(insert);
for (ColumnSchema column : aa.getSchema().getColumns()) {
System.out.println(column.getType());
}
现在遇到了一个问题，写入的TimeStamp类型用Impala查出来比实际少了8个小时，
如上,最右一列时间应该为 18:48:07 18:56:47 18:54:00
我已经在Impala参数上加上了 -use_local_tz_for_unix_timestamp_conversions=true
配置，但是还是没有用
请问java api写入Kudu表中TimeStamp类型应该怎样设置才能按照中国时区显示
谢谢！！！