[HIVE-20226] HMS getNextNotification will throw exception when request maxEvents exceed table's max_rows

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Metastore
• Assignee: Alice Fan
• Reporter: Alice Fan
• Created: 23/Jul/18 21:58
• Updated: 17/Nov/22 08:54
• Resolved: 30/Jul/18 17:36

Description

When Sentry call getNextNotification(), its request max_events will always be Integer.MAX_VALUE.
query.setRange(0, maxEvents) of ObjectStore will throw exception when maxEvents exceed table's max_rows.
Ex: assumed max_rows = 50,000,000 in a mysql table
java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000.

Issue Links

• Dependency: HIVE-19251 ObjectStore.getNextNotification with LIMIT should use less memory