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

IndexOutOfBoundsException when querying JSON files

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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. 001.json
          3.98 MB
          David Lee
        2. 100.json
          1.65 MB
          David Lee
        3. 111.json
          3.51 MB
          David Lee

        Activity

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

          People

            jni Jinfeng Ni
            davlee1972@yahoo.com David Lee

            Dates

              Created:
              Updated:

              Slack

                Issue deployment