Hi @ishashrestha , Yes, the user needs to have permission to write to that directory. You can test to execute with another user that already have that permissions. Let me know if works. Best Regards ... View more

@champa Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... View more

Hi @Jaguar ,   This issue seems to be related with Knox. Service Mismatch: The URL in the error (.../gateway/dt/knoxtoken/api/v1/token) suggests a conflict between the Hive Metastore and the Knox Token Service. This often happens after a cluster upgrade where a new token service is implemented, but the clients (in this case, the Metastore) are still configured for the old one. Solution: Check the Knox configuration in your cluster management tool (e.g., Cloudera Manager). Verify that the HiveServer2 and Hive Metastore services are using the correct Knox topology and that the token service settings are correctly configured to match the Knox server.   Let me know if this helps. ... View more

Adding a LoadBalancer to Hue. Solved the problem. Thanks ... View more

@Jackallboy Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information requested? Thanks. ... View more

@Hadoop16  Seems like a Java issue. Please check the following article https://community.cloudera.com/t5/Support-Questions/AccessControlException-Client-cannot-authenticate-via-TOKEN/td-p/347406 ... View more

To provide the exact HQL query, Please share the following : DDL for both the tables Sample records from each table  The expected output based on the sample data.  The above information will help to understand the problem statement better and validate the solution.  ... View more

@rosejo Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

Hi @LucasM , could you describe more of your use case? Your server in GCP have access to Cloudera CML? It's in the same network?   Best Regards ... View more

create connection between Dbeaver and Hive on a CDP 7.1.8  centos 7 cloudera 7.1.8 i am also facing same issue in cluster Kerberos is enabled ... View more