[HIVE-19675] Cast to timestamps on Druid time column leads to an exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0, 4.0.0-alpha-1
• Component/s: Druid integration
• Target Version/s: 3.1.0
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 23/May/18 13:31
• Updated: 27/Feb/24 22:23
• Resolved: 30/May/18 18:41

Description

The following query fail due to a formatting issue.

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

Exception

 
Error: java.io.IOException: java.lang.NumberFormatException: For input string: "1991-12-31 19:00:00" (state=,code=0)

jcamachorodriguez maybe this is fixed by your upcoming patches.

Issue Links

• is related to: HIVE-19721 Druid Storage handler throws exception when query has a Cast to Date
• links to: RB link