This fails: - select * from dfs.asa.* where occurred_at < '2015-09-18' order by occurred_at;
This, oddly enough, does not fail: - select occurred_at from dfs.* where occurred_at < '2015-09-18' order by occurred_at; -ste On Fri, Sep 18, 2015 at 4:08 PM, Stefán Baxter <[email protected]> wrote: > > The failing select query: > > select * from dfs.* where occurred_at < '2015-09-18' order by occurred_at; > > -ste > > On Fri, Sep 18, 2015 at 4:02 PM, Stefán Baxter <[email protected]> > wrote: > >> 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 < >> [email protected]> 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 < >>> [email protected]> >>> 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 >>> > >>> >> >> >
