[ https://issues.apache.org/jira/browse/HIVE-15181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685192#comment-15685192 ]
Eugene Koifman commented on HIVE-15181: --------------------------------------- in TxnUtils.needNewQuery() "sizeInBytes / 1024 > queryMemoryLimit" doesn't do the right thing. If the user sets METASTORE_DIRECT_SQL_MAX_QUERY_LENGTH to 1K, they most likely want each SQL string to be at most 1K. But if sizeInBytes=2047, this still returns false. > 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)