Member since
12-18-2018
109
Posts
5
Kudos Received
8
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
272 | 07-26-2022 06:01 PM | |
447 | 06-21-2022 06:38 PM | |
1229 | 10-28-2021 06:29 PM | |
344 | 10-25-2021 11:55 PM | |
1124 | 10-25-2021 07:31 PM |
11-03-2022
11:13 PM
@chengxi Can you share the stack trace before the SHUTDOWN_MSG in hive.
... View more
10-30-2022
11:58 PM
@Anjaliwbmd can you please share the cluster version ? Does the issue user have admin privilege ?
... View more
10-07-2022
06:02 PM
@Anjaliwbmd You mean the issue user unable to see "Workflows, Schedules" tabs hue ?
... View more
07-26-2022
06:01 PM
@newbieone Was the above query working fine in hs2(beeline) ? If yes then you can use the oozie-hive action to run the query. Refer: https://community.cloudera.com/t5/Community-Articles/Oozie-Hive-2-Action-in-a-Kerberized-cluster/ta-p/248913
... View more
07-26-2022
05:55 PM
@learner1 Can you please set the below property value in yarn and try to rerun the query. mapreduce.framework.name=yarn
... View more
07-01-2022
06:51 PM
@Asim- Please refer below doc to schedule oozie job. https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/configuring-oozie/topics/oozie-scheduling-examples.html Let me now if you have any concerns.
... View more
07-01-2022
11:22 AM
@Meshal Thanks for your response. please check how the table was created in both clusters? Run show create table and compare the output. Solution: you can get a patch for this IMPALA-7087 in CDH 6.3.3
... View more
06-27-2022
06:06 PM
@Meshal You are hitting the below bug. https://issues.apache.org/jira/browse/IMPALA-7087 Let me know if you have any concerns.
... View more
06-22-2022
08:13 PM
@drgenious In hue -> issue workflow -> click gear icon -> retry interval Let me know if you have any concerns.
... View more
06-21-2022
06:38 PM
Hello @drgenious Please use the below line to retry the workflow. <action name="a" retry-max="2" retry-interval="1"> Refer : https://oozie.apache.org/docs/3.3.0/WorkflowFunctionalSpec.html#a18_User-Retry_for_Workflow_Actions_since_Oozie_3.1 Let me know if it helps.
... View more
12-05-2021
06:30 PM
@MoatazNader Can you set false for below property and try to rerun the query. CM>Impala> Configuration>Catalog Server Hive Advanced Configuration Snippet (Safety Valve) set hive.metastore.disallow.incompatible.col.type.changes to false and restarted the Impala service.
... View more
11-08-2021
08:25 AM
@drgenious From where you connect with impala-shell that will act as impala coordinator other impala damonens are executors. If you configured a dedicated coordinator that daemon won't execute any fragments. For more information about dedicated coordinator please refer to the below doc. https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/impala_dedicated_coordinator.html
... View more
11-03-2021
03:41 AM
@drgenious You can create a function like below. CREATE FUNCTION [IF NOT EXISTS] [db_name.]function_name LOCATION 'hdfs_path_to_jar' SYMBOL='class_name' For more information please refer below doc. https://docs.cloudera.com/documentation/enterprise/latest/topics/impala_create_function.html#create_function
... View more
10-28-2021
06:29 PM
@dv_conan Can you please check the cm and cdp/cdh compatibility. use the below link to check. If not compatible please upgrade your CM and check. https://supportmatrix.cloudera.com/
... View more
10-27-2021
03:29 AM
@MikeB You can find/add the property in Ambari--> YARN--> Configs--> Advanced--> Customer yarn-site --> Add/find Property
... View more
10-25-2021
11:55 PM
@railincdba Seems ambari database not updated. Can you restart ambari-server and ambari-agent from the decommission nodemanager host and check. If issues still persist you can revert the changes (Recommission NodeManagers) then decommission it and check.
... View more
10-25-2021
07:31 PM
1 Kudo
Hello @MikeB As for automatic clean up not getting triggered, well it may be due to (or at-least related to) this unresolved bug reported on Yarn. https://issues.apache.org/jira/browse/YARN-4540 You can reduce the below property value to lower the local file cache size. yarn.nodemanager.localizer.cache.target-size-mb
... View more
10-11-2021
01:26 AM
@cloudera_de575 For the failed query STATUS=ERROR the exception will not show in Queries tab from das webui. you can use the queryId to check the exception in hs2 log.
... View more
10-11-2021
12:57 AM
@Sam7 Was the query working fine before in das ?
... View more
10-10-2021
11:42 PM
@Geenspruitjes Was the below query working in hs2 beeline ? 'select cola, null as colb, "x" as colc from mytable' Can you share the show create table output. show create table <tablename>;
... View more
10-07-2021
10:43 PM
@MikeB To resolve this issue, configure Hive Metastore to use SerdeStorageSchemaReader implementation: Go to Ambari > Hive > Config > Custom hive-site . Set the following property to configure Hive Metastore: metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader
... View more
09-21-2021
06:40 PM
@drgenious You can find the impala memory consumption in the "impala_memory_total_used" chart. In Cm -> impala -> charts library -> impala_memory_total_used
... View more
09-14-2021
10:34 PM
1 Kudo
@Sayed016 Can you set the property below and try to rerun the query. set hive.fetch.task.conversion=none;
... View more
08-23-2021
06:36 PM
@Amn_468 Please refer the below Knowledge base article for heap memory calculation. https://my.cloudera.com/knowledge/Impaladembeddedjvmheapsize-has-a-default-value-of-32-GB-after?id=278279
... View more
08-01-2021
06:24 PM
@Gcima009 Please follow below steps to install oozie sharelib. Stop Oozie Service. Go to --> Cloudera Manager --> Oozie --> Actions --> Click on Install Oozie Sharelib Restart Oozie.
... View more
07-21-2021
07:09 PM
@MattSchmitz Please check the permission for the Log directory. you can find the log location in LogPath.
... View more
04-13-2021
11:41 PM
Hello @ryu Please refer below doc for query failed with this error Result fetch timed out in hive view. https://community.cloudera.com/t5/Community-Articles/How-to-fix-ambari-Hive-View-1-5-2-0-Result-fetch-timed-out/ta-p/244965
... View more
04-06-2021
09:01 PM
Hello @ryu Please refer below doc for enable ranger Authorization for hive LLAP. https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.0.1/securing-hive/content/hive_secure_llap_in_hiveserver.html
... View more
01-22-2021
12:23 AM
@mike_bronson7Please refer below KB article for this issue https://my.cloudera.com/knowledge/StandBy-NameNode-fails-to-start-Error-shows--?id=271605
... View more
11-23-2020
08:37 PM
@JoSam Please refer below doc to clean old queries. https://docs.cloudera.com/HDPDocuments/DAS/DAS-1.4.4/operations/content/das_postgres_db_cleanup.html Can I delete this table? select pg_size_pretty(pg_total_relation_size('query_details')); -- run this query to check the table size. truncate table das.query_details CASCADE; -- run this command to truncate the table data.
... View more