drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Questions on drill execution
Date Mon, 04 May 2015 22:10:08 GMT
Is that video linked from the web site?  Looks like a really great resource.



On Mon, May 4, 2015 at 6:23 PM, Hao Zhu <hzhu@maprtech.com> wrote:

> https://www.youtube.com/watch?v=kG6vzsk8T7E
> This presentation contains lots of details for query execution plan.
>
> On Mon, May 4, 2015 at 7:10 AM, Carol McDonald <cmcdonald@maprtech.com>
> wrote:
>
> > https://cwiki.apache.org/confluence/display/DRILL/EXPLAIN+Commands
> >
> > On Mon, May 4, 2015 at 3:46 AM, George Lu <luwenbin888@gmail.com> wrote:
> >
> > > Dear all,
> > >
> > > I have deployed Drill on several nodes in the cluster and experienced
> the
> > > query.
> > > I have some questions:
> > >
> > > 1) Can anyone show me some links to read for the Drill execution plan,
> > how
> > > to understand it.
> > >
> > > 2) I execute some group by query on HBase several times, some time very
> > > fast, while sometimes very slow, and even get exception, like "Query
> > > failed: RemoteRpcException: Failure while running fragment., Command
> > failed
> > > while establishing connection.  Failure type CONNECTION. [
> > > 2ba2092f-53ed-480a-9f23-f89b6e6a91a0 on test6:31010 ]
> > > [ 2ba2092f-53ed-480a-9f23-f89b6e6a91a0 on test6:31010 ]
> > >
> > >
> > > java.lang.RuntimeException: java.sql.SQLException: Failure while
> > executing
> > > query.
> > > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> > > at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> > > at sqlline.SqlLine.print(SqlLine.java:1809)
> > > at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> > > at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> > > at sqlline.SqlLine.dispatch(SqlLine.java:889)
> > > at sqlline.SqlLine.begin(SqlLine.java:763)
> > > at sqlline.SqlLine.start(SqlLine.java:498)
> > > at sqlline.SqlLine.main(SqlLine.java:460)"
> > >
> > > I am not sure whether Drill uses pre-execute like in Hadoop or auto
> > failure
> > > detection. If some of the execution node failed, what will happen? If
> > some
> > > node is under high pressure for other task, and what will happen if
> this
> > > node becomes the one who drags the whole execution slow?
> > >
> > > Thanks!
> > >
> > > George
> > >
> >
>

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