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

IndexOutOfBoundsException when querying JSON files

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.10.0
    • Fix Version/s: Future
    • Component/s: Server, Storage - JSON
    • Labels:
      None
    • Environment:

      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. 001.json
          3.98 MB
          David Lee
        2. 100.json
          1.65 MB
          David Lee
        3. 111.json
          3.51 MB
          David Lee

          Activity

            People

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

              Dates

              • Created:
                Updated: