Thanks. Brain fart.
On Wed, Apr 8, 2015 at 8:26 PM, Aman Sinha <[email protected]> wrote: > Why ? limit is applied to the final result set of the query. If you did > select count(*) from (select * from T limit 3) you will get 3. > > On Wed, Apr 8, 2015 at 6:20 PM, Ted Dunning <[email protected]> wrote: > > > Am I missing something? It seems that count should return 3 in the > second > > query. > > > > This happens with the 0.8.0 release running in embedded mode. > > > > > > 0: jdbc:drill:zk=local> select count(1) from > > dfs.`/Users/tdunning/tmp/apache-drill-0.8.0/foo/*`; > > +------------+ > > | EXPR$0 | > > +------------+ > > | 20000 | > > +------------+ > > 1 row selected (1.311 seconds) > > 0: jdbc:drill:zk=local> select count(*) from > > dfs.`/Users/tdunning/tmp/apache-drill-0.8.0/foo/*` limit 3; > > +------------+ > > | EXPR$0 | > > +------------+ > > | 20000 | > > +------------+ > > >
