https://community.cloudera.com/t5/Support-Questions/Impala-3-2-0-performance-degradation-while-querying-views/m-p/303506#M221582 <P>Hi&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/80732">@PauloRC</a>&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/11593">@Tim Armstrong</a>&nbsp;,</P><P>&nbsp;</P><P>This might be a performance regression, but also in general a performance inefficiency with a specific planner data structure.</P><P>&nbsp;</P><P>A correctness fix for&nbsp;<A href="https://issues.apache.org/jira/browse/IMPALA-8386" target="_blank" rel="noopener">IMPALA-8386</A>&nbsp;may have introduced this perf regression in 3.2.1,&nbsp;<A href="https://issues.apache.org/jira/browse/IMPALA-9358" target="_blank" rel="noopener">IMPALA-9358</A>&nbsp;may resolve this issue, but I don't think it's available in any CDH 6.3 release yet.<BR /><BR /><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/80732">@PauloRC</a>&nbsp;one thing to try which might mitigate the issue is to run your view query with SET ENABLE_EXPR_REWRITES=false to see if that helps.</P> Mon, 28 Sep 2020 14:58:42 GMT superdupershant 2020-09-28T14:58:42Z