About DianaTorres

RobVi · ‎02-08-2023

Hi @Shmoo , Thank you for the suggestion. This works! The MV can be rebuilt after manually deleting the stale locks. However, the next interesting question would be why do we get the stale lock? If we know why, we could prevent this from happening again, as an access to hive metastore is not something that we want to make available to all users.

arshad10244 · ‎01-29-2023

I had a similar issue, it happens because of nifi not being able to resolve the schema. You need to first create a schema and set the type of billing address as string and add it to avroschemaregistry and lastly configure your jsontreereader to use that schema

DianaTorres · ‎01-26-2023

@yamu 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!

DianaTorres · ‎01-23-2023

Here are some highlights from the month of December DianaTorres_0-1674517984528.png 162 new support questions 1 new community article 493 new members DianaTorres_1-1674517984490.png DianaTorres_2-1674517984650.png DianaTorres_3-1674517984459.png Rank Community Article Author Components/ Labels #1 How to Integrate CDE with COD and Reading & Writing to Phoenix Tables using Data Engineering Service by leveraging PySpark on CDP Platform Syed Saleem Hameed @shameed Apache HBase Apache Phoenix Apache Spark Cloudera Data Engineering (CDE) Cloudera Data Platform (CDP) Cloudera Operational DB DianaTorres_4-1674517984419.png We would like to recognize the below community members and employees for their efforts over the last month to provide community solutions. See all our top participants at Top Solution Authors leaderboard and all the other leaderboards on our Leaderboards and Badges page. DianaTorres_5-1674517984813.png @smdas @MattWho @Kartik_Agarwal @rki_ @myzard @sanjaysubs @hegdemahendra @jorge_florencio DianaTorres_6-1674517984477.png Share your expertise and answer some of the below open questions. Also, be sure to bookmark the unanswered question page to find additional open questions. Unanswered Community Post Components/ Labels Using an already existing dashboard with different Union Cloudera Analytics DB Cloudera Hue Nifi is unable to connect Hive table Apache Nifi Create cache miss scenario in HBase with HDP 2.6.5 Apache Hadoop Apache HBase HDFS Spark continously running with exit code 1 Apache Spark How can we read a flowfile content with a python script ? Apache Nifi

DianaTorres · ‎01-13-2023

@prakodi 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

Elias · ‎01-12-2023

There can be several reasons that can cause this. Run host inspector to get a better understanding of the issue: CM -> Hosts -> All Hosts -> Inspect Hosts

DianaTorres · ‎01-10-2023

@DNADatangineer 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

DianaTorres · ‎01-10-2023

@Sadique1 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

DianaTorres · ‎01-10-2023

@hanumanth 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 @AsimShaikh has requested? Thanks

Kartik_Agarwal · ‎12-21-2022

@kvbigdata What happens if you set Cloudera Manager > Hive > Configuration > Service Monitor Client Config Overrides > Add Name: hive.metastore.client.socket.timeout Value: 600 We have provided the below information regarding the current situation of the canary jira . https://my.cloudera.com/knowledge/quotError--The-Hive-Metastore-canary-failed-to-create-a?id=337839 You have only one workaround ,that is to disable the canary test as you already did currently and that will not harm anything on your cluster . Currently the workaround is to disable the Canary tests on the HMS. # Access HIve Service # Configuration Tab >> Look for Hive Metastore Canary Health Test # Uncheck the box # Restart the service.

Online	Offline
Last Visited	‎08-24-2026 04:08 PM

Member Since	‎11-17-2021 08:08 AM
Last Visited	‎08-24-2026 04:08 PM
Posts	1,168
Kudos received	242

Cloudera Community

Re: How to change the company in the profile

Re: Keycloak SSO Hive REST Catalog

Re: Error connecting to NiFi Registry from NiFi UI...

Re: How to change my Account Email Address?

Re: Cannot erase old /opt/cloudera/parcels

Re: Rebuilding Materialized View does not work, sa...

Re: Convert Json array into csv using Nifi produce...

Re: How to find In which server the Kafka cluster ...

January 2023 Community Highlights

Re: How to export DDL's of all table's for a schem...

Re: URGENT - Constant "Network Interface Speed Unk...

Re: Anyone knows how to disable the replication of...

Re: Decommission disk from HDFS (Ambari Cluster)

Re: particular nodemanagers nodes memory reaches >...

Re: Bad : The Hive Metastore canary failed to crea...