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