Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
avatar
Super Guru

ISSUE: Hive view is not working.

ERROR:

H100 Unable to submit statement show databases like '*': org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

ROOT CAUSE: Issue was with mysql pool connection size limit exceeded.Check using -

mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 100  |
+-----------------+-------+
1 row in set (0.00 sec)

RESOLUTION: Modified mysql pool size limit from 100 to 500 and restarted mysql which resolved the issue.

mysql> SET GLOBAL max_connections = 500;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 500  |
+-----------------+-------+
1 row in set (0.00 sec)

299 Views
Version history
Last update:
‎11-16-2016 11:33 AM
Updated by:
Contributors