@hoda moradi Please add/modify below properties in your core-site.xml hadoop.proxyuser.hive.groups=* hadoop.proxyuser.hive.hosts=* Restart required services via Ambari UI and retry your query, it should work. ... View more

@james.jones - I don't think so as you are modifying authorization property, it should not consider sql grants once you set authorization to Ranger. Please also have a look at https://community.hortonworks.com/questions/28136/will-ranger-hive-plugin-override-existing-hive-sec.html ... View more

@Sagar Shimpi Oozie has feature to purge older jobs from database. by default it's 30 days. Actions related to long running coordinators do not purged until co-ordinator completes, ( example - if you have coordinator running for 6 months, then all the related workflows will be there in database for 6 months ) Will the purge scripts remove the running workflows and coordinators? Ans - No it will not. Below are the respective properties and their default values. Useful link - http://stackoverflow.com/questions/31946225/oozie-not-cleaning-up-old-jobs-from-oozie-database oozie.service.PurgeService.older.than 30 Completed workflow jobs older than this value, in days, will be purged by the PurgeService. oozie.service.PurgeService.coord.older.than 7 Completed coordinator jobs older than this value, in days, will be purged by the PurgeService. oozie.service.PurgeService.bundle.older.than 7 Completed bundle jobs older than this value, in days, will be purged by the PurgeService. oozie.service.PurgeService.purge.old.coord.action false Whether to purge completed workflows and their corresponding coordinator actions of long running coordinator jobs if the completed workflow jobs are older than the value specified in oozie.service.PurgeService.older.than. oozie.service.PurgeService.purge.limit 100 Completed Actions purge - limit each purge to this value oozie.service.PurgeService.purge.interval 3600 Interval at which the purge service will run, in seconds. ... View more

@Jobin George Good question! 🙂 Please find answers below: Note - Please take backup of your ambari database before proceeding with suggested steps . 1) Can we delete a service configuration version in Ambari? Below are the tables responsible for holding service configuration version information widget_layout clusterconfigmapping widget_layout_user_widget serviceconfigmapping serviceconfig Suppose I have modified my hdfs configuration by 'kuldeep' user and I want to remove it completely from ambari UI. Please execute below queries in ambari DB ambari=> select * from serviceconfig where user_name like '%kuldeep%'; service_config_id | cluster_id | service_name | version | create_timestamp | stack_id | user_name | group_id | note -------------------+------------+--------------+---------+------------------+----------+-----------+----------+--------- 407 | 2 | HDFS | 15 | 1466844482492 | 1 | kuldeep | | kuldeep (1 row) ambari=> delete from serviceconfigmapping where service_config_id=407; DELETE 11 ambari=> delete from serviceconfig where user_name like '%kuldeep%'; DELETE 1 ambari=> select * from clusterconfigmapping where user_name like '%kuldeep%'; cluster_id | type_name | version_tag | create_timestamp | selected | user_name ------------+------------+----------------------+------------------+----------+----------- 2 | hadoop-env | version1466844481864 | 1466844482490 | 1 | kuldeep (1 row) ambari=> delete from clusterconfigmapping where user_name like '%kuldeep%'; DELETE 1 ambari=> select * from widget_layout where layout_name like '%kuldeep%'; id | layout_name | section_name | scope | user_name | display_name | cluster_id -----+------------------------+--------------+-------+-----------+-------------------------+------------ 152 | kuldeep_hdfs_dashboard | HDFS_SUMMARY | USER | kuldeep | Standard HDFS Dashboard | 2 (1 row) ambari=> delete from widget_layout_user_widget where widget_layout_id='152'; DELETE 10 ambari=> delete from widget_layout where layout_name like '%kuldeep%'; DELETE 1 . 2) How many versions of configs will Ambari save in history? I don't think there is any limit, as this version information gets stored in the Ambari DB. . 3) Does Ambari have any views/method to alert for Job/application Failures? No. We don't have any views for YARN Job browser except for TEZ applications. Hope this information helps. ... View more