Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5035

Selecting timestamp value from Hive table causes IndexOutOfBoundsException

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.9.0
    • None
    • Execution - Data Types
    • None

    Description

      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

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            rhou Robert Hou
            Robert Hou Robert Hou

            Dates

              Created:
              Updated:

              Slack

                Issue deployment