impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Behm <alex.b...@cloudera.com>
Subject Re: WITH clause
Date Wed, 19 Oct 2016 13:40:08 GMT
Impala will execute the WITH-clause multiple times.

See: https://issues.cloudera.org/browse/IMPALA-1719

On Wed, Oct 19, 2016 at 2:02 AM, Buntu Dev <buntudev@gmail.com> wrote:

> I got a subquery that is used more than once in a query. If I use the WITH
> clause for the subquery, does it help reduce the query time or does impala
> have inherent optimization where the subquery is only executed once and
> then reused everywhere it is used irrespective of the WITH clause? Please
> help clarify.
>
> Thanks!
>

Mime
View raw message