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.

Hive Width Bucket Function

Highlighted

Hive Width Bucket Function

Rising Star

Does Hive have a comparable width bucket function similar to HAWQ or Oracle? This link provides a good description of a width_bucket (basically a segment or histogram) https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions214.htm

I know hive has buckets but these are typically used with partitions for performance, a width_bucket is often used as an database function.

1 REPLY 1

Re: Hive Width Bucket Function

Guru

It is not supported in hive. There is NTILE which is supported nothing like WIDTH_BUCKET.

You can look at current list of analytical and windowing functions here.

Don't have an account?
Coming from Hortonworks? Activate your account here