Hi Josh, When you say the second query doesn't work, what is the exact behavior? Does it return zero rows?
--Nathan On Fri, Dec 18, 2015 at 3:55 PM, Spoutable <[email protected]> wrote: > I am querying json files on s3 using the s3a storage plugin on drill 1.3 > > The following query works fine > select count(i0) from fh.`2015/12/05` where dir0 = '23’; > > This next query doesnt > select count(i0) from fh.`2015/12/` where dir0 = '05' and dir1 = '23’; > > My understanding is that the two queries were synonymous. > > Ultimately I am working towards the following scenario. > select count(i0) > from fh.`2015/12` > where ((dir0 = '05' and dir1 = '23') or (dir0 = '06' and dir1 = '00’)) > > My files are organized in such a way that the time of the data in the files > isnt perfectly aligned with the time / location of the files themselves. > For reference, Im using aws firehose in case anybody else is using that too. > > Has anybody run into the first problem or second problem and come up with a > good solution to querying subsets of files in adjacent directories? > > Cheers, > Josh Schlesser
