impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Piyush Narang <p.nar...@criteo.com>
Subject Re: Debugging Impala query that consistently hangs
Date Fri, 09 Feb 2018 19:44:39 GMT
Actually, looking at this again, the hash join that is consuming 179GB is supposed to be partitioned
right? How would stats change that?
I checked the query I kicked off and I have this there, “left outer join /* +SHUFFLE */”.
I think without it I end up with query failures.

Is there something I’m missing?

-- Piyush


From: Tim Armstrong <tarmstrong@cloudera.com>
Reply-To: "user@impala.apache.org" <user@impala.apache.org>
Date: Friday, February 9, 2018 at 12:24 PM
To: "user@impala.apache.org" <user@impala.apache.org>
Subject: Re: Debugging Impala query that consistently hangs

07:HASH JOIN              1    0.000ns    0.000ns        0          -1  179.72 GB        2.00
GB  LEFT OUTER JOIN, PARTITIONED


Mime
View raw message