Support Questions
Find answers, ask questions, and share your expertise
Announcements
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 https://issues.apache.org/jira/browse/HIVE-1304, 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