Hi @wbaihp ,   1. Is this issue with all the queries or any few queries? 2. Please attach the query profile and its coordinator logs to have a look.   ... View more

Hi @kairel  This is hitting the HS2 thread count limit ,can you follow below steps and let us know if this helps?   Go ahead and set the following parameters:   1. Hive > Configs > Advanced > Custom hive-site       hive.server2.async.exec.threads=10      hive.server2.async.exec.wait.queue.size=10   2.  Restart hiveserver2 ... View more

Hi @uraz , Please paste the entire console output or screenshot of the error you are facing..Also check the HS2 logs if there is any exception please do attach that as well.. ... View more

Yes, It seems to be not properly installed. May i know you are using plain Hadoop or CDH or HDP to manage it? If you have followed any document for the hadoop installation provide the link here... ... View more

Hi, Go to /etc/alterenatives provide the output for below commands: ( This is to check if linux alternatives subsystem is pointing to the binaries from an other old version of CDH that you are not using currently)   Example: [root@node2 alternatives]# ls -lrth | grep hdfs lrwxrwxrwx  1 root root 62 Aug 15  2020 hdfs -> /opt/cloudera/parcels/CDH-6.2.1-1.cdh6.2.1.p0.4951328/bin/hdfs   [root@node2 alternatives]# ls -lrth /usr/bin/hdfs lrwxrwxrwx 1 root root 22 Aug 15  2020 /usr/bin/hdfs -> /etc/alternatives/hdfs   What is the CDH version you are using currently? Have you recently upgraded the cluster? In my previous comment I have added “#” just for pointing the command if you have added same in the ~/.bash_profile do remove the “#” and try. How you installed hdfs? is it possible for you to re install it? ... View more

Seems to be hdfs is not installed/configured properly, Can you check the path of it by using "which hdfs" command. If you are not able to see the path check the environment variable in "~/.bash_profile" file.  set the path something like below and try: ## PATH=$PATH:$HADOOP_HOME/bin   then run -> source ~/.bash_profile   Below is the output from my test cluster: [root@node2 bin]# which hdfs /usr/bin/hdfs [root@node2 bin]# sudo -u hdfs hdfs dfsadmin -safemode leave Safe mode is OFF [root@node2 bin]# id hdfs uid=993(hdfs) gid=990(hdfs) groups=990(hdfs)     ... View more

Hi, Can you try with below command and see? ## sudo -u hdfs hdfs dfsadmin -safemode leave   If this doesn't work provide the output of below from the terminal: ## id hdfs ... View more

Safemode in Hadoop is a maintenance state of NameNode, during which NameNode doesn’t allow any modifications to the file system. can you use below command to come out of the safemode and try to create a directory?   ## hadoop dfsadmin -safemode leave ## hdfs dfs -mkdir /user/justee ... View more