drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5035) Selecting timestamp value from Hive table causes IndexOutOfBoundsException
Date Thu, 10 Nov 2016 23:04:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15655471#comment-15655471
] 

Rahul Challapalli commented on DRILL-5035:
------------------------------------------

Are you sure that the data is generated using itself? You can have a hive table sitting on
top of data generated by drill.

> 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
>            Assignee: Vitalii Diravka
>
> 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)

Mime
View raw message