Go Integration¶
The Go binding uses the Arrow C Data Interface. Writes copy Arrow buffers into C-owned memory because writers may retain them after the call returns.
Prerequisites¶
- Go 1.22.4 or later
- CGO enabled with a C toolchain
- Supported platforms: Linux (amd64, arm64), macOS (amd64, arm64)
0.4.0 prebuilt Linux amd64 binaries
Require glibc 2.38 or later, OpenSSL 3 (libssl.so.3, libcrypto.so.3),
and libffi.so.8. Older environments may fail to load the module.
Installation¶
The native library is embedded and loaded automatically. Build with
CGO_ENABLED=1.
Reading BlobDescriptor Values¶
BlobReader reads serialized BlobDescriptor values without scanning a table.
ReadBlobs resolves a batch in one call; ReadBlob handles one descriptor.
package main
import (
"database/sql"
"log"
"os"
paimon "github.com/apache/paimon-rust/bindings/go"
_ "github.com/go-sql-driver/mysql"
)
func main() {
db, err := sql.Open("mysql", os.Getenv("STARROCKS_DSN"))
if err != nil {
log.Fatal(err)
}
defer db.Close()
rows, err := db.Query("SELECT blob_descriptor FROM catalog.db.my_table")
if err != nil {
log.Fatal(err)
}
defer rows.Close()
var descriptors [][]byte
for rows.Next() {
var descriptor []byte
if err := rows.Scan(&descriptor); err != nil {
log.Fatal(err)
}
descriptors = append(descriptors, append([]byte(nil), descriptor...))
}
if err := rows.Err(); err != nil {
log.Fatal(err)
}
reader, err := paimon.NewBlobReader(map[string]string{
"fs.oss.accessKeyId": os.Getenv("OSS_ACCESS_KEY_ID"),
"fs.oss.accessKeySecret": os.Getenv("OSS_ACCESS_KEY_SECRET"),
"fs.oss.endpoint": os.Getenv("OSS_ENDPOINT"),
})
if err != nil {
log.Fatal(err)
}
defer reader.Close()
blobs, err := reader.ReadBlobs(descriptors)
if err != nil {
log.Fatal(err)
}
for _, blob := range blobs {
log.Printf("read %d bytes", len(blob))
}
}
The descriptor contains only URI, offset, and length. Pass OSS/S3 credentials
with the same FileIO option names used by catalogs. If StarRocks returns a hex
or base64 string, decode it to the original descriptor bytes before calling
ReadBlobs.
Stream a large value without holding it all in memory:
stream, err := reader.OpenBlob(descriptor)
if err != nil {
log.Fatal(err)
}
defer stream.Close()
if _, err := io.Copy(destination, stream); err != nil {
log.Fatal(err)
}
For an HTTP byte range, seek relative to the descriptor and copy only that range:
size, err := stream.Seek(0, io.SeekEnd)
if err != nil || start < 0 || end < start || end >= size {
log.Fatal("invalid range")
}
if _, err := stream.Seek(start, io.SeekStart); err != nil {
log.Fatal(err)
}
if _, err := io.CopyN(w, stream, end-start+1); err != nil {
log.Fatal(err)
}
OpenBlob is lazy and returns an io.ReadSeekCloser. ReadBlobs groups and
merges ranges; separate streams are not merged.
For DLF temporary data tokens, reuse a table's refreshing FileIO:
catalog, err := paimon.NewCatalog(map[string]string{
"metastore": "rest",
"uri": os.Getenv("DLF_ENDPOINT"),
"warehouse": os.Getenv("DLF_CATALOG"),
"token.provider": "dlf",
"dlf.region": os.Getenv("DLF_REGION"),
"dlf.oss-endpoint": os.Getenv("DLF_OSS_ENDPOINT"),
"dlf.token-loader": "ecs",
"dlf.token-ecs-role-name": os.Getenv("DLF_ECS_ROLE"),
"data-token.enabled": "true",
})
if err != nil {
log.Fatal(err)
}
defer catalog.Close()
table, err := catalog.GetTable(paimon.NewIdentifier("db", "descriptor_table"))
if err != nil {
log.Fatal(err)
}
defer table.Close()
reader, err := table.NewBlobReader()
if err != nil {
log.Fatal(err)
}
defer reader.Close()
The reader and its streams keep the table FileIO and refresh DLF data tokens
before expiry. Set dlf.oss-endpoint when the server-provided endpoint is not
reachable from the application. Static options passed to
paimon.NewBlobReader are not refreshed.
Read a MAP<STRING, BLOB> column as descriptors, then stream one value:
Rows with null map keys cannot be represented as Arrow maps and return an error.
readBuilder, err := table.NewReadBuilderWithOptions(map[string]string{
"blob-as-descriptor": "true",
})
if err != nil {
log.Fatal(err)
}
defer readBuilder.Close()
if err := readBuilder.WithProjection([]string{"assets"}); err != nil {
log.Fatal(err)
}
scan, err := readBuilder.NewScan()
if err != nil {
log.Fatal(err)
}
defer scan.Close()
plan, err := scan.Plan()
if err != nil {
log.Fatal(err)
}
defer plan.Close()
read, err := readBuilder.NewRead()
if err != nil {
log.Fatal(err)
}
defer read.Close()
batches, err := read.NewRecordBatchReader(plan.Splits())
if err != nil {
log.Fatal(err)
}
defer batches.Close()
record, err := batches.NextRecord()
if err != nil {
log.Fatal(err)
}
descriptors, err := paimon.StringBlobMapDescriptors(record.Column(0), 0)
if err != nil {
log.Fatal(err)
}
record.Release() // the map owns its keys and descriptors
for key, descriptor := range descriptors {
if descriptor == nil { // null BLOB
continue
}
stream, err := reader.OpenBlob(descriptor)
if err != nil {
log.Fatal(err)
}
if _, err := io.Copy(destinationFor(key), stream); err != nil {
stream.Close()
log.Fatal(err)
}
stream.Close()
}
StringBlobMapDescriptors returns an ordinary Go map and remains valid after
releasing the Arrow record. To materialize small values in one merged batch:
batch := make([][]byte, 0, len(descriptors))
for _, descriptor := range descriptors {
if descriptor != nil {
batch = append(batch, descriptor)
}
}
values, err := reader.ReadBlobs(batch)
Use OpenBlob for large values.
Reads are grouped by URI and nearby ranges are merged. The fixed limits are a
64 KiB merge gap, 8 MiB merged span, 8 concurrent requests, and a 64 MiB
per-reader admission budget. One larger range runs alone but may exceed that
budget; use OpenBlob for large values. Results retain descriptor input order.
Creating a Catalog¶
Use NewCatalog with a map of options to create a catalog. The catalog type is determined by the metastore option (default: filesystem).
import paimon "github.com/apache/paimon-rust/bindings/go"
// Local filesystem
catalog, err := paimon.NewCatalog(map[string]string{
"warehouse": "/path/to/warehouse",
})
if err != nil {
log.Fatal(err)
}
defer catalog.Close()
Alibaba Cloud OSS¶
catalog, err := paimon.NewCatalog(map[string]string{
"warehouse": "oss://bucket/warehouse",
"fs.oss.accessKeyId": "your-access-key-id",
"fs.oss.accessKeySecret": "your-access-key-secret",
"fs.oss.endpoint": "oss-cn-hangzhou.aliyuncs.com",
})
REST Catalog¶
catalog, err := paimon.NewCatalog(map[string]string{
"metastore": "rest",
"uri": "http://localhost:8080",
"warehouse": "my_warehouse",
})
Managing Tags¶
Catalog tags pin table snapshots. Pass nil to tag the latest snapshot, then
read the tag to record the snapshot ID:
id := paimon.NewIdentifier("default", "my_table")
if err := catalog.CreateTag(id, "dataset-42", nil, false); err != nil {
log.Fatal(err)
}
tag, err := catalog.GetTag(id, "dataset-42")
if err != nil {
log.Fatal(err)
}
log.Printf("pinned snapshot %d", tag.Snapshot.ID)
Use table.LatestSnapshot() when the current snapshot must be inspected before
tagging; it returns nil for an empty table.
Read the pinned snapshot with the existing read options:
builder, err := table.NewReadBuilderWithOptions(map[string]string{
"scan.tag-name": "dataset-42",
})
To tag a specific snapshot, pass its ID:
The final argument to CreateTag ignores an existing tag.
Create a tag with retention using duration strings such as "1d", "12h", or
"30min". Retention is persisted on the tag file; this API does not expire tags
automatically. GetTag returns the retention as an ISO-8601 duration (for
example "1d" becomes "PT24H"):
snapshotID := int64(123)
timeRetained := "1d"
err := catalog.CreateTagWithRetention(id, "dataset-44", &snapshotID, &timeRetained, false)
if err != nil {
log.Fatal(err)
}
tag, err := catalog.GetTag(id, "dataset-44")
if err != nil {
log.Fatal(err)
}
log.Printf("retained for %s", *tag.TagTimeRetained)
Pass nil for timeRetained to create a tag without retention metadata, the
same as CreateTag.
Writing a Table¶
Use NewWriteBuilder for ordinary and fixed-bucket tables. The arrow.Record
schema must match the table schema.
builder, err := table.NewWriteBuilder()
if err != nil {
log.Fatal(err)
}
defer builder.Close()
writer, err := builder.NewWrite()
if err != nil {
log.Fatal(err)
}
defer writer.Close()
if err := writer.WriteArrowBatch(record); err != nil {
log.Fatal(err)
}
messages, err := writer.PrepareCommit()
if err != nil {
log.Fatal(err)
}
defer messages.Close()
commit, err := builder.NewCommit()
if err != nil {
log.Fatal(err)
}
defer commit.Close()
if err := commit.Commit(messages); err != nil {
log.Fatal(err)
}
Call WriteArrowBatch multiple times before PrepareCommit. WithOverwrite
replaces the partitions touched by the batch. Commit is for one-shot batch
jobs: it consumes the maximum commit identifier, so later filtered retries by
the same commit user are treated as already committed. Reuse a writer across
rounds with CommitWithIdentifier and increasing identifiers. Multiple writers in one process
must share a commit user and merge their messages. Commit messages are
process-local and cannot be sent to another process. For primary-key
fixed-bucket tables, assign each (partition, bucket) to one writer before
writing; merging messages does not establish ownership.
Postpone Fixed-Bucket Writes¶
For a bucket = -2 table, the ordinary builder writes postpone files. To write
real buckets directly, use the dedicated builder with a plan mapping each
partition to its bucket count:
// Plan schema: partition keys in order, then a non-null Int32 total_buckets.
schema := arrow.NewSchema([]arrow.Field{
{Name: "dt", Type: arrow.BinaryTypes.String, Nullable: true},
{Name: "total_buckets", Type: arrow.PrimitiveTypes.Int32, Nullable: false},
}, nil)
rb := array.NewRecordBuilder(memory.DefaultAllocator, schema)
defer rb.Release()
rb.Field(0).(*array.StringBuilder).AppendValues([]string{"2026-08-14", "2026-08-15"}, nil)
rb.Field(1).(*array.Int32Builder).AppendValues([]int32{1, 1}, nil)
plan := rb.NewRecord()
defer plan.Release()
builder, err := table.NewPostponeFixedBucketWriteBuilderWithCommitUser("job-1")
if err != nil {
log.Fatal(err)
}
defer builder.Close()
if err := builder.WithBucketPlan(plan); err != nil {
log.Fatal(err)
}
writer, err := builder.NewWrite() // requires WithBucketPlan to be called first
if err != nil {
log.Fatal(err)
}
defer writer.Close()
if err := writer.WriteArrowBatch(record); err != nil {
log.Fatal(err)
}
messages, err := writer.PrepareCommit()
if err != nil {
log.Fatal(err)
}
defer messages.Close()
commit, err := builder.NewCommit()
if err != nil {
log.Fatal(err)
}
defer commit.Close()
if err := commit.Commit(messages); err != nil {
log.Fatal(err)
}
An unpartitioned plan holds only total_buckets. Multiple writers in one process must share the plan
and commit user and assign each (partition, bucket) to one writer. Commit
messages are process-local. A fixed-bucket writer is single-use; create a new
writer after PrepareCommit.
Reading a Table¶
Paimon Go uses a scan-then-read pattern: first scan the table to produce splits, then read data from those splits as Arrow RecordBatches.
import (
"errors"
"fmt"
"io"
"github.com/apache/arrow-go/v18/arrow/array"
paimon "github.com/apache/paimon-rust/bindings/go"
)
// Get a table from the catalog
table, err := catalog.GetTable(paimon.NewIdentifier("default", "my_table"))
if err != nil {
log.Fatal(err)
}
defer table.Close()
// Create a read builder
rb, err := table.NewReadBuilder()
if err != nil {
log.Fatal(err)
}
defer rb.Close()
// Step 1: Scan — produces a Plan containing DataSplits
scan, err := rb.NewScan()
if err != nil {
log.Fatal(err)
}
defer scan.Close()
plan, err := scan.Plan()
if err != nil {
log.Fatal(err)
}
defer plan.Close()
splits := plan.Splits()
// Step 2: Read — consumes splits and returns Arrow RecordBatches
read, err := rb.NewRead()
if err != nil {
log.Fatal(err)
}
defer read.Close()
reader, err := read.NewRecordBatchReader(splits)
if err != nil {
log.Fatal(err)
}
defer reader.Close()
for {
record, err := reader.NextRecord()
if errors.Is(err, io.EOF) {
break
}
if err != nil {
log.Fatal(err)
}
fmt.Println(record)
record.Release()
}
Column Projection¶
Use WithProjection to select specific columns. Only the requested columns are read, reducing I/O.
rb, err := table.NewReadBuilder()
if err != nil {
log.Fatal(err)
}
defer rb.Close()
// Only read the "id" and "name" columns
if err := rb.WithProjection([]string{"id", "name"}); err != nil {
log.Fatal(err)
}
// Continue with scan-then-read as above...
Case-Insensitive Column Names¶
Projected names must match the schema exactly by default. Pass false to
WithCaseSensitive to match by ASCII case folding instead — useful for tables
whose columns were declared in upper case by Hive or Spark. A name that folds onto
two schema columns differing only in case is rejected as ambiguous.
if err := rb.WithCaseSensitive(false); err != nil {
log.Fatal(err)
}
if err := rb.WithProjection([]string{"ID", "NAME"}); err != nil {
log.Fatal(err)
}
Call order does not matter: names that differ from the schema only in case are
resolved in NewRead, which is also where such a name surfaces as an error. A
name that matches no column under any casing is still rejected by
WithProjection itself.
The returned records always carry the schema's own spelling, not the spelling you asked for, so downstream column lookups stay stable.
This setting covers projection only. A predicate resolves its column when it is built, so its case sensitivity comes from which builder created it — see Case-Insensitive Predicates.
Filter Push-Down¶
Filter push-down prunes data at two levels:
- Scan planning — skips partitions, buckets, and data files based on file-level statistics (min/max).
- Read-side — applies row-level filtering via Parquet native row filters for leaf predicates, then enforces the full predicate with an exact residual filter.
Stats pruning and native push-down are conservative optimizations: inconclusive
files and unsupported push-down shapes are kept for later filtering. Ordinary
Paimon reads still return only matching rows because append, data-evolution, and
primary-key merge paths apply an exact residual filter over the full predicate,
including compound And / Or / Not trees.
Building Predicates¶
Create predicates through the PredicateBuilder obtained from a table:
pb := table.PredicateBuilder()
// Comparison predicates
pred, err := pb.Eq("id", 1) // id = 1
pred, err := pb.NotEq("name", "bob") // name != "bob"
pred, err := pb.Lt("id", 3) // id < 3
pred, err := pb.Le("id", 2) // id <= 2
pred, err := pb.Gt("id", 1) // id > 1
pred, err := pb.Ge("id", 2) // id >= 2
// Null checks
pred, err := pb.IsNull("name") // name IS NULL
pred, err := pb.IsNotNull("name") // name IS NOT NULL
// IN / NOT IN
pred, err := pb.In("id", 1, 2, 3) // id IN (1, 2, 3)
pred, err := pb.NotIn("name", "x", "y") // name NOT IN ("x", "y")
Applying Filters¶
Pass a predicate to WithFilter on the ReadBuilder:
rb, err := table.NewReadBuilder()
if err != nil {
log.Fatal(err)
}
defer rb.Close()
pb := table.PredicateBuilder()
pred, err := pb.Eq("id", 1)
if err != nil {
log.Fatal(err)
}
// Ownership of pred is transferred — do NOT close it after this call
if err := rb.WithFilter(pred); err != nil {
log.Fatal(err)
}
// Continue with scan-then-read...
Case-Insensitive Predicates¶
Table.PredicateBuilder matches column names exactly. Its
WithCaseSensitive(false) returns a builder that folds ASCII case instead; every
predicate that builder produces resolves its column that way.
pb := table.PredicateBuilder().WithCaseSensitive(false)
// Resolves to the schema's "id" column.
pred, err := pb.Eq("ID", int32(1))
The choice is fixed when the predicate is built, which is why it lives on the
builder that produces predicates rather than on the read builder — the same
WithCaseSensitive switch, on the object that owns the resolution.
ReadBuilder.WithCaseSensitive does not affect predicates, and a predicate from a
case-folding builder keeps that behaviour whatever the read builder is set to.
The predicate stores the schema's own spelling of the column, not the one you passed, so file-level pruning and row-level filtering apply to it exactly as they would to an exactly-spelled predicate.
Compound Predicates¶
Combine predicates with And, Or, and Not. The predicate sub-package provides variadic helpers:
import (
paimon "github.com/apache/paimon-rust/bindings/go"
"github.com/apache/paimon-rust/bindings/go/predicate"
)
pb := table.PredicateBuilder()
p1, _ := pb.Ge("id", 1)
p2, _ := pb.Le("id", 3)
p3, _ := pb.Eq("name", "alice")
// id >= 1 AND id <= 3
combined, err := predicate.And(p1, p2)
// (id >= 1 AND id <= 3) OR name = "alice"
combined, err = predicate.Or(combined, p3)
// NOT (...)
negated, err := predicate.Not(combined)
Predicate Ownership
Predicates follow a move ownership model. After passing a predicate to WithFilter, And, Or, or Not, the predicate is consumed and must NOT be closed or reused by the caller.
Supported Datum Types¶
Predicate values are automatically converted from Go types:
| Go Type | Paimon Type |
|---|---|
bool |
Bool |
int8 |
TinyInt |
int16 |
SmallInt |
int32 |
Int |
int / int64 |
Int or Long |
float32 |
Float |
float64 |
Double |
string |
String |
paimon.Date |
Date (epoch days) |
paimon.Time |
Time (millis) |
paimon.Timestamp |
Timestamp |
paimon.LocalZonedTimestamp |
LocalZonedTimestamp |
paimon.Decimal |
Decimal |
paimon.Bytes |
Binary |
For special types, use the dedicated constructors:
// Date as epoch days since 1970-01-01
pred, _ := pb.Eq("dt", paimon.Date(19000))
// Decimal(123.45) as DECIMAL(10,2)
pred, _ := pb.Eq("amount", paimon.NewDecimal(12345, 10, 2))
// Timestamp
pred, _ := pb.Eq("ts", paimon.Timestamp{Millis: 1700000000000, Nanos: 0})
Shared Memory Reservations¶
Create a ResourceContext to share one reservation budget across read and write
builders. Attach it before creating a reader or writer. The builder keeps its own
reference, so the original handle may be closed after attachment.
resources, err := paimon.NewResourceContext(256 * 1024 * 1024)
if err != nil { log.Fatal(err) }
defer resources.Close()
if err := readBuilder.WithResources(resources); err != nil { log.Fatal(err) }
if err := writeBuilder.WithResources(resources); err != nil { log.Fatal(err) }
metrics, err := resources.Metrics()
if err != nil { log.Fatal(err) }
fmt.Println(metrics.ReservedMemoryBytes, metrics.PeakReservedMemoryBytes)
PostponeFixedBucketWriteBuilder.WithResources accepts the same context. When a
reservation exceeds the limit, the operation returns CodeResourceExhausted.
These counters track estimated reservations held by Paimon, not total process
memory. Current reservations fall as readers and writers release them; the peak
remains available while the context handle is open.
Resource Management¶
Paimon objects with a Close method hold native resources and must be closed.
Use defer immediately after creation:
catalog, err := paimon.NewCatalog(opts)
if err != nil { log.Fatal(err) }
defer catalog.Close()
table, err := catalog.GetTable(id)
if err != nil { log.Fatal(err) }
defer table.Close()
// ... and so on for ReadBuilder, TableScan, Plan, TableRead, RecordBatchReader
All Close() methods are safe to call multiple times.
Complete Example¶
package main
import (
"errors"
"fmt"
"io"
"log"
"github.com/apache/arrow-go/v18/arrow/array"
paimon "github.com/apache/paimon-rust/bindings/go"
)
func main() {
// 1. Open catalog and table
catalog, err := paimon.NewCatalog(map[string]string{
"warehouse": "/tmp/paimon-warehouse",
})
if err != nil {
log.Fatal(err)
}
defer catalog.Close()
table, err := catalog.GetTable(paimon.NewIdentifier("default", "my_table"))
if err != nil {
log.Fatal(err)
}
defer table.Close()
// 2. Configure read: projection + filter
rb, err := table.NewReadBuilder()
if err != nil {
log.Fatal(err)
}
defer rb.Close()
if err := rb.WithProjection([]string{"id", "name"}); err != nil {
log.Fatal(err)
}
pb := table.PredicateBuilder()
pred, err := pb.Gt("id", 0)
if err != nil {
log.Fatal(err)
}
if err := rb.WithFilter(pred); err != nil {
log.Fatal(err)
}
// 3. Scan
scan, err := rb.NewScan()
if err != nil {
log.Fatal(err)
}
defer scan.Close()
plan, err := scan.Plan()
if err != nil {
log.Fatal(err)
}
defer plan.Close()
// 4. Read
read, err := rb.NewRead()
if err != nil {
log.Fatal(err)
}
defer read.Close()
reader, err := read.NewRecordBatchReader(plan.Splits())
if err != nil {
log.Fatal(err)
}
defer reader.Close()
for {
record, err := reader.NextRecord()
if errors.Is(err, io.EOF) {
break
}
if err != nil {
log.Fatal(err)
}
idCol := record.Column(0).(*array.Int32)
nameCol := record.Column(1).(*array.String)
for i := 0; i < int(record.NumRows()); i++ {
fmt.Printf("id=%d name=%s\n", idCol.Value(i), nameCol.Value(i))
}
record.Release()
}
}