@avengers This is Resident memory used you can check the doc here: https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/cm_metrics_monitor.html ... View more

@avengers Yes, only SSL port will work for SSL connection that's expected. So first rectify the ports and then see if the error comes again.  Then testing the SSL connection using below or some similar command will help you to determine the issue.  openssl s_client -verify 100 -showcerts -CAfile /etc/tls-certs/certificate.pem -connect <Impalahost>:25000   ... View more

@avengers  The parameter disables the cert check it's independent of self signed or CA signed.  ssl_cert_ca_verify=False   ... View more

Thank for the answer. ... View more

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.        ... View more

Thanks you. Yes, It is not problem of UDF. I have 2 HiveServer2 server host. I have been register udf only 1 server host. Maybe. It is reason. ... View more

  Thank you for testing. Have you ever submitted a workflow? Workflow still dosen't work.   Look at this.   first) saved HQL document.It contained test parameter '76710'. http://demo.gethue.com/hue/editor?editor=292133 hql docuement   second) click the "submit" button.  I setted '92801' value of parameter. and passed it.   param   But HQL results' zipcode is '76710'.  The results' will be empty, If I save the HQL document no parameter value. I have tested many case.  I think that problem is HQL because It haven't variable. please look at this capture. This capture is oozie log. hql Oozie runed hql query no have variable "$zip".   It is very necessary function for me. Please help me to find the soluction.   ... View more

Thanks. I'll try it the way you told me. ... View more

My CDH cluster version is cdh6.0.1. services is kafka, hdfs, hive, impala, hue.   I tested it in the following order. 1. set idele timeout value    cloudera manager > impala > snippet(safe value)    -idle_query_timeout=30    -idle_session_timeout=120 2. check timeout value.    cloudera manager > impala > instance > impala daemon web ui > http://[impalad host]:25000/varz    idle_session_timeout value setted 120 3. monitoring server's tcp connections    ssh connect to impalad host    $ watch -n 1 -d 'netstat -anpt | grep 21050' 4. java client application jdbc    Connection connection = DriverManager.getconnection("jdbc:impala://....");    Statement statement = connection.createStament();    System.exit(0); 5. impalad server. establishe tcp connection    The connection will not be terminated after multi minutes. 6. check impala daemon web ui    can see tcp connection in web ui.    impala daemon web ui > http://[impalad host]:25000/sessions do action 'close' However, the tcp connection is still established. ... View more