This is what I ran to clean up the issue on my ambari database, thank you for the post: delete from ambari.serviceconfigmapping where service_config_id in (select service_config_id from ambari.serviceconfig where service_name in ('PXF','HAWQ','ZEPPELIN')); delete from ambari.hostcomponentstate where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.hostcomponentdesiredstate where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.servicecomponentdesiredstate where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.servicedesiredstate where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.serviceconfig where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.requestresourcefilter where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.requestoperationlevel where service_name in ('PXF','HAWQ','ZEPPELIN'); delete from ambari.clusterservices where service_name in ('PXF','HAWQ','ZEPPELIN'); ... View more

Sorry I haven't responded yet been out of the office with the holidays. From what I can tell the reduce memory is set to 5GB. I am unsure about the number of reduces. We have an 8 node cluster each node has 16 cores and 192 GB of RAM. ... View more