Hi,   What is the authentication mechanism given in driver? Can you change the Authentication in driver to Kerberos and provide the user kerberos credentials user and give a try?   Regards, Chethan YM ... View more

Hi,   -> Can you check user has sudo/root permissions on these hosts? -> Can you do agent hard restart on these hosts and try? -> recheck private key is valid and correct one.   Regards, Chethan YM ... View more

Hi,   Can you create a separate user in the database for each service and retry? You should NOT use the root user for all databases.   Refer below doc: https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ig_extrnl_pstgrs.html#cmig_topic_5_6_2   Regards, Chethan YM ... 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

Hi,   > As per the document it is service down time, So i think it is complete impala service down time. (However I haven't seen the issue on live) > No metrics/graph to check " inc_stats_size" > If 1GB is insufficient, Try to use "compute stats" instead of  "compute incremental stats"   Regards, Chethan YM ... View more