[
https://issues.apache.org/jira/browse/LENS-329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14336053#comment-14336053
]
Jaideep Dhok commented on LENS-329:
-----------------------------------
Simple way to solve this is to use a different DB user for estimate queries.
This has few advantages
# No code changes are required in lens-driver-jdbc, since a pool is created for
each user anyway.
# From the DB side DBAs can tune connection and session limits for the estimate
queries. This can also make sure that estimate queries don't contend with data
queries on the DB.
> Use separate db connection pool for estimate queries in jdbc driver
> -------------------------------------------------------------------
>
> Key: LENS-329
> URL: https://issues.apache.org/jira/browse/LENS-329
> Project: Apache Lens
> Issue Type: Sub-task
> Components: driver-hive
> Reporter: Amareshwari Sriramadasu
> Fix For: 2.1
>
>
> If estimate is being called aggressively, do we want use same pool across
> both execute and estimate in Lens? Shall we separate them for isolation?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
