Skip to content

Add support for partition with bucket/truncate in ice insert #96

@subkanthi

Description

@subkanthi
ice insert ns.my_table \
  --partition '[{"column":"user_id", "transform":"bucket[16]"}, {"column":"name", "transform":"truncate[5]"}]' \
  data.parquet
D select RatecodeID,count(*) from 'yellow_tripdata_2025-01.parquet' group by RatecodeID;
┌────────────┬──────────────┐
│ RatecodeID │ count_star() │
│   int64    │    int64     │
├────────────┼──────────────┤
│       NULL │       540149 │
│          2 │        94420 │
│          4 │         7092 │
│          5 │        26501 │
│          1 │      2756472 │
│         99 │        41963 │
│          3 │         8622 │
│          6 │            7 │
└────────────┴──────────────┘

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions