[ https://issues.apache.org/jira/browse/DRILL-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristine Hahn resolved DRILL-3284. ---------------------------------- Resolution: Fixed The [TO_DATE|http://drill.apache.org/docs/data-type-conversion/#to_date] doc states that any UNIX epoch timestamp conversion results in milliseconds. The [UNIX_TIMESTAMP|http://drill.apache.org/docs/date-time-functions-and-arithmetic/#unix_timestamp] function states that conversion results in seconds. > 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 > Fix For: 1.2.0 > > > 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)