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 wrote:
>
> It doesn't help if you need concurrent threads writing to a table but we are
> ju
Unsubscribe
Hi,
> 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.
Yup, you're right the row_number doesn't help with concurrent writes - it
doesn't even scale be
unsubscribe
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
mailto:swe...@weeksconsulting.us>> wrote:
It doesn't help if you need concurrent threads writing to
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 d
If you really need it then you can write an UDF for it.
> On 15. Sep 2018, at 11:54, Nicolas Paris 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
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
