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

IndexOutOfBoundsException when querying JSON files

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • Future
    • Server, Storage - JSON
    • None

    Description

      *Running the following SQL on these three JSON files fail: *
      001.json 100.json 111.json

      select t.id
      from dfs.`/tmp/???.json` t
      where t.assetData.debt.couponPaymentFeature.interestBasis = '5'

      Error:
      org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index: 1024, length: 1 (expected: range(0, 1024)) Fragment 0:0 [Error Id: xxxx.xxxx...

      However running the same SQL on two out of three files works:

      select t.id
      from dfs.`/tmp/1??.json` t
      where t.assetData.debt.couponPaymentFeature.interestBasis = '5'

      select t.id
      from dfs.`/tmp/?1?.json` t
      where t.assetData.debt.couponPaymentFeature.interestBasis = '5'

      select t.id
      from dfs.`/tmp/??1.json` t
      where t.assetData.debt.couponPaymentFeature.interestBasis = '5'

      Changing the selected column from t.id to t. also works: *

      select *
      from dfs.`/tmp/???.json` t
      where t.assetData.debt.couponPaymentFeature.interestBasis = '5'

      Attachments

        1. 111.json
          3.51 MB
          David Lee
        2. 001.json
          3.98 MB
          David Lee
        3. 100.json
          1.65 MB
          David Lee

        Activity

          People

            jni Jinfeng Ni
            davlee1972@yahoo.com David Lee
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: