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 <[email protected]> wrote: > Dear all, > Someone could support me with this drill? > > Best regards, > Paolo > > ----- Messaggio originale ----- > Da: "Paolo Spanevello" <[email protected]> > Inviato: 12/02/2016 21:15 > A: "user" <[email protected]> > Oggetto: Re: One single query for more files JSON > > yes with windows > > > 2016-02-12 17:11 GMT+01:00 Zelaine Fong <[email protected]>: > > Are you running on Windows? If so, perhaps this is DRILL-4305? > > -- Zelaine > > On Fri, Feb 12, 2016 at 8:00 AM, Paolo Spanevello <[email protected]> > > 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 <[email protected]>: >> >> > 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 < >> > [email protected]> >> > wrote: >> > >> > > Yes, it should work. >> > > >> > > On Fri, Feb 12, 2016 at 7:31 AM, Paolo Spanevello < >> [email protected]> >> > > 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 >> > > >> > >>
