Hello @hebamahmoud  If the issue is has been from any of the above responses, Could you accept it as a solution? Regards, Chethan YM ... View more

@Yasine,  I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. ... View more

@tsunamisabella, did the responses from @ChethanYM  assist you in resolving your concerns? If so, could you kindly designate the most suitable response as the solution? This will be beneficial for other members who might come across a similar issue.   ... View more

OK! @Juanes 😉 thanks for the clarification. ... View more

Yes, User group mapping should be across the cluster nodes not only on name-node. ... View more

Hi, Is Impala session hang means not able to run any queries? Is this issue observed via hue or impala-shell? repro the issue via impala-shell and check the coordinator logs to get any suspected error messages.  At the time of issue check the cluster load how may queries running concurrently, Issue may arise if any expensive/complex operations are running. Do not frequently run "invalidate metadata" query in the cluster it is one of the expensive operations and it pressurises the catalog service.   Regards, Chethan YM     ... View more

Hi @sukui    Can you add following --llvm_cpu_attr_whitelist  to Impala Daemon Command Line Argument Advanced Configuration Snippet (Safety Valve). --llvm_cpu_attr_whitelist=adx,aes,avx,avx2,bmi,bmi2,cmov,cx16,f16c,fma,fsgsbase,hle,invpcid,lzcnt,mmx,movbe,pclmul,popcnt,prfchw,rdrnd,rdseed,rtm,smap,sse,sse2,sse3,sse4.1,ssse3,xsave,xsaveopt   Restart impala and see if it helps.   Regards, Chethan YM ... View more

Could you please share screenshots of the Instance tab from both Hive and Hive on Tez services? Based on our experience, the following action should resolve the issue.   Stop and delete the "HiveServer2" and "WebHCat" instances from Cloudera Manager > Hive > Instances Check that the role "HiveServer2" is present in Cloudera Manager > Hive on Tez > Instances Verify the Configuration page for 'Hive on Tez'; ensure that 'Hive Metastore Connector' is pointed at the Hive service that is running the Hive Metastore Restart the stale services ... View more

Thank you for helping me solve the problem。 ... View more