HIVE View error - H100 Unable to submit statement show databases like '*'

[#1]

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)