Hi, Is Impala session hang means not able to run any queries? Is this issue observed via hue or impala-shell? repro the issue via impala-shell and check the coordinator logs to get any suspected error messages.  At the time of issue check the cluster load how may queries running concurrently, Issue may arise if any expensive/complex operations are running. Do not frequently run "invalidate metadata" query in the cluster it is one of the expensive operations and it pressurises the catalog service.   Regards, Chethan YM     ... View more

Hi,   We may need to check the complete error stacktraces from Hue runcpserver log - /var/log/hue are you able to provide the error stacktarces ? Have you checked any LDAP group is missing in Hue or not syncrosnised?   Regards, Chethan YM ... View more

Hi @sukui    Can you add following --llvm_cpu_attr_whitelist  to Impala Daemon Command Line Argument Advanced Configuration Snippet (Safety Valve). --llvm_cpu_attr_whitelist=adx,aes,avx,avx2,bmi,bmi2,cmov,cx16,f16c,fma,fsgsbase,hle,invpcid,lzcnt,mmx,movbe,pclmul,popcnt,prfchw,rdrnd,rdseed,rtm,smap,sse,sse2,sse3,sse4.1,ssse3,xsave,xsaveopt   Restart impala and see if it helps.   Regards, Chethan YM ... View more

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