drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1405) Query on CSV data with filter on directory name fails with DrillBuf error
Date Thu, 11 Sep 2014 23:24:33 GMT
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)

Mime
View raw message