Search Shortcut cmd + k | ctrl + k
- Documentation
- Specification
- Introduction
- Data Types
- Queries
- Tables
- Overview
- column
- column_mapping
- name_mapping
- column_tag
- data_file
- delete_file
- file_column_stats
- file_variant_stats
- file_partition_value
- files_scheduled_for_deletion
- inlined_data_tables
- metadata
- partition_column
- partition_info
- schema
- schema_versions
- snapshot
- snapshot_changes
- table
- table_column_stats
- table_stats
- tag
- view
- macro
- macro_impl
- macro_parameters
- sort_info
- sort_expression
- DuckDB Extension
- Introduction
- Usage
- Connecting
- Choosing a Catalog Database
- Choosing Storage
- Snapshots
- Schema Evolution
- Time Travel
- Upserting
- Configuration
- Paths
- Maintenance
- Recommended Maintenance
- Merge Files
- Expire Snapshots
- Cleanup of Files
- Rewrite Files with Deletes
- Checkpoint
- Advanced Features
- Constraints
- Conflict Resolution
- Data Change Feed
- Data Inlining
- Encryption
- Partitioning
- Transactions
- Row Lineage
- Macros
- Views
- Comments
- Sorted Tables
- Metadata
- Migrations
- Guides
- Overview
- Access Control
- Backups and Recovery
- Public DuckLake on Object Storage
- Using a Remote Data Path
- Troubleshooting
- Unsupported Features
- FAQ
Documentation
/ Specification
/ Tables
ducklake_sort_info
The ducklake_sort_info table records the version history of sort settings for tables. Each row represents one sort configuration applied to a table, with snapshot-based validity tracking.
| Column name | Column type | |
|---|---|---|
sort_id |
BIGINT |
|
table_id |
BIGINT |
|
begin_snapshot |
BIGINT |
|
end_snapshot |
BIGINT |
sort_idis a numeric identifier for a sort configuration.sort_idis allocated fromnext_catalog_idin theducklake_snapshottable.table_idrefers to atable_idfrom theducklake_tabletable.begin_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The sort configuration is valid starting with this snapshot id.end_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The sort configuration is valid up to but not including this snapshot id. Ifend_snapshotisNULL, the sort configuration is currently active.
The expressions associated with a sort configuration are stored in ducklake_sort_expression.