I think I've figured out the solution. In looking at queries in CM using the Impala Queries page and comparing that to what I see in REST API output, it looks like CM shows "Waiting for client" when a query has a finished status but does not have an end time associated with it yet.  In all the queries that I saw in CM, the one's that showed "Waiting for client" had a finished status and a start time in the REST API JSON, but did not have an end time.  I'm going to "assume" that I have this figured out now, but if anyone has any more insight into this, I would appreciate it. ... View more

@Former Member  LookupRecord processor can be used in this case.   Please check if this method works for you. Sample CSV input id,brand,phone 10,Samsung,1 20,Apple,2 Expected output (codes 1 and 2 are replaced with names) id,brand,phone 10,Samsung,Note 20,Apple,iPhone I tried nifi flow as below Lookup record configuration CSV Reader CSV Recordset Writer Didnt make any change.  Used default settings   Simple KeyValue Lookup service.  There are several lookup services available in Nifi.  You may use right service as per your requirement.             ... View more

Tenants are users of the cluster. Lets say you have app teams/users named dev-a, dev-b, dev-c using the cluster,  you will be estimating what resource each team will likely consume and create queue/pool to them with appropriate capacity.  With regards to hierarchy, root would be the top most parent (represents the overall cluster resource) and you will create leaf queues/pool configured with the min/max resources you want to allocate for individual team. Applications gets assigned to the leaf queue and utilize the respective queue resource.   With the utilization report you will have an idea of how much each team had used in its respective queue/pool. "There are no details about hierarchy of the utilization report" --> Are you referring to knowing utilisation at root plus all the leaf queues? https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/monitoring-and-diagnostics/topics/cm-use-cluster-utilization-report-manage-resources.html in the picture shared in this doc you will see an example of overall cluster utilization and the breakup of utilization across individual queues. https://blog.cloudera.com/yarn-capacity-scheduler/ ... View more