Skip to contents

Remove the sort order from a table

Source: R/sorting.R
reset_table_sorting.Rd

Clears a table's declared sort order so newly written data files are no longer sorted. Existing files are unaffected.

Usage

reset_table_sorting(table_name)

Arguments

table_name

The name of the table.

Value

Invisibly returns NULL.

See also

set_table_sorting()

Other sorting: get_table_sorting(), set_table_sorting()

Examples

lake_dir <- tempfile("unsort_lake_")
dir.create(lake_dir)
attach_ducklake("unsort_lake", lake_path = lake_dir)
create_table(mtcars, "cars")

set_table_sorting("cars", "mpg")
#> Table "cars" is now sorted by "mpg".
#> ℹ Only newly written data is sorted; existing files keep their layout until
#>   compaction.
reset_table_sorting("cars")
#> Sort order removed from table "cars".

detach_ducklake("unsort_lake", shutdown = TRUE)
unlink(lake_dir, recursive = TRUE)