Rahul Challapalli created DRILL-4116: ----------------------------------------
Summary: Inconsistent results with datetime functions on different machines Key: DRILL-4116 URL: https://issues.apache.org/jira/browse/DRILL-4116 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.3.0 Reporter: Rahul Challapalli Priority: Critical git.commit.id.abbrev=a6a0fc3 The below query yields different results on different machines System 1 : {code} 0: jdbc:drill:zk=10.10.100.190:5181> select datediff(date '1996-03-01', timestamp '1997-02-10 17:32:00.0') from cp.`tpch/lineitem.parquet` limit 1; +---------+ | EXPR$0 | +---------+ | -346 | +---------+ 1 row selected (1.57 seconds) {code} System 2 : {code} 0: jdbc:drill:drillbit=10.10.88.193> select datediff(date '1996-03-01', timestamp '1997-02-10 17:32:00.0') from cp.`tpch/lineitem.parquet` limit 1; +---------+ | EXPR$0 | +---------+ | -347 | +---------+ 1 row selected (1.239 seconds) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)