are you using beeline client tool ?  did you try increasing heap on  the below property    HADOOP_CLIENT_OPTS     just curious to know below following  what file format are you using ?  is there any compression ?  is table stats being collected ?  is table being partitioned or buckted ?  ... View more

@resolution,   What version of Cloudera Manager are you using?  In recent releases, it should not be possible to have this sort of thing happen unless your database is indeed without any information.   Go to the following directory: /etc/cloudera-scm-server   Next, look at the db.properties file. Make sure it is configured properly with your correct database host, port, etc.   If not, you can also look at other db.properties files in the directory to see if any of them may contain the correct information.   If you are unsure, feel free to share the information here (redcacting your password if necessary) ... View more

try add allow port on firewalld on host, this solved my prob $ firewall-cmd --zone=public --add-port=9000/tcp (Centos7) or $ service firewalld disable Hope this may help ... View more