Member since
11-11-2019
610
Posts
33
Kudos Received
25
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1498 | 02-28-2023 09:32 PM | |
2429 | 02-27-2023 03:33 AM | |
25055 | 12-24-2022 05:56 AM | |
2007 | 12-05-2022 06:17 AM | |
5219 | 11-25-2022 07:37 AM |
12-21-2022
09:41 PM
@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.
... View more
12-05-2022
07:01 AM
1 Kudo
Thanks a lot it is working fine 🤗
... View more
12-04-2022
11:04 PM
@Mars001 I see you are using EXTERNAL jdbc driver. COuld you please try with beeline and provide below if this fails: 1. query and queryID 2. hiveserver2 logs 3. Output of show create table <tablename>;
... View more
11-25-2022
09:34 PM
GM Asish... Thanks for sharing difference between two parameter. Will take note on tez.task.resource.memory.mb should be set < hive.tez.container.size Appreciate for your support. Regards, Pankaj shivankar
... View more
11-23-2022
01:00 AM
@drgenious 1. Impala is always faster. Impala does not use yarn. Impala stores catalog data locally which fetches information faster. Impala backend gthread is built on C++ which is very fast. 2. Impala is not fault tolerant , it is best suited for adhoc queries and ETL is best suited for Hive as Hive is fault tolerant. If the query fails due to network/disk failure,hive will retry but Impala would fail. 3. For stemaming/ingestion like Kafka flow you need to put it in EXTERNAL tables not in Managed(ACID) tables. Managed tabled can be used,if you want to perform alteration of the data like Update/Delete . Please let me know,if you have any queries. Please click "Accept As Solution" , if your query is answered.
... View more
11-22-2022
01:46 AM
Hi @Raed_Faly Could you please share the DDL's for the tables, based on that I can update.
... View more
11-20-2022
08:55 PM
@hanumanth, Have the replies helped resolve your issue? If so, can you please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future?
... View more
11-20-2022
08:49 PM
1 Kudo
@chengxi, Have you resolved your issue? If you have, can you please provide the appropriate solution here, so that it can help other users in the future? If you are still experiencing the issue, can you provide the information our experts have requested?
... View more
11-19-2022
12:15 AM
@NikoBelic Thanks for the update. The hive metadata indeed is stored on database. You need to take the dump to backup the metadata. Please let me know,if you have nay queries. Please "Accept as Solution" ,if your queries are answered.
... View more