Robert Hou created DRILL-5035:
---------------------------------
Summary: 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)
