Couple days ago, there were some discussions regarding to the "limit" operator in the following drill-dev thread:
http://mail-archives.apache.org/mod_mbox/incubator-drill-dev/201410.mbox/%3ccaaoihjef+iep_h6isx4mrenywcvjjbittyvk7ykn+8wqi7+...@mail.gmail.com%3e On Mon, Oct 13, 2014 at 7:27 AM, mufy <[email protected]> wrote: > Just so that all are aware: > > We're noticing this behavior irrespective of the data size. Even a simple > show tables against 'sys' DB itself is malfunctioning. Continuing to look > into the health of the cluster setup. > > > --- > Mufeed Usman > My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My > Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal > <http://mufeed.livejournal.com> > > > > > On Sun, Oct 12, 2014 at 2:06 AM, Ted Dunning <[email protected]> > wrote: > > > The question implied by what Chris asks is whether there is a mechanism > > whereby a consumer can notify a producer that no more data is required? > > > > In the case of this query, once Chris has his 10 rows, shouldn't the > > consumer signal (transitively) all upstream parts of the query that they > > can go home now? > > > > > > On Sat, Oct 11, 2014 at 1:24 PM, Christopher Matta <[email protected]> > > wrote: > > > > > My data is in a directory on a 4 node MapR cluster, the csv files are > > > partitioned into 4 dirs, each with 100 csv files with 10 million > records, > > > totaling 4 billion records. > > > > > > When I do a SELECT * FROM FACT LIMIT 10; the data returns, however the > > > sqlline prompt never comes back and the profile says the query is still > > > running. I can ctrl+c the query which returns the10 rows selected > > (360.949 > > > seconds) report and the sqlline prompt, but the profiles page shows the > > > query as still running. > > > > > > The drillbit.log doesn’t show any errors during this. > > > > > > Seems like a bug, but I would like to gather more evidence before > > > submitting it, any ideas? > > > > > > Chris Matta > > > [email protected] > > > 215-701-3146 > > > > > > > > >
