Results of 1 - 7 of about 7 for guaranteed (0.004 sec.)
- Order Preservation 13359
- 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 preserve...ble aggregation (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 (sp... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- Overview of DuckDB Internals 9233
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...down : Pushes filters down into the query plan and duplicates filters over equivalency sets. Also prunes subtrees that are guaranteed to be empty (because of filters that statically evaluate to false). Join Order Optimizer : Reorders joins using dynamic pr... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- C++ API 8815
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- INSERT Statement 8397
- The INSERT statement inserts new data into a table. Examples Insert the values 1, 2, 3 into tbl : INSERT INTO tbl VALUES (1), (2), (3); Insert the result of a query into a table: INSERT INTO tbl SELECT * FROM other_tbl; Insert values into t
...rows that share the same conflict target, DuckDB applies only one update per conflicting key, and the row that wins is not guaranteed to be the last one in insertion order. In the example above, j ends up as 52 (the first of the two conflicting rows) rathe... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
- Spatial Functions 8197
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...a POINT_4D ST_PointN Returns the n'th vertex from the input geometry as a point geometry ST_PointOnSurface Returns a point guaranteed to lie on the surface of the geometry ST_Points Collects all the vertices in the geometry into a MULTIPOINT ST_Polygon2DFr...try as a point geometry ST_PointOnSurface Signature GEOMETRY ST_PointOnSurface (geom GEOMETRY) Description Returns a point guaranteed to lie on the surface of the geometry ST_Points Signature GEOMETRY ST_Points (geom GEOMETRY) Description Collects all the... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- COPY Statement 7979
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...terrupted write does not corrupt the previous file. Reading from and writing to the same file in a single statement is not guaranteed to be safe, however, and should be avoided. New Support for COPY ... blocks in CTEs was introduced in DuckDB 2.0. For othe... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Complete API 7579
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work