⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 13 for collects (0.004 sec.)
Metrics 12193
DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr ... me spent generating the physical plan Examples The following example enables profiling, sets the output to a file and only collects the total query time along with the operator metrics. CREATE TABLE students (name VARCHAR, sid INTEGER); CREATE TABLE exam ... , "timing": 4.4209e-05, "type": "HASH_JOIN", "children": [ ... "query": { "total_time": 0.001491167 } } The second example collects all query and planner metrics, as well as the total time spent in the optimizers. SET tracked_metrics = ['query.*', 'plann ...
https://man.mtool.work/duckdb/2.0/dev/metrics.html
Troubleshooting 12193
This page collects the most common issues encountered when working with DuckDB and links to the detailed documentation for each. If you run into a problem that is not covered here, please consult the relevant section of the documentation or ...
https://man.mtool.work/duckdb/2.0/troubleshooting.html
Integration with Polars 9976
Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in ... rrent scope. DuckDB pushes the column selections of a query, and the filters it can translate, into a LazyFrame, so Polars collects only the rows and columns the query needs. A DataFrame is converted in full and filtered afterwards. import duckdb import ...
https://man.mtool.work/duckdb/2.0/guides/python/polars.html
Troubleshoot 8868
Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys ...
https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
Troubleshoot 8868
Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R ...
https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
Pragmas 8868
The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the ... s introduced in DuckDB 2.0, replacing the custom_profiling_settings PRAGMA used in earlier versions. By default, profiling collects all metrics. To collect only a subset, use the tracked_metrics setting, which accepts a list of metric glob patterns. A me ... e grouped by stage and written in group.metric form, for example query.cpu_time or operator.timing . The following example collects only the query-level metrics and every operator metric: SET tracked_metrics = ['query.*', 'operator.*']; To list all avail ...
https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
Spatial Functions 8868
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 ... olygonal geometry by attempting to “fill in” the input geometry. ST_Centroid Returns the centroid of a geometry ST_Collect Collects a list of geometries into a collection geometry. ST_CollectionExtract Extracts geometries from a GeometryCollection into a ... 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_Polygon2DFromWKB Deserialize a POLYGON_2D from a WKB encoded blob ST ... 2D) POINT_2D ST_Centroid (box BOX_2D) POINT_2D ST_Centroid (box BOX_2DF) Description Returns the centroid of a geometry ST_Collect Signature GEOMETRY ST_Collect (geoms GEOMETRY[]) Description Collects a list of geometries into a collection geometry. * If ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
Deploying Quack 8868
This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud ...
https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
Troubleshoot 7759
Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t ...
https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
Troubleshoot 7759
Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun ...
https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work