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
