Hi, Both statements select everything but the CTAS statement included a date filter + date order.
The date field is always the same (extended json format date ISO) and is always present so I can say, with 100% certainty, that there is no schema change involved. The select statement fails as well when I add the condition + ordering. Regards, -Stefan On Fri, Sep 18, 2015 at 3:37 PM, Abdel Hakim Deneche <adene...@maprtech.com> wrote: > This kind of errors usually happens when there is an unsupported schema > change in the json files, but you should be able to reproduce the error > with just a select statement. Can you share both queries you tried (the > failing CTAS and the successful SELECT *) ? > > Thanks > > On Fri, Sep 18, 2015 at 5:38 AM, Stefán Baxter <ste...@activitystream.com> > wrote: > > > Hi, > > > > I have some json files that I want to transform to parquet. > > > > We have been doing this without any issues but this time around I get > this > > exception: > > > > Error: SYSTEM ERROR: IllegalStateException: Failure while reading vector. > > Expected vector class of > org.apache.drill.exec.vector.NullableVarCharVector > > but was holding vector class > > org.apache.drill.exec.vector.complex.MapVector. > > > > Fragment 2:0 > > > > [Error Id: 86501e92-5319-4540-9cf3-9a1aede4554b on localhost:31010] > > (state=,code=0) > > > > Adding verbosity adds no additional information regarding the > > source/row/column that triggers this reaction. > > > > I have successfully executed "select * from <same-directory>" and that > has > > run perfectly. For me this means that the issue is CTAS related. > > > > I'm running a fresh build from master to execute this. > > > > Any ideas/pointers? > > > > Regards, > > -Stefán > > > > > > -- > > 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 > > >