Member since
12-21-2015
9
Posts
1
Kudos Received
0
Solutions
01-30-2017
03:50 PM
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
12-28-2015
07:29 PM
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