You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2018/05/26 02:16:00 UTC
[jira] [Comment Edited] (HIVE-19675) Cast to timestamps on Druid
time column leads to an exception
[ https://issues.apache.org/jira/browse/HIVE-19675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491463#comment-16491463 ]
slim bouguerra edited comment on HIVE-19675 at 5/26/18 2:15 AM:
----------------------------------------------------------------
In Case a cast to timestamp is pushed to Druid {code}CAST(`ssb_druid_100`.`__time` AS TIMESTAMP){code}, the results is formatted as a Timestamp {code}yyyy-MM-dd HH:mm:ss{code}.
This is probably not the best way to fix this, but i want us to at least fix this very nasty bug and i will refactor this as soon as possible, especially after all the changes coming from [~jcamachorodriguez] around that part of the code.
was (Author: bslim):
In Case a cast to timestamp is pushed to Druid, the upcoming results is formatted as a Timestamp {code}yyyy-MM-dd HH:mm:ss{code}.
This is probably not the best way to fix this, but i want us to at least fix this very nasty bug and i will refactor this as soon as possible, especially after all the changes coming from [~jcamachorodriguez] around that part of the code.
> Cast to timestamps on Druid time column leads to an exception
> -------------------------------------------------------------
>
> Key: HIVE-19675
> URL: https://issues.apache.org/jira/browse/HIVE-19675
> Project: Hive
> Issue Type: Bug
> Components: Druid integration
> Affects Versions: 3.0.0
> Reporter: slim bouguerra
> Assignee: slim bouguerra
> Priority: Major
> Attachments: HIVE-19675.2.patch, HIVE-19675.patch
>
>
> The following query fail due to a formatting issue.
> {code}
> SELECT CAST(`ssb_druid_100`.`__time` AS TIMESTAMP) AS `x_time`,
> . . . . . . . . . . . . . . . .> SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok`
> . . . . . . . . . . . . . . . .> FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100`
> . . . . . . . . . . . . . . . .> GROUP BY CAST(`ssb_druid_100`.`__time` AS TIMESTAMP);
> {code}
> Exception
> {code}
> Error: java.io.IOException: java.lang.NumberFormatException: For input string: "1991-12-31 19:00:00" (state=,code=0)
> {code}
> [~jcamachorodriguez] maybe this is fixed by your upcoming patches.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)