[
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