[ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15655397#comment-15655397 ]
Robert Hou edited comment on DRILL-5035 at 11/10/16 10:36 PM: -------------------------------------------------------------- The partition only has null values for timestamp_id. was (Author: rhou): The partition only has null values. > 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)