You are not doing anything wrong. These are warnings, not necessarily errors.    Please see this discussion for how to get rid of them, if that's what you are aiming for: https://community.cloudera.com/t5/Support-Questions/Hive-CLI-session-warnings/td-p/242988 ... View more

Hello Roshan, THe official documentation for using impala-shell to connect to impala is available here for your version of CDP: https://docs.cloudera.com/cdp-private-cloud-base/7.1.3/impala-manage/topics/impala-shell-connecting.html   Note that the default port to connect to impalad is 21000 (not 27000). Please check which port you are using in your deployment (can be done by running  netstat -tulpn | grep impalad on the host that's running impalad).   Another thing to check if SSL is enabled on in Impala on your cluster, you'll need to use --ssl option when connecting via impala-shell. Regards, Alex ... View more

Would be helpful to know which version of CDH or CDP you are using.  ... View more

This error indicates that impalad daemon was not able to secure a processing thread on the node. Could be because the node is struggling under heavy load.    What services are running in parallel with Impala on this host? What is the hardware configuration? What is the CPU utilization on the host? ... View more

Hi @subrkann    Short answer is this: Spark (including Streaming) on IBM PowerPC Yes. Part of CDP Base cluster.  Sqoop on IBM PowerPC.  Yes. Part of CDP Base cluster. Impala on IBM PowerPC. Not supported. NiFi on IBM PowerPC (will get back to you on this)   Also CDP 7.1.6 runtime also includes Power Systems support. All future releases will too. The 7.1.4 release is when the support was first added to the product.     Hope that helps, Alex ... View more

Were you able to have Hive clean up the obsolete files? Just checking in. ... View more