-
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
*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'