@frank_albers @PNW supervisor has a listener process which keeps monitoring the CDH processes. For any service with auto restart configured if faces an unexpected exit , supervisord will restart the process. Agent looks for unexpected exits in the notifications it receives via the supervisor listener and forwards relevant event info to the associated role's monitor to update its unexpected exit state. A normal agent restart does not affect supervisord process, it continues to be running and managing CDH processes. A hard stop/restart on agent will affect supervisord and in turn kill all managed CDH processes.   Hope this helps, Paras Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.     ... View more

@Srinivs Kindly check if the username and passwords are correct for DB and there should not be any extra space.    grant the privileges as shown below. postgres=# GRANT CONNECT ON DATABASE rman TO rman; GRANT postgres=# GRANT ALL ON DATABASE rman TO rman; GRANT postgres=# GRANT ALL PRIVILEGES ON DATABASE "rman" to rman; GRANT   If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped. ... View more

Hi,   Where you are redirecting the output to? for csv file? What is the output from impala-shell terminal if you do not redirect the output?   It looks like caused by the csv module when impala is using it to export the data.       # csv.writer expects a file handle to the input.     # cStringIO is used as the temporary buffer.     temp_buffer = StringIO()     writer = csv.writer(temp_buffer, delimiter=self.field_delim,                         lineterminator='\n', quoting=csv.QUOTE_MINIMAL)     writer.writerows(rows)   Seems to be we cannot change this since it is needs to modified at code level.   https://github.com/apache/impala/blob/014c455aaaa38010ae706228f7b439c080c0bc7d/shell/shell_output.py...   Regards, Chethan YM   ... View more

Hi,   -> Can you try with -Doraoop.timestamp.string=false property? -> Can you try with sqoop type mapping parameters as per below doc and see? https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_java_sql_timestamp:~:text=on%20all%20databases.-,7.2.8.%C2%A0Controlling%20type%20mapping,-Sqoop%20is%20preconfigured   Regards, Chethan YM   ... View more

Hi, > Add the below configuration in HDFS from CM UI: CM -> hdfs -> Configuration    hadoop.proxyuser.hive.hosts = * hadoop.proxyuser.hive.groups = *    > If the above is already set, please disable the DB notification API auth.  In Hive and Hive_On_Tez Service: In Hive Service Advanced Configuration hive-site safety value:    Name: hive.metastore.event.db.notification.api.auth Value: false   Restart stale configs and check if it works.   Regards, Chethan YM   ... View more

Hi,   It looks like known- OPSAPS-60161 unresolved issue. Can you disable the canary health check? https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ht_hive_metastore_server.html#concept_6qo_fpn_yk   Regards, Chethan YM ... View more

> No metrics/graph to check " inc_stats_size"   That's what I thought. > If 1GB is insufficient, Try to use "compute stats" instead of "compute incremental stats"   However, there is a problem in that case.   This table is updated every hour adding a new partition. But, the "compute stats" take well over an hour to complete. ... View more

External shell sqoop import works fine. But with oozie, org.apache.hadoop.mapreduce.Job - Running job: job_1666660764861_0120 It stops at this part. If it's ok, you should see the progress of the sqoop import next. However, even after a day has passed, it keeps showing org.apache.hadoop.mapreduce.Job - Running job: job_1666660764861_0120. There are no errors. ... View more

Hi,   The alert message does not give more information to check, review the HMS and CM service monitor logs related to this issue and provide the stack-traces.   Regards, Chethan YM     ... View more