Github-Mirror/seaweedfs
1
0
Fork 0
mirror of https://github.com/seaweedfs/seaweedfs.git synced 2026-09-08 15:41:15 +02:00
Code Issues Packages Projects Releases Wiki Activity
Page: DuckDB Lance Integration
Pages
A typical step‐by‐step example AWS CLI with SeaweedFS AWS IAM CLI Actual Users Admin UI OIDC Admin UI Amazon IAM API Amazon S3 API Applications Async Backup Async Filer Metadata Backup Async Replication to Cloud Async Replication to another Filer Azure Blob Storage Authentication Benchmark SeaweedFS as a GlusterFS replacement Benchmarks from jinleileiking Benchmarks Blob Store Architecture Cache Remote Storage Choosing a Filer Store Client Libraries Cloud Drive Architecture Cloud Drive Benefits Cloud Drive Quick Setup Cloud Monitoring Cloud Tier Cluster Plan Day 2 Operations Cluster Plan Inventory Reference Cluster Plan Workflow Components Configure Remote Storage Cryptography and FIPS Compliance Customize Filer Store Data Backup Data Structure for Large Files Deployment to Kubernetes and Minikube Deployment with seaweed up Directories and Files Distributed POSIX Locks Distributing AI Model Files for Multi GPU Loading Docker Compose for S3 Docker Image Registry with SeaweedFS Doris Iceberg Integration Dremio Iceberg Integration DuckDB Iceberg Integration DuckDB Lance Integration EC Bitrot Detection Environment Variables Erasure Coding for warm storage Error reporting to sentry FAQ FIO benchmark FUSE Mount Failover Master Server File Operations Quick Reference Filer Active Active cross cluster continuous synchronization Filer Cassandra Setup Filer Change Data Capture Filer Commands and Operations Filer Data Encryption Filer JWT Use Filer Metadata Events Filer Notification Webhook Filer Operation Serialization Filer Redis Setup Filer Server API Filer Setup Filer Store Replication Filer Stores Filer as a Key Large Value Store Gateway to Remote Object Storage Getting Started HDFS via S3 connector Hadoop Benchmark Hadoop Compatible File System Hardware Helm Chart Recipes Hobbyest Tinkerer scale on premises tutorial Home Iceberg REST Catalog API Iceberg Table Maintenance Independent Benchmarks Kafka to Kafka Gateway to SMQ to SQL Kubernetes Backups and Recovery with K8up Kubernetes ServiceAccount Authentication Lakekeeper Iceberg Integration Lance Maintenance Worker LanceDB Integration Large File Handling Load Command Line Options from a file Master Server API Migrate Maintenance Scripts to Admin Script Plugin Migrate to Filer Store Mount Remote Storage Mount on Windows Mount over the Internet OIDC Integration Optimization for Many Small Buckets Optimization P2P reading in weed mount POSIX Compliance Path Specific Configuration Path Specific Filer Store Plugin Worker Scheduling PostgreSQL compatible Server weed db Production Setup Pub Sub to SMQ to SQL Quick Start with weed mini Replication RisingWave Iceberg Integration Run Blob Storage on Public Internet Run Trino on SeaweedFS Rust Volume Server S3 API Audit log S3 API Benchmark S3 API FAQ S3 Bucket Policies S3 Bucket Quota S3 CORS S3 Conditional Operations S3 Configuration S3 Credentials S3 Lifecycle Architecture S3 Lifecycle Monitoring S3 Lifecycle Operator Guide S3 Lifecycle Recipes S3 Lifecycle Troubleshooting S3 Lifecycle vs Volume TTL S3 Lifecycle S3 Nginx Proxy S3 Object Lock and Retention S3 Object Versioning S3 Policy Conditions S3 Policy Variables S3 Rate Limiting S3 RenameObject S3 Table Bucket Commands S3 Table Bucket S3 Tables Security SFTP Server SQL Queries on Message Queue SQL Quick Reference SRV Service Discovery Seaweed Message Queue SeaweedFS Architecture SeaweedFS Iceberg Catalog SeaweedFS Java Client SeaweedFS Lance Catalog SeaweedFS in Docker Swarm Security Configuration Security Overview Server Side Encryption SSE C Server Side Encryption SSE KMS Server Side Encryption Server Startup via Systemd Simplest S3 Bucket and User Setup Spark Iceberg Integration Spark Lance Integration Store file with a Time To Live Structured Data Lake with SMQ and SQL Super Large Directories Supported APIs vs Minio System Metrics TUS Resumable Uploads TensorFlow with SeaweedFS Tiered Storage Trino Iceberg Integration UrBackup with SeaweedFS Use Cases Volume Files Structure Volume Management Volume Server API WebDAV Words from SeaweedFS Users Worker fstab and systemd mount nodejs with Seaweed S3 rclone with SeaweedFS restic with SeaweedFS run HBase on SeaweedFS run Spark on SeaweedFS s3cmd with SeaweedFS seaweed up Command Reference weed shell
Clone
1
DuckDB Lance Integration
Chris Lu edited this page 2026-08-21 13:04:56 -07:00
Table of Contents

DuckDB Lance Integration

DuckDB's lance core extension reads Lance tables out of a SeaweedFS table bucket over S3, without the catalog. That works because a table bucket's layout is a valid Lance dataset directory — see SeaweedFS Lance Catalog.

Verified against DuckDB 1.5.5 by the integration suite in test/s3tables/catalog_duckdb_lance/.

Setup

INSTALL lance;
LOAD lance;

CREATE SECRET seaweedfs (
    TYPE lance,
    ACCESS_KEY_ID '…',
    SECRET_ACCESS_KEY '…',
    REGION 'us-east-1',
    ENDPOINT 'http://localhost:8333',
    ALLOW_HTTP true,
    VIRTUAL_HOSTED_STYLE_REQUEST false
);

Those are object_store's key names, the same ones the namespace vends in storage_options.

Reading a table

A table created through the catalog lives at s3://<bucket>/<namespace>/<table>:

SELECT count(*) FROM __lance_scan('s3://vectors/ml/embeddings');

SELECT id, title
FROM __lance_scan('s3://vectors/ml/embeddings')
WHERE id < 5;

SELECT id
FROM lance_vector_search('s3://vectors/ml/embeddings', 'vector',
                         [1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0], k := 3);

Why __lance_scan and not FROM 's3://…'

DuckDB's replacement scan — the ergonomic SELECT * FROM 's3://…' form — recognises a Lance dataset by a .lance path suffix. Tables created through this catalog do not have one, deliberately: the catalog entry is the dataset directory, a table name may not contain a dot, and a suffix would leak into ARNs and bucket policies.

-- a dataset written to a .lance path: recognised
SELECT count(*) FROM 's3://vectors/ml/exported.lance';

-- a table created through the catalog: not recognised
SELECT count(*) FROM 's3://vectors/ml/embeddings';   -- Catalog Error
SELECT count(*) FROM __lance_scan('s3://vectors/ml/embeddings');  -- works

Known limitation

ATTACH 's3://bucket/namespace' AS ns (TYPE lance) — the directory-namespace form in the extension's own documentation — fails in DuckDB 1.5.5 with Cannot launch in-memory database in read-only mode, whatever options are passed. Use the scan functions above.

See also

Introduction

API

Configuration

Filer

Filer Stores

Management

Advanced Filer Configurations

FUSE Mount

WebDAV

SFTP Server

Cloud Drive

AWS S3 API

S3 Table Bucket

Iceberg Integrations

Lance Integrations

S3 Authentication & IAM

Server-Side Encryption

S3 Client Tools

Machine Learning

HDFS

Replication and Backup

Metadata Change Events

Messaging

Use Cases

Operations

Rust Volume Server

Advanced

Security

Misc Use Case Examples