hi @huimin, where the connection to Trino is coming from, you must also configure Kerberos, so you need to have access to the Hive ports and the KDC ports for Kerberos authentication. before using Trino, try connecting to Hive with JDBC, using a simple Python script, where Trino is coming from, to validate the communication and authentication, if it works, you can configure Trino. this document [1] will help you configure Trino with Hive [1] = https://janakiev.com/blog/presto-cluster/ ... View more

hi @Jackallboy , according to your report, the client is not able to connect to the HMS, which is generating the error. to validate your test and creation of the external table, do the following: 1. access a host in the cluster, authenticate, and run "beeline". This way, you will connect to Hive automatically. 2. then run your ddl to create the external table and check the behavior. if it is created successfully, the problem you reported is in the client that is trying to create the external table. so, where are you trying to create the external table? Using an external tool, external connection, etc. ... View more

hi @rizalt , from your report, you probably have snapshots enabled for this directory, so any delete in this directory will not be 100% effective unless the snapshot is also deleted. deleting the snapshot will make it impossible to recover data if necessary. so, on the namenode webui page, in the "snapshot" tab, check your snapshots. ... View more

hi @Rajat_jangra  in CDH you will have to filter the Hive and Impala logs to know when the tables were accessed. i recommend that you leave the logs open and then access a table using Impala and monitor it live in the logs, so you will know which filter to use. ... View more

hi @adamvalenta, thanks 😉 since your question has been answered, you could click about the solution that helped you, so the thread will close and help the community.  ... View more

hi @vkarthikeyan  how to run the same test but with livy installed in the private cdp, with kerberos and tls enabled? ... View more

hi @Craig-C, analyze the logs of the CDE pods, monitor the logs during the execution of the job and after the job ends, you will possibly find the problem.   ... View more

hi @yusufu , are you using the same version of Java that runs on Ubuntu on RHEL? ... View more