You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "David Mollitor (Jira)" <ji...@apache.org> on 2020/12/01 18:54:00 UTC
[jira] [Commented] (HIVE-24463) Add special case for Derby and
MySQL in Get Next ID DbNotificationListener
[ https://issues.apache.org/jira/browse/HIVE-24463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17241792#comment-17241792 ]
David Mollitor commented on HIVE-24463:
---------------------------------------
Depends on HIVE-24460 since that Jira has added better support for Derby table locking.
> Add special case for Derby and MySQL in Get Next ID DbNotificationListener
> --------------------------------------------------------------------------
>
> Key: HIVE-24463
> URL: https://issues.apache.org/jira/browse/HIVE-24463
> Project: Hive
> Issue Type: Improvement
> Reporter: David Mollitor
> Assignee: David Mollitor
> Priority: Major
>
> * Derby does not support {{SELECT FOR UPDATE}} statements
> * MySQL can be optimized to use {{LAST_INSERT_ID()}}
>
> Debry tables are locked in other parts of the code already, but not in this path.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)