[ https://issues.apache.org/jira/browse/HIVE-15181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685143#comment-15685143 ]
Eugene Koifman commented on HIVE-15181: --------------------------------------- Made Critical since this effectively pegs the CPU in the Metastore when it's hit. > buildQueryWithINClause didn't properly handle multiples of > ConfVars.METASTORE_DIRECT_SQL_MAX_ELEMENTS_IN_CLAUSE > --------------------------------------------------------------------------------------------------------------- > > Key: HIVE-15181 > URL: https://issues.apache.org/jira/browse/HIVE-15181 > Project: Hive > Issue Type: Bug > Components: Hive, Transactions > Affects Versions: 1.2.1, 2.1.0 > Reporter: Wei Zheng > Assignee: Wei Zheng > Priority: Critical > Attachments: HIVE-15181.1.patch, HIVE-15181.2.patch > > > As there is a bug, we can still work around the issue by using the settings > below (making sure the second setting is always at least 1000 times of the > first setting): > set hive.direct.sql.max.query.length=1; > set hive.direct.sql.max.elements.in.clause=1000; -- This message was sent by Atlassian JIRA (v6.3.4#6332)