@ssk26 , Can you please check the value of below settings? yarn.app.mapreduce.am.resource.mb yarn.app.mapreduce.am.resource.cpu-vcores Cheers Eric ... View more

@Eediej, I believe that you are looking for this feature: https://issues.apache.org/jira/browse/IMPALA-2083 But it is still not resolved, so I guess not supported in Impala. Not sure if below can help you to implement in Hive, I haven't tried myself: https://community.cloudera.com/t5/Support-Questions/Hive-Transpose-the-set-of-rows/td-p/148685 If you end up get it working, please share result here so that other members can benefit. Cheers Eric ... View more

@Cl0ck Each host's name is stored in CM's backend database with an UUID attached, please refer to table HOSTS. Example as below:   HOST_ID: 12 OPTIMISTIC_LOCK_VERSION: 148 HOST_IDENTIFIER: bfaf4b71-01e2-4157-b46f-d1c13566b69a NAME: host-xxx-xxx.xxx IP_ADDRESS: xx.xx.xx.xx RACK_ID: /default STATUS: NA CONFIG_CONTAINER_ID: 1 MAINTENANCE_COUNT: 0 DECOMMISSION_COUNT: 0 CLUSTER_ID: 1 NUM_CORES: 1 TOTAL_PHYS_MEM_BYTES: 1929342976 PUBLIC_NAME: NULL PUBLIC_IP_ADDRESS: NULL CLOUD_PROVIDER: NULL   Where HOST_IDENTIFIER is the UUID, and is stored under /var/lib/cloudera-scm-agent/uuid on each host. Maybe you can try to update the table here for NAME field and see if that can help? Cheers Eric ... View more

@sagittarian , Can you please share the full stacktrace of the error? Both from HS2 log and yarn application logs? Thanks Eric ... View more

Hi @sahilk I worked on this last year, and it turned out at the time, it was not supported, as HS2 and HMS will generate the credentials themselves, please see my blog post using below link:   Access S3 in Hive Through hadoop.security.credential.provider.path   However, it was based on CDH, looks like you are on HDP, so stories might be different, but might need other Hive guys' input here.   Cheers Eric   ... View more

@kvinod CM 5.8.x is very old, is there any reason that you do not want to upgrade? As @lwang mentioned, higher version of CM supported downgrade back to Express version, so I guess the option is for you to upgrade first. But personally I don't see any issues if you don't want to do anything. After expiry, the only difference would be that Enterprise features won't be available, but cluster should still function. Unless Li can provide more insights. Cheers Eric ... View more