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 > > > > > > > > > >
