dataset-manager

Generate and optimize TPC-H Parquet datasets with cudf or pyarrow.

1.0k|109|Updated Jun 19, 2024
One-click install
npx skills add https://github.com/sirius-db/sirius --skill dataset-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dataset-manager
Source: https://github.com/sirius-db/sirius/tree/main/.claude/skills/dataset-manager
Command: npx skills add https://github.com/sirius-db/sirius --skill dataset-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the management of TPC-H datasets in Parquet format, enabling efficient generation, optimization, and inspection for database benchmarking.

Core Features & Use Cases

  • Data Generation: Create TPC-H datasets at any scale factor using an optimized Rust-based generator.
  • Parquet Optimization: Consolidate and rewrite Parquet files for improved performance, automatically leveraging GPU (cudf) or falling back to CPU (pyarrow).
  • Dataset Inspection: Analyze the structure, row group sizes, and file sizes of your datasets.
  • Use Case: Optimize a large TPC-H SF100 dataset to reduce file sizes and improve query performance on Sirius, ensuring efficient benchmarking.

Quick Start

Generate TPC-H data for scale factor 100 in the default output directory.

Frequently Asked Questions about dataset-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate TPC-H Parquet datasets at a specific scale factor?

Generate TPC-H Parquet datasets at any scale factor using an optimized Rust-based generator to produce benchmark data in your specified output directory for database performance testing.

How does Parquet file optimization work for large TPC-H datasets?

Parquet file optimization consolidates and rewrites files by adjusting row group sizes and compression, automatically leveraging cudf on GPU or falling back to pyarrow on CPU to improve query performance.

Can I use GPU acceleration for rewriting Parquet files?

Yes, automatic backend selection uses cudf for GPU acceleration when rewriting Parquet files, falling back to pyarrow for CPU processing to ensure efficient file optimization.

What is the best way to inspect TPC-H Parquet row group sizes and file structures?

Inspect TPC-H Parquet datasets by analyzing their structure, row group sizes, and file sizes to understand the layout and ensure efficient benchmarking before running queries.

Do I need a GPU to optimize Parquet files for TPC-H benchmarking?

No, a GPU is not required; the optimizer automatically selects cudf for GPU acceleration if available, otherwise it uses pyarrow on CPU to rewrite and consolidate Parquet files.