Connection failed on host:10000 hiveserver2

[#1]

Hello.

i got emaill this message almost onec a week or two week and i could not use hive query until reboot hivesever2. so my hive batch doesn't work.

i have 2 namenode, 12 datanode

i use mysql and i have three database like hive metastore, and others in same mysql

i use orc, acid table, snappy two, also use analyics query two.

why somtime occure this error? can anybody help my issue please.

Connection failed on host ip:port (Traceback (most recent call last):

File "/var/lib ....

...

..

ExecutionTimeoutException : Execution of 'ambari-sudo.sh su ambari-qa -l -s /bin/bash -c 'export ....

...

.. ... was killed due timeout after 60 secods.