About balajip

balajip · ‎10-07-2021

@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

balajip · ‎09-21-2021

@drgenious You can find the impala memory consumption in the "impala_memory_total_used" chart. In Cm -> impala -> charts library -> impala_memory_total_used

balajip · ‎09-14-2021

@Sayed016 Can you set the property below and try to rerun the query. set hive.fetch.task.conversion=none;

balajip · ‎08-23-2021

@Amn_468 Please refer the below Knowledge base article for heap memory calculation. https://lighthouse.cloudera.com/s/article/Impaladembeddedjvmheapsize-has-a-default-value-of-32-GB-after-upgrading-to-CDH-516https://my.cloudera.com/knowledge/Impaladembeddedjvmheapsize-has-a-default-value-of-32-GB-after?id=278279

balajip · ‎08-01-2021

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

balajip · ‎07-21-2021

@MattSchmitz Please check the permission for the Log directory. you can find the log location in LogPath.

balajip · ‎04-13-2021

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

balajip · ‎04-06-2021

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

balajip · ‎01-22-2021

@mike_bronson7Please refer below KB article for this issue https://my.cloudera.com/knowledge/StandBy-NameNode-fails-to-start-Error-shows--?id=271605

balajip · ‎11-23-2020

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

Online	Offline
Last Visited	‎12-02-2022 06:25 AM

Member Since	‎12-18-2018 11:13 AM
Last Visited	‎12-02-2022 06:25 AM
Posts	109
Kudos received	5

Cloudera Community

Re: Ozzie Hive Script

Re: Retry in oozie through hue

Re: Yarn Queue Manager Not starting

Re: Decomissioning a NodeManager in HDP 2.6.1

Re: /hadoop/yarn/local/usercache/hive/filecache/ g...

Re: message:java.lang.UnsupportedOperationExceptio...

Re: Find the % of the used memory in impala

Re: Hive Error while calling watcher java.util.co...

Re: Impala Catalogue Server OOM

Re: Oozie does not create /user/oozie/shere/lib fo...

Re: Impala ODBC Logging Options: Automatically Rev...

Re: Why is that beeline hive query ran successfull...

Re: How to enable ranger authorization on hive LLA...

Re: What is the preferred solution for corrupted n...

Re: Data analytics studio Postgres database is la...