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?
From: Tim Armstrong <tarmstr...@cloudera.com>
Reply-To: "firstname.lastname@example.org" <email@example.com>
Date: Friday, February 9, 2018 at 12:24 PM
To: "firstname.lastname@example.org" <email@example.com>
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