It looks DRILL-3810 caused the regression (and it is limited to Avro files). Hopefully Kamesh can take a quick look.
-- Jacques Nadeau CTO and Co-Founder, Dremio On Sat, Nov 21, 2015 at 1:44 PM, Stefán Baxter <ste...@activitystream.com> wrote: > Hi, > > I just created this: https://issues.apache.org/jira/browse/DRILL-4120 > > Regards, > -Stefan > > On Sat, Nov 21, 2015 at 9:28 PM, Stefán Baxter <ste...@activitystream.com> > wrote: > > > > > 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 > >> > > >> > > > > >
