thnx :) On Sat, Nov 21, 2015 at 11:00 PM, Jacques Nadeau <jacq...@dremio.com> wrote:
> 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 > > >> > > > >> > > > > > > > > >