You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kristine Hahn (JIRA)" <ji...@apache.org> on 2015/06/15 21:55:01 UTC
[jira] [Assigned] (DRILL-3284) Document incompatibility between
drill's to_date and hive's unix_timestamp
[ https://issues.apache.org/jira/browse/DRILL-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristine Hahn reassigned DRILL-3284:
------------------------------------
Assignee: Kristine Hahn (was: Bridget Bevens)
> Document incompatibility between drill's to_date and hive's unix_timestamp
> --------------------------------------------------------------------------
>
> Key: DRILL-3284
> URL: https://issues.apache.org/jira/browse/DRILL-3284
> Project: Apache Drill
> Issue Type: Bug
> Components: Documentation, Functions - Hive
> Reporter: Rahul Challapalli
> Assignee: Kristine Hahn
>
> The below query from drill produces wrong results because unix_timestamp (function from hive) returns the value in seconds while to_date treats its input in milliseconds.
> {code}
> select to_date(unix_timestamp('1998-05-06', 'yyyy-MM-dd')) from dummy limit 1;
> +-------------+
> | EXPR$0 |
> +-------------+
> | 1970-01-11 |
> +-------------+
> {code}
> In order to make this work we should use the below query
> {code}
> select to_date(unix_timestamp('1998-05-06', 'yyyy-MM-dd')*1000) from dummy limit 1;
> +-------------+
> | EXPR$0 |
> +-------------+
> | 1998-05-06 |
> +-------------+
> {code}
> If this is not a bug on drill's side, we should atleast document this
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)