[ https://issues.apache.org/jira/browse/HIVE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13762671#comment-13762671 ]
shanyu zhao commented on HIVE-5218: ----------------------------------- [~sergey.soldatov] I tried your patch but it doesn't fix the problem. The problem is not with user defined table, it's actually with the SEQUENCE_TABLE table which datanucleus uses internally to track the sequence number. I did a little bit research and found that it's a datanucleus bug, with my fix in datanucleus this problem went away. I submitted a JIRA there: http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-692 However, for hive should we revert the datanucleus upgrade until the patch in NUCRDBMS-692 get checked in (3.2.7 the soonest)? > datanucleus does not work with SQLServer in Hive metastore > ---------------------------------------------------------- > > Key: HIVE-5218 > URL: https://issues.apache.org/jira/browse/HIVE-5218 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.12.0 > Reporter: shanyu zhao > Attachments: > 0001-HIVE-5218-datanucleus-does-not-work-with-SQLServer-i.patch > > > HIVE-3632 upgraded datanucleus version to 3.2.x, however, this version of > datanucleus doesn't work with SQLServer as the metastore. The problem is that > datanucleus tries to use fully qualified object name to find a table in the > database but couldn't find it. > If I downgrade the version to HIVE-2084, SQLServer works fine. > It could be a bug in datanucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira