[ https://issues.apache.org/jira/browse/HIVE-14698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15894970#comment-15894970 ]
Vaibhav Gumashta commented on HIVE-14698: ----------------------------------------- [~sershe] Looks like DN has fixed the bug in their 4.1.x release line. I've created HIVE-16106 for upgrading the version in hive. Resolving this. > Metastore: Datanucleus MSSQLServerAdapter generates incorrect syntax for > OFFSET-FETCH clause > -------------------------------------------------------------------------------------------- > > Key: HIVE-14698 > URL: https://issues.apache.org/jira/browse/HIVE-14698 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 2.1.0 > Reporter: Vaibhav Gumashta > Assignee: Vaibhav Gumashta > Attachments: HIVE-14698.1.patch, HIVE-14698.2.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.15#6346)