drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <jinfengn...@gmail.com>
Subject Re: Query on CSV data not returning to the sqlline prompt
Date Mon, 13 Oct 2014 16:52:53 GMT
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+fZw@mail.gmail.com%3e


On Mon, Oct 13, 2014 at 7:27 AM, mufy <mufeed.usman@gmail.com> 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 <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