He did not say that it is for an acid table... Then how the state (ie the sequence) is managed within the UDF is another story , but there are various options
> On 15. Sep 2018, at 20:10, Shawn Weeks <[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]> > Sent: Saturday, September 15, 2018 6:09 AM > To: [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]> 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
