Results of 1 - 4 of about 4 for preservation (0.001 sec.)
- Overview 12242
- DuckDB's SQL dialect is based on PostgreSQL. DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior. For example, interchangeability with data frame libraries necessitates order preservation
... - https://man.mtool.work/duckdb/2.0/sql/dialect/overview.html
- Order Preservation 9246
- 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
...tting 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 by default, i... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- Tuning Workloads 7896
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...ses, potentially reducing memory usage. For details on which operations preserve row order and which do not, see the Order Preservation page . Parallelism (Multi-Core Processing) The Effect of Row Groups on Parallelism DuckDB parallelizes the workload based... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- CSV Import 7563
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...g Faulty CSV Files DuckDB supports reading erroneous CSV files. For details, see the Reading Faulty CSV Files page . Order Preservation The CSV reader respects the preserve_insertion_order configuration option to preserve insertion order . When true (the def... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work