Re: Performance tuning for Aggregate in Impala

2017-11-17 Thread Mostafa Mokhtar
Can you please share the query profile along with HW spec for the servers used? mt_dop query options is supported for scan and agg only queries. This is not a dev related question this topic is better suited for the user group. On Fri, Nov 17, 2017 at 12:47 AM, Xu, Cheng A wrote: > Hi > I tried

Performance tuning for Aggregate in Impala

2017-11-17 Thread Xu, Cheng A
Hi I tried to run TPC-DS query51 using Impala. It showed poor performance in some exchange and aggregate (highlighted by yellow color) with very low CPU utilization. Suggested by https://www.cloudera.com/documentation/enterprise/latest/topics/impala_mt_dop.html, I tried MT_DOP but failed to the