[ 
https://issues.apache.org/jira/browse/HIVE-25868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17476957#comment-17476957
 ] 

Sankar Hariappan commented on HIVE-25868:
-----------------------------------------

[~maheshk114]
New config "hive.direct.sql.max.parameters" is introduced in below patch to 
handle this sql db limitation. Pls check if it is related to your issue.
https://issues.apache.org/jira/browse/HIVE-25659

> AcidHouseKeeperService fails to purgeCompactionHistory if the entries in 
> COMPLETED_COMPACTIONS tables 
> ------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-25868
>                 URL: https://issues.apache.org/jira/browse/HIVE-25868
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive, Metastore, Standalone Metastore
>            Reporter: mahesh kumar behera
>            Assignee: mahesh kumar behera
>            Priority: Major
>
> To purge the entries, prepared statement is created. If the number of entries 
> in the prepared statement goes beyond the limit of backend db (for postgres 
> it around 32k), then the operation fails.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to