[ 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)