You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2016/11/04 08:36:58 UTC
[jira] [Created] (DRILL-5002) Using hive's date functions on top of
date column in parquet gives wrong results
Rahul Challapalli created DRILL-5002:
----------------------------------------
Summary: Using hive's date functions on top of date column in parquet gives wrong results
Key: DRILL-5002
URL: https://issues.apache.org/jira/browse/DRILL-5002
Project: Apache Drill
Issue Type: Bug
Components: Functions - Hive, Storage - Parquet
Reporter: Rahul Challapalli
Priority: Critical
git.commit.id.abbrev=190d5d4
Wrong Result 1 :
{code}
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 |
+-------------+---------+
{code}
Wrong Result 2 :
{code}
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 |
+-------------+---------+
{code}
Correct Result :
{code}
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 |
+-------------+---------+
{code}
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)