About yagoaparecidoti

yagoaparecidoti · ‎07-29-2025

hi @Malrashed, we do not use swap on Cloudera cluster hosts. we disable 100% or keep the value 1 in the vm.swappiness parameter. reference: https://docs.cloudera.com/cdp-reference-architectures/latest/cdp-pvc-base-ra/topics/ra-cdpdc-swapiness.html best regards 🙂

yagoaparecidoti · ‎07-28-2025

hi @RamaClouder, current scenario: You're running CDP in the cloud, using the CDP Public Cloud, right? if so, you have technical support included with your license. For more accurate and responsive support, we recommend opening a case in the "My Cloudera" portal as S1, and support will assist you as soon as possible. if not, please return with the stderr and stdout logs for more details. tip: Check permission settings in IAM, broker, etc.

yagoaparecidoti · ‎07-28-2025

hi @Malrashed , did you completely disable swap at the operating system level? comment out the swap line in the fstab file. run the swap off command. the free command returns swap 0 (zero). after disabling, did you restart the Cloudera agent?

yagoaparecidoti · ‎07-28-2025

hi community cloudera, recently, we've been receiving the following error when querying impala on hue: queryerror: tsocket read 0 bytes (code thrifttransport): ttransportexception('tsocket read 0 bytes',) - the "query_timeout_s" and "session_timeout_s" parameters have already been set to 2 hours in the hue settings. - the hs2 and impala thrift connection timeout has already been set to 2 hours in the hue settings. - the hs2 authentication timeout has already been set to kerberos in the hue settings. - the "proxytimeout" parameter has already been set to 10 minutes in the hue settings. and we're still receiving this error. has anyone experienced this issue and managed to resolve it? we're using cdh 6.3.4.

yagoaparecidoti · ‎07-07-2025

hi @vineetchaure, the Cloudera Manager itself manages the service startup scripts. we do not recommend modifying the Cloudera service startup scripts, as this will harm and interfere with correct startup and consequently generate unwanted problems.

yagoaparecidoti · ‎07-02-2025

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/

yagoaparecidoti · ‎07-02-2025

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.

yagoaparecidoti · ‎07-02-2025

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.

yagoaparecidoti · ‎07-02-2025

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.

yagoaparecidoti · ‎06-17-2025

hi @Rajat_jangra , using the "audit" option in ranger, I was able to get the information I wanted.

Online	Offline
Last Visited	‎11-09-2025 09:27 PM

Member Since	‎02-28-2022 11:49 AM
Last Visited	‎11-09-2025 09:27 PM
Posts	171
Kudos received	14

Cloudera Community

Re: How to add Delay during Rolling Restart Until ...

Re: check date and time of access to some kudu tab...

Re: We need developer access to archive.cloudera.c...

Re: how to create a flow in nifi that reads a hive...

Re: how create, export and import full nifi templa...

Re: swap warning

Re: Datalake creation failed

Re: swap warning

hue - impala query on hue, returns error - TSocket...

Re: How to add Delay during Rolling Restart Until ...

Re: Connect Trino to Cloudera Hive with Kerberos A...

Re: Running queries on Hive

Re: Cleaning data HDFS

Re: check date and time of access to some kudu tab...

Re: check date and time of access to some kudu tab...