[ 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)