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 <[email protected]>
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
>
