[jira] [Created] (DRILL-1312) dir1='X' for delimited files causes query failures

[Jim Scott (JIRA)]

Jim Scott created DRILL-1312:
--------------------------------

             Summary: dir1='X' for delimited files causes query failures
                 Key: DRILL-1312
                 URL: https://issues.apache.org/jira/browse/DRILL-1312
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
    Affects Versions: 0.4.0
            Reporter: Jim Scott


​I have a nested directory with delimited files in them
1970/01
1970/02
...

When I query:
select columns[0] from mypath limit 10; -> SUCCEEDS
select columns[0] from mypath where dir0='1970' limit 10; -> SUCCEEDS
select columns[0] from mypath where dir1='01' limit 10; -> FAILS
​
​Query failed: Failure while running fragment. Schema is currently null.  You 
must call buildSchema(SelectionVectorMode) before this container can return a 
schema. [af55e6fc-38e4-46ae-bd46-fa68b15ba42a]
Error: exception while executing query: Failure while trying to get next result 
batch. (state=,code=0)

​select columns[2] from mypath where dir0='1970' and dir1='01' limit 10; -> 
FAILS
Query failed: Failure while running fragment. null 
[118098fe-1f19-4570-bdda-cc8426870807]
Error: exception while executing query: Failure while trying to get next result 
batch. (state=,code=0)
​



--
This message was sent by Atlassian JIRA
(v6.2#6252)