You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2018/05/23 13:32:00 UTC
[jira] [Created] (HIVE-19675) Cast to timestamps on Druid time
column leads to an exception
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)