Skills
.Work. You
Rest

hologres-uv-compute

Official

Real-time UV/PV deduplication with RoaringBitmap

Data & Analytics#uv#real-time#deduplication#pv#dynamic-tables#roaringbitmap#uid-encoding
Authoraliyun
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Compute real-time UV/PV with deduplicated user IDs for scalable analytics.

Core Features & Use Cases

  • Real-time UV/PV computation using Dynamic Tables and RoaringBitmap for incremental deduplication across date ranges.
  • Cross-day UV aggregation via RB_OR_AGG for exact counts, flexible time-range analysis, and text UID encoding with hg_id_encoding_int4.
  • Use cases include event-level analytics, retention studies, and cross-region campaigns with low latency.

Quick Start

Create your source and dynamic tables, enable RoaringBitmap, and run a sample UV/PV query across a date range.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: hologres-uv-compute
Download link: https://github.com/aliyun/hologres-ai-plugins/archive/main.zip#hologres-uv-compute

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.