Could you please turn on verbose error mode by running the following [1] then re-run the query and post the error message, or copy & post the drillbit log when the query was executed?
ALTER SESSION SET `exec.errors.verbose` = true; That will give us more information about the error you saw. From the error message you posted, it's not clear whether the JSON data itself is not well formated, or Drill hit an execution bug. Thanks, [1] https://drill.apache.org/docs/troubleshooting/#enable-verbose-errors On Tue, Feb 16, 2016 at 2:45 AM, Paolino <paolosp...@gmail.com> wrote: > Dear all, > Someone could support me with this drill? > > Best regards, > Paolo > > ----- Messaggio originale ----- > Da: "Paolo Spanevello" <paolosp...@gmail.com> > Inviato: 12/02/2016 21:15 > A: "user" <user@drill.apache.org> > Oggetto: Re: One single query for more files JSON > > yes with windows > > > 2016-02-12 17:11 GMT+01:00 Zelaine Fong <zf...@maprtech.com>: > > Are you running on Windows? If so, perhaps this is DRILL-4305? > > -- Zelaine > > On Fri, Feb 12, 2016 at 8:00 AM, Paolo Spanevello <paolosp...@gmail.com> > > wrote: > >> The schema and the files are the same. This is the error: >> >> ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: >> SELECT * FROM `Performance_Ride_Analytics`.`GC`.`./*/cache/rideDB.json` >> [30027]Query execution error. Details:[ >> VALIDATION ERROR: Unexpected internal error near index 1 >> \ >> ^ >> >> >> 2016-02-12 16:43 GMT+01:00 Abdel Hakim Deneche <adene...@maprtech.com>: >> >> > Of course, if the schema changes between files, this will most likely >> cause >> > the query to fail >> > >> > On Fri, Feb 12, 2016 at 7:42 AM, Abdel Hakim Deneche < >> > adene...@maprtech.com> >> > wrote: >> > >> > > Yes, it should work. >> > > >> > > On Fri, Feb 12, 2016 at 7:31 AM, Paolo Spanevello < >> paolosp...@gmail.com> >> > > wrote: >> > > >> > >> Dear All, >> > >> >> > >> Could i've a single query for more json files ? >> > >> >> > >> Example: >> > >> >> > >> - /user/folder1/file1.json >> > >> - /user/folder2/file2.json >> > >> - /user/folder3/file3.json >> > >> >> > >> Query: >> > >> SELECT * FROM /user/*/file*.json >> > >> >> > >> Thanks a lot for your support. >> > >> >> > >> Best, >> > >> Paolo >> > >> >> > > >> > > >> > > >> > > -- >> > > >> > > Abdelhakim Deneche >> > > >> > > Software Engineer >> > > >> > > <http://www.mapr.com/> >> > > >> > > >> > > Now Available - Free Hadoop On-Demand Training >> > > < >> > >> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available >> > > >> > > >> > >> > >> > >> > -- >> > >> > Abdelhakim Deneche >> > >> > Software Engineer >> > >> > <http://www.mapr.com/> >> > >> > >> > Now Available - Free Hadoop On-Demand Training >> > < >> > >> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available >> > > >> > >>
