You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by Jim Scott <js...@maprtech.com> on 2014/08/15 17:06:49 UTC

Querying with where dir1='X' fails

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)


Am I correct in assuming this is a bug and I should open a Jira? Or is
there no support for querying in the where clause for second level
directories?



-- 
*Jim Scott*
Director, Enterprise Strategy & Architecture

 <http://www.mapr.com/>
[image: MapR Technologies] <http://www.mapr.com>

Re: Querying with where dir1='X' fails

Posted by Neeraja Rentachintala <nr...@maprtech.com>.

This is probably specific to csv. It works fine for me with json.

> On Aug 15, 2014, at 11:46 AM, Steven Phillips <sp...@maprtech.com> wrote:
> 
> Yes, that should work. Please open a jira.
> 
> 
>> On Fri, Aug 15, 2014 at 8:06 AM, Jim Scott <js...@maprtech.com> wrote:
>> 
>> 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)
>> 
>> 
>> Am I correct in assuming this is a bug and I should open a Jira? Or is
>> there no support for querying in the where clause for second level
>> directories?
>> 
>> 
>> 
>> --
>> *Jim Scott*
>> Director, Enterprise Strategy & Architecture
>> 
>> <http://www.mapr.com/>
>> [image: MapR Technologies] <http://www.mapr.com>
> 
> 
> 
> -- 
> Steven Phillips
> Software Engineer
> 
> mapr.com

Re: Querying with where dir1='X' fails

Posted by Steven Phillips <sp...@maprtech.com>.

Yes, that should work. Please open a jira.


On Fri, Aug 15, 2014 at 8:06 AM, Jim Scott <js...@maprtech.com> wrote:

> 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)
> 
>
> Am I correct in assuming this is a bug and I should open a Jira? Or is
> there no support for querying in the where clause for second level
> directories?
> 
>
>
> --
> *Jim Scott*
> Director, Enterprise Strategy & Architecture
>
>  <http://www.mapr.com/>
> [image: MapR Technologies] <http://www.mapr.com>
>



-- 
 Steven Phillips
 Software Engineer

 mapr.com