About balajip

balajip · ‎12-05-2021

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

balajip · ‎11-08-2021

@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

balajip · ‎11-03-2021

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

balajip · ‎10-28-2021

@dv_conanCan 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/

balajip · ‎10-27-2021

@MikeB You can find/add the property in Ambari--> YARN--> Configs--> Advanced--> Customer yarn-site --> Add/find Property

balajip · ‎10-25-2021

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

balajip · ‎10-25-2021

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

balajip · ‎10-11-2021

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

balajip · ‎10-11-2021

@Sam7 Was the query working fine before in das ?

balajip · ‎10-10-2021

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

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: Impala catalog metadata

Re: Impala executors and coordinators

Re: Create function every time impala restart

Re: Yarn Queue Manager Not starting

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

Re: Decomissioning a NodeManager in HDP 2.6.1

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

Re: Query error status in DAS

Re: SQL statement to capitalize the first letter

Re: python hivejdbc returns null values after firs...