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

Reply via email to