[HIVE-14698] Metastore: Datanucleus MSSQLServerAdapter generates incorrect syntax for OFFSET-FETCH clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.1.0
• Component/s: Metastore
• Assignee: Vaibhav Gumashta
• Reporter: Vaibhav Gumashta
• Created: 02/Sep/16 18:56
• Updated: 06/Mar/17 22:36
• Resolved: 03/Mar/17 20:19

Description

See the bug description here: https://github.com/datanucleus/datanucleus-rdbms/issues/110.

In ObjectStore#listStorageDescriptorsWithCD, we set a range on the query. For MSSQLServer version >= 12, this results in an OFFSET-FETCH clause in the MSSQLServerAdapter (provided by datanucleus).

I'll attach a short term workaround for Hive here and once DN has the fix, we can upgrade and remove the short term fix from Hive.

Issue Links

• is superceded by: HIVE-16106 Upgrade to Datanucleus 4.2.12