[HIVE-15181] buildQueryWithINClause didn't properly handle multiples of ConfVars.METASTORE_DIRECT_SQL_MAX_ELEMENTS_IN_CLAUSE

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.2.1, 2.1.0
• Fix Version/s: 1.3.0, 2.1.1, 2.2.0
• Component/s: Hive, Transactions
• Target Version/s: 1.3.0, 2.2.0
• Assignee: Wei Zheng
• Reporter: Wei Zheng
• Created: 10/Nov/16 23:05
• Updated: 08/Dec/16 14:10
• Resolved: 23/Nov/16 06:58

Description

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;

Issue Links

• is related to: HIVE-15267 Make query length calculation logic more accurate in TxnUtils.needNewQuery()