May be you can try In Drill 1.4 the same Query SELECT * FROM ` D:\DataFiles\2015\12\16\*.gz` ORDER BY ID LIMIT 10
it's working for me. Thanks, Nirav On Fri, Dec 18, 2015 at 12:46 AM, Holy Alexander < [email protected]> wrote: > I keep my JSON Files in local File system, such as > > D:\DataFiles\2015\12\16\2015-12-16T0000.json.gz > D:\DataFiles\2015\12\16\2015-12-16T0100.json.gz > D:\DataFiles\2015\12\16\2015-12-16T0200.json.gz > (etc.) > > Up to Drill 1.3 > SELECT * FROM ` D:\DataFiles\2015\12\16` ORDER BY ID LIMIT 10 > would produce the desired result, querying all the files in the directory. > > > In Drill 1.4 the same Query > SELECT * FROM ` D:\DataFiles\2015\12\16` ORDER BY ID LIMIT 10 > > always results in this error: > org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: > Unexpected internal error near index 1 \ ^ [Error Id: > 467e9ccd-3730-4add-aa63-a205a1e16107 on ... ] > > However, > SELECT * FROM ` D:\DataFiles\2015\12\16\2015-12-16T0000.json.gz ` ORDER BY > ID LIMIT 10 > Still successfully queries a single file in Drill 1.4 > > I was searching the doc for changes in Drill 1.4 but could not find a hint > what goes wrong? > > Any clues? > > Thanks, > Alexander > >
