Search Result: sink - DuckDB 2.0 全文検索

Order Preservation 9414: For many operations, DuckDB preserves the order of rows, similarly to data frame libraries such as Pandas. Example Take the following table for example: CREATE TABLE tbl AS SELECT * FROM (VALUES (1, 'a'), (2, 'b'), (3, 'c')) t(x, y); SELECT ... ( read_parquet function) The preserve_insertion_order setting governs whether this order is maintained as rows flow into a sink . A sink is any operation that consumes a result, namely: Writing to a file, for example with COPY ... TO Writing to a tab ... the setting is disabled, DuckDB may reorder the rows produced by a query that has no ORDER BY clause before they reach the sink. Preservation of insertion order is controlled by the preserve_insertion_order configuration option . This setting is true ...; https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work