BELUGA BEHR created HIVE-18300:
----------------------------------
Summary: Use LAST_INSERT_ID for Sequence Tables for MySQL
Key: HIVE-18300
URL: https://issues.apache.org/jira/browse/HIVE-18300
Project: Hive
Issue Type: Improvement
Components: HiveServer2
Affects Versions: 3.0.0
Reporter: BELUGA BEHR
Priority: Trivial
Instead of using SELECT FOR UPDATE, for MYSQL, use the recommended approach
which only requires once client interaction instead of two:
{code:sql}
UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1);
SELECT LAST_INSERT_ID();
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
