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)
