[DRILL-4116] Inconsistent results with datetime functions on different machines

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.3.0
• Component/s: Functions - Drill
• Assignee: Vitalii Diravka
• Reporter: Rahul Kumar Challapalli
• Reviewer: Chun Chang
• Created: 20/Nov/15 18:34
• Updated: 31/Aug/17 21:53
• Resolved: 27/Jun/17 10:13

Description

git.commit.id.abbrev=a6a0fc3

The below query yields different results on different machines
System 1 :

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)

System 2 :

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)

Issue Links

• relates to: DRILL-5002 Using hive's date functions on top of date column gives wrong results for local time-zone