Hi Dan, Turns out that there are several known issues with text files. We’ve been chasing down a bug very similar to yours in DRILL-5487 [1].
Is this a file you can share? If so, this might be a very good opportunity to find and fix this issue. Please contact me directly if you can share the file(s). Thanks, - Paul [1] https://issues.apache.org/jira/browse/DRILL-5487 > On Jul 13, 2017, at 10:12 AM, Dan Holmes <[email protected]> wrote: > > I am getting the following error with this query. > > SELECT COUNT(*) > FROM dfs.`/home/dan/twm/sales` > > version 1.10.0 > > all the files are .txt. Here is the relevant part of the profile for dfs > "txt": { > "type": "text", > "extensions": [ > "txt" > ], > "extractHeader": true, > "delimiter": "|" > > how do i diagnose this? > > thank you > dan > Query Failed: An Error > Occurredorg.apache.drill.common.exceptions.UserRemoteException: > SYSTEM ERROR: IndexOutOfBoundsException: index: 32384, length: 4 (expected: > range(0, 16384)) Fragment 1:0 [Error Id: > 7cacf366-21dc-4528-9f4c-eda3c2e28a8b on ubuntu:31010]
