drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4141) Hive Plugin : Timestamp value in an RCfile (Snappy compression) is wrongly interpreted
Date Sat, 28 Nov 2015 07:14:11 GMT
Rahul Challapalli created DRILL-4141:
----------------------------------------

             Summary: Hive Plugin :  Timestamp  value in an RCfile (Snappy compression) is
wrongly interpreted
                 Key: DRILL-4141
                 URL: https://issues.apache.org/jira/browse/DRILL-4141
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Hive
            Reporter: Rahul Challapalli
            Priority: Critical


git.commit.id.abbrev=f7a0d38

The below should have returned "1996-02-28 17:32:01.0". However it returns an incorrect value
{code}
select timestamp_col from hive.fewtypes_null_compressed_rc_snappy where int_col=20;
+------------------------+
|     timestamp_col      |
+------------------------+
| 1996-02-29 01:32:01.0  |
+------------------------+
1 row selected (0.715 seconds)
{code}

This is not related to the timezone of the sqlline client as the below query from the same
client returns the proper result. However this time the data is  stored in a sequence file
with snappy compression
{code}
select timestamp_col from hive.fewtypes_null_compressed_seq_snappy where int_col=20;
+------------------------+
|     timestamp_col      |
+------------------------+
| 1996-02-28 17:32:01.0  |
+------------------------+
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message