Altinity / Altinity/ice

Negative values for UInt32 even though Icerberg table created by ice converts to Int64

Open
#69 4 comments 0 reactions 1 assignee View on GitHub

@xieandrew is already working on this.

Since Feb 12, 2026.

p2
Dominant language
Java
Stars
35
Forks
7
Avg merge
5d 12h
Merged PRs (30d)
2

Description

Test case source: https://github.com/Altinity/antalya-hackathon/blob/29b90dbcfb14bece99e2fb179f86a40c367a6c24/run.py

vector :) SHOW TABLE mt_table

SHOW CREATE TABLE mt_table

Query id: 2f4ed043-f025-43d2-a146-4746f78a6472

   ┌─statement─────────────────────────┐
1. │ CREATE TABLE default.mt_table    ↴│
   │↳(                                ↴│
   │↳    `id` UInt32,                 ↴│
   │↳    `name` String                ↴│
   │↳)                                ↴│
   │↳ENGINE = MergeTree               ↴│
   │↳PARTITION BY id                  ↴│
   │↳ORDER BY name                    ↴│
   │↳SETTINGS index_granularity = 8192 │
   └───────────────────────────────────┘

1 row in set. Elapsed: 0.002 sec. 

vector :) SHOW TABLE s3_table

SHOW CREATE TABLE s3_table

Query id: 9c93b86d-e6e2-4150-b7f4-328a14e48e80

   ┌─statement──────────────────────────────────────────────────────────────────────────────────────────────────────┐
1. │ CREATE TABLE default.s3_table                                                                                 ↴│
   │↳(                                                                                                             ↴│
   │↳    `id` UInt32,                                                                                              ↴│
   │↳    `name` String                                                                                             ↴│
   │↳)                                                                                                             ↴│
   │↳ENGINE = S3(s3_conn, filename = 'namespace/iceberg_table/data', format = Parquet, partition_strategy = 'hive')↴│
   │↳PARTITION BY id                                                                                               ↴│
   │↳ORDER BY name                                                                                                  │
   └────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

1 row in set. Elapsed: 0.002 sec. 

vector :) SHOW TABLE iceberg_db.`namespace.iceberg_table`

SHOW CREATE TABLE iceberg_db.`namespace.iceberg_table`

Query id: 6c9b135b-733c-46c4-b0b9-e73b72b75a65

   ┌─statement─────────────────────────────────────────────────────────────────────────────────────┐
1. │ CREATE TABLE iceberg_db.`namespace.iceberg_table`                                            ↴│
   │↳(                                                                                            ↴│
   │↳    `id` Int64,                                                                              ↴│
   │↳    `name` String                                                                            ↴│
   │↳)                                                                                            ↴│
   │↳ENGINE = Iceberg('http://minio:9000/warehouse/namespace/iceberg_table/', 'minio', '[HIDDEN]') │
   └───────────────────────────────────────────────────────────────────────────────────────────────┘

1 row in set. Elapsed: 0.013 sec. 

vector :) SELECT * FROM mt_table

SELECT *
FROM mt_table

Query id: 331131a1-e708-4ce2-b7ab-3c6e97245624

   ┌─────────id─┬─name─┐
1. │ 4294967295 │ John │
2. │ 4294967294 │ Jane │
3. │ 4294967293 │ Jim  │
   └────────────┴──────┘

3 rows in set. Elapsed: 0.004 sec. 

vector :) SELECT * FROM s3_table

SELECT *
FROM s3_table

Query id: e5150b8a-2d07-47dd-a608-8c68e442531d

   ┌─────────id─┬─name─┐
1. │ 4294967293 │ Jim  │
2. │ 4294967295 │ John │
3. │ 4294967294 │ Jane │
   └────────────┴──────┘

3 rows in set. Elapsed: 0.012 sec. 

vector :) SELECT * FROM iceberg_db.`namespace.iceberg_table`

SELECT *
FROM iceberg_db.`namespace.iceberg_table`

Query id: 8117f22f-edee-4ee9-a3b4-2ba70f64fdc4

   ┌─id─┬─name─┐
1. │ -2 │ Jane │
2. │ -1 │ John │
3. │ -3 │ Jim  │
   └────┴──────┘

3 rows in set. Elapsed: 0.021 sec. 

vector :) 

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.