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)

Reply via email to