Not exactly sequence but an ability to generate unique numbers (with limitation) is under development: https://issues.apache.org/jira/browse/HIVE-20536
On Sep 15, 2018, at 11:10 AM, Shawn Weeks <[email protected]<mailto:[email protected]>> wrote: It doesn't help if you need concurrent threads writing to a table but we are just using the row_number analytic and a max value subquery to generate sequences on our star schema warehouse. It has worked pretty well so far. To provide true sequence support would require changes on the hive meta database side as well as locking so nothing has been done on it in a long time. A simple UDF isn't capable of providing true unique sequence support. Thanks Shawn -----Original Message----- From: Jörn Franke <[email protected]<mailto:[email protected]>> Sent: Saturday, September 15, 2018 6:09 AM To: [email protected]<mailto:[email protected]> Subject: Re: [feature request] auto-increment field in Hive If you really need it then you can write an UDF for it. On 15. Sep 2018, at 11:54, Nicolas Paris <[email protected]<mailto:[email protected]>> wrote: Hi Hive does not provide auto-increment columns (=sequences). Is there any chance that feature will be provided in the future ? This is one of the highest limitation in hive data warehousing in replacement of RDBMS right now. Thanks, -- nicolas
