incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mufy <mufeed.us...@gmail.com>
Subject Re: Query on CSV data not returning to the sqlline prompt
Date Mon, 13 Oct 2014 14:27:25 GMT
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 <ted.dunning@gmail.com> 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 <cmatta@mapr.com>
> 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
> > cmatta@mapr.com
> > 215-701-3146
> > ​
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message