Results of 1 - 4 of about 4 for guarantee (0.001 sec.)
- Order Preservation 12353
- 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
...LECT * FROM tbl WHERE x % 2 == 1; x y 1 a 3 c Because the row (1, 'a') occurs before (3, 'c') in the original table, it is guaranteed to come before that row in this table too. Clauses The following clauses guarantee that the original row order is preserv...y default. On materialized tables, the rowid pseudo-column can be used to the same effect. The following operations do not guarantee that the row order is preserved: FROM with multiple tables and/or subqueries JOIN UNION USING SAMPLE Whole-table aggregati...on (the input order, that is, the order in which rows are fed into order-sensitive aggregate functions is not guaranteed unless explicitly specified in the aggregate function) GROUP BY (neither in- nor output order are guaranteed) ORDER BY (s... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- Securing Extensions 8876
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...e dependencies without thinking twice. Some repositories like CRAN enforce a human inspection at some point, but that's no guarantee for anything either. We've studied several different approaches to community extension repositories and have picked what w... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- CSV Import 8007
- 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 =
...rned by the CSV reader is the same as the order of the corresponding lines read from the file(s). When false , there is no guarantee that the order is preserved. Writing CSV Files DuckDB can write CSV files using the COPY ... TO statement .... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Configuration 7711
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ables invalidating the database instance when encountering a fatal error. Should be used with great care, as DuckDB cannot guarantee correct behavior after a fatal error. BOOLEAN false disable_parquet_prefetching Disable the prefetching mechanism in Parqu... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work