slim bouguerra created HIVE-19675: ------------------------------------- Summary: 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: Jesus Camacho Rodriguez
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)