Aman Sinha created DRILL-1405:
---------------------------------
Summary: Query on CSV data with filter on directory name fails with DrillBuf
error
Key: DRILL-1405
URL: https://issues.apache.org/jira/browse/DRILL-1405
Project: Apache Drill
Issue Type: Bug
Components: Execution - Operators
Affects Versions: 0.5.0
Reporter: Aman Sinha
I have 2 subdirectories under mydata: mydata/d1, mydata/d2 and each subdir has the following
files:
d1/t1.csv:
9711942,name0,last0
9707867,name1,last1
d2/t2.csv:
9711942,HX362083
9707867,HX357851
This works fine:
0: jdbc:drill:zk=local> select * from dfs.`/Users/asinha/data/mydata` as x;
+------------+------------+
| columns | dir0 |
+------------+------------+
| ["9711942","HX362083"] | d2 |
| ["9707867","HX357851"] | d2 |
| ["9711942","name0","last0"] | d1 |
| ["9707867","name1","last1"] | d1 |
+------------+------------+
This works fine too:
0: jdbc:drill:zk=local> select * from dfs.`/Users/asinha/data/mydata` as x where x.dir0
= 'd2';
+------------+------------+
| columns | dir0 |
+------------+------------+
| ["9711942","HX362083"] | d2 |
| ["9707867","HX357851"] | d2 |
+------------+------------+
The following fails:
0: jdbc:drill:zk=local> select * from dfs.`/Users/asinha/data/mydata` as x where x.dir0
= 'd1';
Error: exception while executing query: DrillBuf(ridx: 0, widx: 0, cap: 0/0, unwrapped: DrillBuf(ridx:
0, widx: 0, cap: 0/0, unwrapped: EmptyByteBufLE)).slice(0, 4) (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
|