This is probably specific to csv. It works fine for me with json.
> On Aug 15, 2014, at 11:46 AM, Steven Phillips <[email protected]> wrote: > > Yes, that should work. Please open a jira. > > >> On Fri, Aug 15, 2014 at 8:06 AM, Jim Scott <[email protected]> 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
