After some digging around there is an explanation. This all works fine when the directory structure contains Parquet files but it breaks is the same structure contains Avro files.
I have no clue to why that is and I hope you do. -Stefan On Sat, Nov 21, 2015 at 3:58 PM, Jacques Nadeau <jacq...@dremio.com> wrote: > I'm not seeing the problem. Can you provide more information (file type, > exact commit, etc)? > > Below is what I get with 1.3rc3. > > $ tree /src/data/stuff > /src/data/stuff > ├── s1 > │ └── 1.parquet > └── s2 > └── 1.parquet > > > 0: jdbc:drill:zk=local> select dir0, count(*) from > dfs.root.`/src/data/stuff` group by dir0; > +-------+---------+ > | dir0 | EXPR$1 | > +-------+---------+ > | s2 | 60175 | > | s1 | 60175 | > +-------+---------+ > > select l_partkey from dfs.root.`/src/data/stuff` where dir0 = 's1' limit > 1; > +------------+ > | l_partkey | > +------------+ > | 1552 | > +------------+ > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Sat, Nov 21, 2015 at 3:47 AM, Stefán Baxter <ste...@activitystream.com> > wrote: > > > Hi, > > > > I'm running the latest 1.3 build and I can no longer use dirN in my > > queries. > > > > The query: > > select * from dfs.asa.`/some-root-dir/` as s where dir0 = '2015-11-19'; > > > > The error I get is: > > Error: "VALIDATION ERROR: From line 1, column 72 to line 1, column 75: > > Column 'dir0' not found in any table" > > > > > > Any ideas? > > > > Regards, > > -Stefan > > >