You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Vaibhav Gumashta (JIRA)" <ji...@apache.org> on 2016/09/02 18:56:20 UTC

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

Vaibhav Gumashta created HIVE-14698:
---------------------------------------

             Summary: 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


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.4#6332)