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

Simple query hit IndexOutOfBoundException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.5.0
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      The following query failed due to IOB:
      0: jdbc:drill:schema=wf_pigprq100> select * from `store_sales/part-m-00073.parquet`;

      Error: SYSTEM ERROR: IndexOutOfBoundsException: srcIndex: 1048587

      Fragment 0:0

      [Error Id: ad8d2bc0-259f-483c-9024-93865963541e on ucs-node4.perf.lab:31010]

      (org.apache.drill.common.exceptions.DrillRuntimeException) Error in parquet record reader.
      Message:
      Hadoop path: /tpcdsPigParq/SF100/store_sales/part-m-00073.parquet
      Total records read: 135280
      Mock records read: 0
      Records to read: 1424
      Row group index: 0
      Records in row group: 3775712
      Parquet Metadata: ParquetMetaData{FileMetaData{schema: message pig_schema {
      optional int64 ss_sold_date_sk;
      optional int64 ss_sold_time_sk;
      optional int64 ss_item_sk;
      optional int64 ss_customer_sk;
      optional int64 ss_cdemo_sk;
      optional int64 ss_hdemo_sk;
      optional int64 ss_addr_sk;
      optional int64 ss_store_sk;
      optional int64 ss_promo_sk;
      optional int64 ss_ticket_number;
      optional int64 ss_quantity;
      optional double ss_wholesale_cost;
      optional double ss_list_price;
      optional double ss_sales_price;
      optional double ss_ext_discount_amt;
      optional double ss_ext_sales_price;
      optional double ss_ext_wholesale_cost;
      optional double ss_ext_list_price;
      optional double ss_ext_tax;
      optional double ss_coupon_amt;
      optional double ss_net_paid;
      optional double ss_net_paid_inc_tax;
      optional double ss_net_profit;
      }

        Attachments

          Activity

            People

            • Assignee:
              dechanggu Dechang Gu
              Reporter:
              dechanggu Dechang Gu
              Reviewer:
              Dechang Gu
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: