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 <jornfra...@gmail.com> Sent: Saturday, September 15, 2018 6:09 AM To: user@hive.apache.org 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 <nicolas.pa...@riseup.net> 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