@devdb Take a look of this may be it can help : https://archive.cloudera.com/cm7/7.2.4/generic/jar/cm_api/apidocs/   Also you can get the hosts details from this :  http://CM-SERVER:7180/api/v19/clusters/cluster1/services   For each ‘hosts’ in http://cm:7180/api/v19/hosts    iterate through the hostId … { "items" : [ { "maintenanceOwners" : [ ], "hostId" : "15b5c47f-9156-4347-abd4-efbc79d27ba2", <=== hostid "ipAddress" : "IP", "hostname" : "host", http://cm:7180/api/v19/hosts/15b5c47f-9156-4347-abd4-efbc79d27ba2. which should give you the roleName ... { "clusterName" : "Cluster 1", "serviceName" : "HDFS-1", "roleName" : "HDFS-1-DATANODE-d1ee4c53b9fbc4786263f0420c5157e8" }, { ... using the roleName http://cm:7180/api/v19/clusters/Cluster%201/services/HDFS-1/roles/HDFS-1-DATANODE-d1ee4c53b9fbc4786263f0420c5157e8  Also full deployment details http://cm:7180/api/v19/cm/deployment ... View more

This seems a Connection time out to the name node so you may want to check if there is any Network issue or something else going on with CM's help. That should give you some clue. ... View more

@sur I believe you have to Set below properties before executing create table statement.  SET hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; SET hive.support.concurrency=true; This seems a very known behaviour and I did a simple Googling and found the solutions on several places. Below are the references.  https://stackoverflow.com/questions/42669171/semanticexception-error-10265-while-running-simple-hive-select-query-on-a-tran https://dbmstutorials.com/hive/hive-errors.html https://knowledge.informatica.com/s/article/526538?language=en_USv Hope this helps.  ... View more

@sur I believe you have to run the queries over Impala not Hive. I have tested below and it works several time in the past.  # Install Libraries !pip3 install impyla==0.13.8 !pip3 install thrift_sasl==0.2.1 !pip3 install thrift==0.9.3 !pip3 install sasl==0.2.1 # Connect to Impala from impala.dbapi import connect conn = connect(host='host', port=21050, auth_mechanism='GSSAPI', use_ssl=True, kerberos_service_name='impala') # Execute Query sql = "select * from table" cursor = conn.cursor() cursor.execute(sql) results = cursor.fetchall() You can refer the below doc: https://docs.cloudera.com/cdsw/1.9.1/import-data/topics/cdsw-running-queries-on-impala-tables.html ... View more

@lovebo Does this folder exists? This seems coming from Webhdfs. You may have to look at permission as well for users.  ... View more