Hive connection error JETL

ISSUE:

The job tries to  load data from Hive tables to MySQL tables, While loading to MySql getting below error while connecting to Hive.

"[iNFO ]: hive.metastore - Trying to connect to metastore with URI thrift://ecprodns:9083/

[WARN ]: hive.metastore - Failed to connect to the MetaStore Server...

org.apache.thrift.transport.TTransportException: java.net (https://java.net/) .UnknownHostException: ec1prodns"

Resolution:

This seems to be a configuration issue and suggest to check on below information:-

- First of all, the goal will be to create a metadata connection that will pull the configuration from your cluster directly. The connection should fetch all the services including HDFS, HIVE and other ones which are used.

** While creating the metadata connection to hive, please make sure that the hostname is pointing to the actual hostname and not the nameservice name.

* Nameservice name should be given to only node manager & the resource manager and not to hive metastore host.