Re: What kind of sql query can generate multiple children for EXCHANGE node?

[Alexander Behm]

Yes, we should. That comment is an ancient remnant of how we used to
execute union plans. Today, that comment is simply wrong.

On Mon, Feb 5, 2018 at 3:27 PM, Xinran Yu Tinney 
wrote:

> Thanks Alex, should we clarify this in the comment of ExchangNode.java
> "Typically, an ExchangeNode only has a single sender child but,
>  e.g., for distributed union queries an ExchangeNode may have one sender
> child per
>  union operand."
>
> 2018-02-05 11:53 GMT-06:00 Alexander Behm :
>
> > An exchange node can only have one child
> >
> > On Mon, Feb 5, 2018 at 9:52 AM, Xinran Yu Tinney  >
> > wrote:
> >
> > > Hi, Impala dev,
> > >I am working on Jira IMPALA-5440
> > >  and one of the
> > problem
> > > is to test that Impala will handle cardinality overflow when there are
> > > multiple children under EXCHANGE node. I searched among the examples of
> > > .test file and could not find one. I was wondering if anyone has
> > experience
> > > running such queries? Thanks!
> > >
> > >
> > > Xinran
> > >
> >
>

Re: What kind of sql query can generate multiple children for EXCHANGE node?

[Fernando Rodriguez]

unsubscribe

On Mon, Feb 5, 2018 at 4:27 PM, Xinran Yu Tinney 
wrote:

> Thanks Alex, should we clarify this in the comment of ExchangNode.java
> "Typically, an ExchangeNode only has a single sender child but,
>  e.g., for distributed union queries an ExchangeNode may have one sender
> child per
>  union operand."
>
> 2018-02-05 11:53 GMT-06:00 Alexander Behm :
>
> > An exchange node can only have one child
> >
> > On Mon, Feb 5, 2018 at 9:52 AM, Xinran Yu Tinney  >
> > wrote:
> >
> > > Hi, Impala dev,
> > >I am working on Jira IMPALA-5440
> > >  and one of the
> > problem
> > > is to test that Impala will handle cardinality overflow when there are
> > > multiple children under EXCHANGE node. I searched among the examples of
> > > .test file and could not find one. I was wondering if anyone has
> > experience
> > > running such queries? Thanks!
> > >
> > >
> > > Xinran
> > >
> >
>

Re: What kind of sql query can generate multiple children for EXCHANGE node?

[Xinran Yu Tinney]

Thanks Alex, should we clarify this in the comment of ExchangNode.java
"Typically, an ExchangeNode only has a single sender child but,
 e.g., for distributed union queries an ExchangeNode may have one sender
child per
 union operand."

2018-02-05 11:53 GMT-06:00 Alexander Behm :

> An exchange node can only have one child
>
> On Mon, Feb 5, 2018 at 9:52 AM, Xinran Yu Tinney 
> wrote:
>
> > Hi, Impala dev,
> >I am working on Jira IMPALA-5440
> >  and one of the
> problem
> > is to test that Impala will handle cardinality overflow when there are
> > multiple children under EXCHANGE node. I searched among the examples of
> > .test file and could not find one. I was wondering if anyone has
> experience
> > running such queries? Thanks!
> >
> >
> > Xinran
> >
>

Re: ERROR: NotImplementedException: MT_DOP not supported

[Jim Apple]

Can you provide the DDL you used when creating the table? Can you
provide the query you used to insert? Can you describe what command or
query you used to set a specific row's numDVs?

On Mon, Feb 5, 2018 at 3:03 PM, Xinran Yu Tinney  wrote:
> Thanks Tim, sorry that the attachment does not go through, I was not aware
> that. basically, I was trying to insert some values in a partitioned table
> and trying to find a way set a specific row's numDVs and the error happened.
>
> 2018-02-05 15:24 GMT-06:00 Tim Armstrong :
>
>> We don't support multithreaded execution for all plans currently. I think
>> the docs do a good job of explaining the current limitations:
>> https://impala.apache.org/docs/build/html/topics/impala_mt_dop.html
>>
>> On Mon, Feb 5, 2018 at 1:05 PM, Xinran Yu Tinney 
>> wrote:
>>
>> > Hi, Impala dev,
>> >I was creating a table with partitions and then trying to insert into
>> > the table some values, but it shows :
>> >
>> > ERROR: NotImplementedException: MT_DOP not supported
>> >
>> > Please see the attachment.
>> >
>> > Is there anyone can explain why this happens? Thanks!
>> >
>> > Xinran
>> >
>>

Re: ERROR: NotImplementedException: MT_DOP not supported

[Tim Armstrong]

We don't support insert plans with mt_dop > 0 at the moment. I'd expect it
to work for plans that don't involve inserting into a table or any joins.

On Mon, Feb 5, 2018 at 3:03 PM, Xinran Yu Tinney 
wrote:

> Thanks Tim, sorry that the attachment does not go through, I was not aware
> that. basically, I was trying to insert some values in a partitioned table
> and trying to find a way set a specific row's numDVs and the error
> happened.
>
> 2018-02-05 15:24 GMT-06:00 Tim Armstrong :
>
> > We don't support multithreaded execution for all plans currently. I think
> > the docs do a good job of explaining the current limitations:
> > https://impala.apache.org/docs/build/html/topics/impala_mt_dop.html
> >
> > On Mon, Feb 5, 2018 at 1:05 PM, Xinran Yu Tinney  >
> > wrote:
> >
> > > Hi, Impala dev,
> > >I was creating a table with partitions and then trying to insert
> into
> > > the table some values, but it shows :
> > >
> > > ERROR: NotImplementedException: MT_DOP not supported
> > >
> > > Please see the attachment.
> > >
> > > Is there anyone can explain why this happens? Thanks!
> > >
> > > Xinran
> > >
> >
>

Re: ERROR: NotImplementedException: MT_DOP not supported

[Xinran Yu Tinney]

Thanks Tim, sorry that the attachment does not go through, I was not aware
that. basically, I was trying to insert some values in a partitioned table
and trying to find a way set a specific row's numDVs and the error happened.

2018-02-05 15:24 GMT-06:00 Tim Armstrong :

> We don't support multithreaded execution for all plans currently. I think
> the docs do a good job of explaining the current limitations:
> https://impala.apache.org/docs/build/html/topics/impala_mt_dop.html
>
> On Mon, Feb 5, 2018 at 1:05 PM, Xinran Yu Tinney 
> wrote:
>
> > Hi, Impala dev,
> >I was creating a table with partitions and then trying to insert into
> > the table some values, but it shows :
> >
> > ERROR: NotImplementedException: MT_DOP not supported
> >
> > Please see the attachment.
> >
> > Is there anyone can explain why this happens? Thanks!
> >
> > Xinran
> >
>

What kind of sql query can generate multiple children for EXCHANGE node?

[Xinran Yu Tinney]

Hi, Impala dev,
   I am working on Jira IMPALA-5440
 and one of the problem
is to test that Impala will handle cardinality overflow when there are
multiple children under EXCHANGE node. I searched among the examples of
.test file and could not find one. I was wondering if anyone has experience
running such queries? Thanks!


Xinran