The configuration file it is set in is hive-site.xml. CM provides Advance Configuration snippets where this can be added. The trick is getting it in the right one. I don't know for sure as I haven't tested it. The settings would apply to the specific jobs being launched through Hive. I would think that at a minimum you needed it on the Gateway and also the HiveServer2. You could play it safe and filter by Advance and then search for hive-site.xml in CM and then add it to all ACS.