[
https://issues.apache.org/jira/browse/HIVE-29482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-29482:
-------------------------------
Description: The query parameters in PostgreSQL has a hard limit,
[https://www.postgresql.org/docs/current/limits.html]. If the sql HMS sends
exceeds this limit, it will cause the direct sql fail, the connection pool will
close the underlying connection, as it's cannot process the new request any
more, which makes failover to jdo fail as well.
> Direct SQL fails when number of query parameters exceeds PostgreSQL limit
> -------------------------------------------------------------------------
>
> Key: HIVE-29482
> URL: https://issues.apache.org/jira/browse/HIVE-29482
> Project: Hive
> Issue Type: Bug
> Reporter: Zhihua Deng
> Priority: Major
>
> The query parameters in PostgreSQL has a hard limit,
> [https://www.postgresql.org/docs/current/limits.html]. If the sql HMS sends
> exceeds this limit, it will cause the direct sql fail, the connection pool
> will close the underlying connection, as it's cannot process the new request
> any more, which makes failover to jdo fail as well.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
