You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltan Ivanfi (JIRA)" <ji...@apache.org> on 2018/07/03 12:10:00 UTC
[jira] [Assigned] (IMPALA-1871) Impala is unable to read timestamp
field value in avro written by hive
[ https://issues.apache.org/jira/browse/IMPALA-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltan Ivanfi reassigned IMPALA-1871:
-------------------------------------
Assignee: Csaba Ringhofer (was: Zoltan Ivanfi)
> Impala is unable to read timestamp field value in avro written by hive
> ----------------------------------------------------------------------
>
> Key: IMPALA-1871
> URL: https://issues.apache.org/jira/browse/IMPALA-1871
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.1.1, Impala 2.3.0
> Environment: CDH 5.4
> Reporter: Syed A. Hashmi
> Assignee: Csaba Ringhofer
> Priority: Major
> Attachments: tempfile.txt, tempfile.txt
>
>
> Hive recently added support for writing timestamp values in avro format. Field description looks like this:
> {code}
> { "type": "long", "logicalType": "timestamp-millis" }
> {code}
> I have created an avro table with data using hive. When I am trying to read this field from Impala, it reads as garbage, while from hive I can read it fine. Here is the result from hive:
> {code}
> 0: jdbc:hive2://shashmi-test-1.vpc.cloudera.c> select timestamp_field from hiveclient_hiveclient_uncompressed;
> +-------------------------+--+
> | timestamp_field |
> +-------------------------+--+
> | 2012-02-21 07:08:09.12 |
> | 1998-02-21 07:08:09.12 |
> | 1970-01-01 00:00:01.0 |
> | 2038-01-19 03:14:07.0 |
> | NULL |
> +-------------------------+--+
> {code}
> While the output from Impala is incorrect:
> {code}
> [shashmi-test-2.vpc.cloudera.com:21000] > select timestamp_field from hiveclient_hiveclient_uncompressed;
> Query: select timestamp_field from hiveclient_hiveclient_uncompressed
> +-----------------+
> | timestamp_field |
> +-----------------+
> | 1329836889120 |
> | 888073689120 |
> | 28801000 |
> | 2147512447000 |
> | NULL |
> +-----------------+
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org