Results of 1 - 10 of about 12 for summary (0.002 sec.)
- Agent Mode 11656
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
....maxcellwidth ⟨count⟩ Maximum number of characters per cell ( 0 for all) Tips for Agents The .help agent command prints a summary of agent mode. A few things that help when driving DuckDB programmatically: SET max_execution_time = ⟨milliseconds⟩ bounds...how long a query may run. DESCRIBE ⟨query⟩ returns the result columns without running the query. SUMMARIZE ⟨table⟩ returns summary statistics for a table. .tables lists the available tables. duckdb_functions() returns function descriptions and examples.... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- SUMMARIZE Statement 11656
- The SUMMARIZE statement returns summary statistics for a table, view or a query. Usage SUMMARIZE tbl; To summarize a query, prepend SUMMARIZE to a query. SUMMARIZE SELECT * FROM tbl; See Also For more examples, see the guide on SUMMARIZE .
... - https://man.mtool.work/duckdb/2.0/sql/statements/summarize.html
- Summarize 11355
- The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 ,
...NULL 6001215 0.00 Using SUMMARIZE in a Subquery SUMMARIZE can be used as a subquery. This allows creating a table from the summary, for example: CREATE TABLE tbl_summary AS SELECT * FROM (SUMMARIZE tbl); Summarizing Remote Tables It is possible to summa... - https://man.mtool.work/duckdb/2.0/guides/meta/summarize.html
- Friendly SQL 9586
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...ow to the new values of the to-be-inserted row. Describing tables and computing statistics: DESCRIBE : provides a succinct summary of the schema of a table or query. SUMMARIZE : returns summary statistics for a table or query. Making SQL clauses more co... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- EXPLAIN ANALYZE: Profile Queries 8985
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
...ry', 2), (30, 'Literature', 3); EXPLAIN ANALYZE SELECT name FROM students JOIN exams USING (sid) WHERE name LIKE 'Ma%'; ╭─ Summary ───────────╮ │ Total Time: 0.0015s │ ╰─────────────────────╯ ╭─ Projection ────────────────────────────────────────────╮ │... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Spatial Functions 8384
- 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
...the maximum Z coordinate of a geometry ST_ZMin Returns the minimum Z coordinate of a geometry Aggregate Functions Function Summary ST_AsMVT Make a Mapbox Vector Tile from a set of geometries and properties ST_CoverageInvalidEdges_Agg Returns the invalid...union of a set of input geometries. ST_Union_Agg Computes the union of a set of input geometries Macro Functions Function Summary ST_Rotate Alias of ST_RotateZ ST_RotateX Rotates a geometry around the X axis. This is a shorthand macro for calling ST_Af...es a geometry in X and Y direction. This is a shorthand macro for calling ST_Affine. ST_Translate Table Functions Function Summary ST_Drivers Returns the list of supported GDAL drivers and file formats ST_GeneratePoints Generates a set of random points... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Profile and Monitor 7800
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...g a Recording Inspect a captured recording with JDK Mission Control or the jfr command line tool bundled with the JDK: jfr summary app.jfr | grep duckdb.MemoryUsage jfr print --events duckdb.MemoryUsage app.jfr jfr metadata app.jfr | sed -n '/class Memo... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Python 7800
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...nreachable-branches \ --exclude-throw-branches \ --html --html-details -o coverage-cpp.html \ build/coverage/src \ --print-summary Building Wheels Build an sdist and a wheel for your system: uv build On CPython 3.12 and later, the wheel is tagged cp312-... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Unit Tester Configuration 7800
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...storage-version <string> Database storage version to use by default --summarize-failures , --no-summarize-failures Print a summary of all test failures after running --temp-dir-base <path> Override root of the temp-dir tree; may be local or remote (e.g.... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Jupyter Notebooks 7800
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...nly plots a subset of the data. %sqlplot histogram --table short_trips --column trip_distance --bins 10 --with short_trips Summary You now have the ability to alternate between SQL and Pandas in a simple and highly performant way! You can plot massive d... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
DuckDB 2.0 Documentation / man.mtool.work