[
https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15655306#comment-15655306
]
Robert Hou commented on DRILL-5035:
-----------------------------------
I am using RC1.
0: jdbc:drill:zk=10.10.100.186:5181> select * from sys.version;
+----------+-------------------------------------------+-----------------------------------------------------+----------------------------+----------------+----------------------------+
| version | commit_id |
commit_message | commit_time | build_email
| build_time |
+----------+-------------------------------------------+-----------------------------------------------------+----------------------------+----------------+----------------------------+
| 1.9.0 | 5cea9afa6278e21574c6a982ae5c3d82085ef904 | [maven-release-plugin]
prepare release drill-1.9.0 | 09.11.2016 @ 10:28:44 PST | r...@mapr.com |
10.11.2016 @ 12:56:24 PST |
+----------+-------------------------------------------+-----------------------------------------------------+----------------------------+----------------+----------------------------+
> Selecting timestamp value from Hive table causes IndexOutOfBoundsException
> --------------------------------------------------------------------------
>
> Key: DRILL-5035
> URL: https://issues.apache.org/jira/browse/DRILL-5035
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 1.9.0
> Reporter: Robert Hou
>
> I used the new option to read Hive timestamps.
> alter session set `store.parquet.reader.int96_as_timestamp` = true;
> This query fails:
> select timestamp_id from orders_parts_hive where timestamp_id = '2016-10-03
> 06:11:52.429';
> Error: SYSTEM ERROR: IndexOutOfBoundsException: readerIndex: 0, writerIndex:
> 36288 (expected: 0 <= readerIndex <= writerIndex <= capacity(32768))
> Fragment 0:0
> [Error Id: 50537b32-cdc9-4898-9581-531066288fbd on qa-node211:31010]
> (state=,code=0)
> Selecting all the columns succeed.
> 0: jdbc:drill:zk=10.10.100.186:5181> select * from orders_parts_hive where
> timestamp_id = '2016-10-03 06:11:52.429';
> +-------------+------------+----------------+---------------+--------------+----------+-----------------+--------------------------------------------------------------------+---------+------------+-----------+------------+-------------+-------------+--------------------------+-------------------------+
> | o_orderkey | o_custkey | o_orderstatus | o_totalprice | o_orderdate |
> o_clerk | o_shippriority | o_comment
> | int_id | bigint_id | float_id | double_id |
> varchar_id | date_id | timestamp_id | dir0
> |
> +-------------+------------+----------------+---------------+--------------+----------+-----------------+--------------------------------------------------------------------+---------+------------+-----------+------------+-------------+-------------+--------------------------+-------------------------+
> | 11335 | 871 | F | 133549.0 | 1994-10-22 |
> null | 0 | ealms. theodolites maintain. regular, even
> instructions against t | -4 | -4 | -4.0 | -4.0 | -4
> | 2016-09-29 | 2016-10-03 06:11:52.429 | o_orderpriority=2-HIGH |
> +-------------+------------+----------------+---------------+--------------+----------+-----------------+--------------------------------------------------------------------+---------+------------+-----------+------------+-------------+-------------+--------------------------+-------------------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
