Hi @amitshanker    Thanks for the update.   I can see than you had set hive.server2.webui.use.spnego as true, that means kerberos is enabled in your cluster.   If spnego and kerberos are enabled then few settings needs to be changed in browser. Could you please follow the below link.   https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cdh_sg_browser_access_kerberos_protected_url.html ... View more

Thanks for the details.   Can you share the hive-site.xml file Can you share me the complete screenshot of the error you are facing Do you have kerberos enabled in your cluster? ... View more

Hi @amitshanker    Could you let me know whether you are using CDH/HDP/CDP? What is the document which you had followed to enable HS2 UI? Can you share me the screenshot of the error you are facing Do you have kerberos enabled in your cluster? ... View more

Hi @ryu  [root@test02 ~]# hdfs dfs -rmr /tmp/root/testdirectory ... ... 21/08/11 12:08:30 WARN fs.TrashPolicyDefault: Can't create trash directory: hdfs://test/user/root/.Trash/Current/tmp/root ... ... rmr: Failed to move to trash: hdfs://test/tmp/root/testdirectory: Permission denied: user=root, access=WRITE, inode="/user":hdfs:hdfs:drwxr-xr-x   Upon checking the logs you are trying to delete a testdirectory and if you do that it will try to move the file to trash directory(since trash is enabled) under "/user/root/.Trash" location.   Since the folder /user("inode="/user":hdfs:hdfs:drwxr-xr-x") has hdfs as primary and group so eventually the user root falls under others(that is the third one r-x). The other users does not have write permission so that he was not able to write.   Either give write permission for user root in to the folder or try to delete the folder as hdfs user to overcome the issue.   If you are happy with the reply, mark it Accept as Solution ... View more

Hi @Nil_kharat    Question: Can anyone tell me how to check how many users are connected to the hive server2? Answer: Login to the server where hiveserver2 is running and run the below command to figure out the number of connections to the HS2 # netstat -ntpl | grep 10000 In the above command 10000 is the HS2 port number You can also check this from Cloudera manager CM > Hive_on_Tez > Instances > HiveServer2 > Open Connections And along with can we see which user is connected? If you enable Hiveserver2 UI then under Active Sessions you can see which user connected from which IP. Please check the below link. https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-WebUIforHiveServer2   If you are happy with the answer, mark it Accept as solution ... View more

Hi @PURUSHOTHAMAN_S    I can see there are a lot of alerts(28) in Ambari, if I were you I will start checking with HDFS service at first like namenode are up and running because it is vital for other services to come up. Then you may need to check YARN and then you can concentrate on others.   Check out the Ambari startup logs to see why and where it is getting failed.   Hope it helps. ... View more

Hello @vidanimegh    Error: Error while compiling statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Application application_1623850591633_0042 failed 2 times due to AM Container for appattempt_1623850591633_0042_000002 exited with exitCode: -104 Failing this attempt.Diagnostics: [2021-06-18 18:32:52.722]Container [pid=32822,containerID=container_e49_1623850591633_0042_02_000001] is running 34230272B beyond the 'PHYSICAL' memory limit. Current usage: 2.0 GB of 2 GB physical memory used; 3.9 GB of 4.2 GB virtual memory used. Killing container. As I can see your jobs are getting failed with PHYSICAL memory limit error.  Could you set the below property in beeline session level and re-run the analysis query and see how it goes. set hive.tez.container.size=8192; set hive.tez.java.opts=-Xmx6553; set tez.runtime.io.sort.mb=3072; set tez.task.resource.memory.mb=8192; set tez.am.resource.memory.mb=8192; set tez.am.launch.cmd-opts=-Xmx6553m; ... View more