Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who Me Too'd this solution

Re: Sequence number generation in impala

Master Collaborator

The Hive UDF won't help you. If you look at the Hive issue tracker, row_sequence() was added as a workaround because they didn't support the row_number() analytic function at that point in time.


We support the row_number() analytic function in Impala, so there's no reason to try to use that UDF.


If you want to start froma particular number, can't you just add it like I suggested in my previous answer?

Who Me Too'd this solution