Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
None
Description
git.commit.id.abbrev=190d5d4
Wrong Result 1 :
select l_shipdate, `month`(l_shipdate) from cp.`tpch/lineitem.parquet` where l_shipdate = date '1994-02-01' limit 2;
+-------------+---------+
| l_shipdate | EXPR$1 |
+-------------+---------+
| 1994-02-01 | 1 |
| 1994-02-01 | 1 |
+-------------+---------+
Wrong Result 2 :
select l_shipdate, `day`(l_shipdate) from cp.`tpch/lineitem.parquet` where l_shipdate = date '1998-06-02' limit 2;
+-------------+---------+
| l_shipdate | EXPR$1 |
+-------------+---------+
| 1998-06-02 | 1 |
| 1998-06-02 | 1 |
+-------------+---------+
Correct Result :
select l_shipdate, `month`(l_shipdate) from cp.`tpch/lineitem.parquet` where l_shipdate = date '1998-06-02' limit 2;
+-------------+---------+
| l_shipdate | EXPR$1 |
+-------------+---------+
| 1998-06-02 | 6 |
| 1998-06-02 | 6 |
+-------------+---------+
It looks like we are getting wrong results when the 'day' is '01'. I only tried month and day hive functions....but wouldn't be surprised if they have similar issues too.
Attachments
Attachments
Issue Links
- Blocked
-
DRILL-5250 Date is stored wrongly in HIVE generated JSON
- Open
- is related to
-
DRILL-5332 DateVector support uses questionable conversions to a time
- Open
-
DRILL-4116 Inconsistent results with datetime functions on different machines
- Closed
- links to