Implementing Data Cubes in Hive Using WITH CUBE, GROUPING SETS, and WITH ROLLUP

This article demonstrates how to build multi‑dimensional data cubes on JD's big‑data platform using Hive, comparing UNION ALL with the more concise WITH CUBE, GROUPING SETS, and WITH ROLLUP functions, and discusses practical pitfalls and optimization tips.

Big DataGrouping SetsRollup

0 likes · 10 min read

Implementing Data Cubes in Hive Using WITH CUBE, GROUPING SETS, and WITH ROLLUP

Youzan Coder

Jul 1, 2020 · Big Data

Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets

This article explains how HiveCube can replace traditional development for multi‑dimensional aggregation in a data‑warehouse, covering background, theory of cube, with‑cube/rollup/grouping‑sets syntax, grouping_id handling, practical implementation tips, performance tuning, and a comparison with conventional methods.

Big DataCubeGrouping Sets

0 likes · 19 min read

Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets

ITPUB

Jan 8, 2016 · Databases

Unlock PostgreSQL 9.5: Faster Sorting, Grouping Sets, Upserts & JSONB Tips

PostgreSQL 9.5 brings dramatic performance gains, new OLAP capabilities like GROUPING SETS, CUBE, ROLLUP, convenient pg_rewind for HA, flexible upsert handling, and enhanced JSONB output, all illustrated with practical examples and import techniques.

9.5Grouping SetsJSONB

0 likes · 4 min read

Unlock PostgreSQL 9.5: Faster Sorting, Grouping Sets, Upserts & JSONB Tips