[ 
https://issues.apache.org/jira/browse/HIVE-22469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Mollitor updated HIVE-22469:
----------------------------------
    Description: 
Hive Metastore uses the 'HikariCP' database connection pool. The default number 
of connections to the database is 10. For the Qtests, connecting to a local 
DerbyDB, there need not be more than 4 connections. Anymore simply adds undo 
overhead and by looking at the QTest logs, I see a bunch of 'connection 
refused' from HikariCP. It may be the case that the standalone DB does not 
support that many concurrent connections anyway.

[https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-MetaStore]

  was:
Hive Metastore uses the 'HikariCP' database connection pool. The default number 
of connections to the database is 10. For the Qtests, connecting to a local 
DerbyDB, there need not be more than 2 connections. Anymore simply adds undo 
overhead and by looking at the QTest logs, I see a bunch of 'connection 
refused' from HikariCP. It may be the case that the standalone DB does not 
support that many concurrent connections anyway.

[https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-MetaStore]


> Lower Metastore DB Connection Pool Size in QTests
> -------------------------------------------------
>
>                 Key: HIVE-22469
>                 URL: https://issues.apache.org/jira/browse/HIVE-22469
>             Project: Hive
>          Issue Type: Improvement
>          Components: Test, Tests
>    Affects Versions: 3.2.0
>            Reporter: David Mollitor
>            Assignee: David Mollitor
>            Priority: Minor
>         Attachments: HIVE-22469.1.patch, HIVE-22469.2.patch, 
> HIVE-22469.3.patch
>
>
> Hive Metastore uses the 'HikariCP' database connection pool. The default 
> number of connections to the database is 10. For the Qtests, connecting to a 
> local DerbyDB, there need not be more than 4 connections. Anymore simply adds 
> undo overhead and by looking at the QTest logs, I see a bunch of 'connection 
> refused' from HikariCP. It may be the case that the standalone DB does not 
> support that many concurrent connections anyway.
> [https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-MetaStore]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to