Results of 1 - 8 of about 8 for emits (0.001 sec.)
- Describe 12417
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...i INTEGER NO PRI NULL NULL j VARCHAR YES NULL NULL NULL Deprecated Describing a table with SHOW tbl is deprecated and emits a warning. Use DESCRIBE tbl instead. The show_behavior setting controls whether SHOW resolves a bare identifier to a table... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Agent Mode 11477
- 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
...n tables. Prints a footer with the row count and, when the whole result was read, an order-independent hash of the result. Emits errors as JSON on stderr . Renders compact query plans and cost estimates. Prints an estimate line and progress on stderr... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Profile and Monitor 8675
- 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
...erlying duckdb_memory() query is never issued. Event Schema While a recording is active with the event enabled, the driver emits one duckdb.MemoryUsage event per DuckDB memory tag per JFR tick, with the following fields: Field Type Description compone... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Appender 8675
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...nder remains usable after flush() , clear() or leaving a with block. Warning Garbage collection discards buffered rows and emits a ResourceWarning . Call flush() or use a with block to write the rows. Errors and Retrying The appender checks its statem... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- Installing Extensions 8675
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...ensions', '/opt/duckdb/extensions']; Deprecated The extension_directory setting (singular) is deprecated in DuckDB 2.0 and emits a warning when set. It will be removed in a future release. Use extension_directories instead. Note that setting the value... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Logging 7735
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...gs very detailed tracing information The log level can be set using: CALL enable_logging(level = 'debug'); Warnings DuckDB emits warnings, for example when you use deprecated syntax or a deprecated setting, through the logging system at the WARNING le... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Unnesting 7735
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...([1, 2, 3]), ([4, 5])) tbl(l); Empty result: SELECT unnest([]); Empty result: SELECT unnest(NULL); Using unnest on a list emits one row per list entry. Regular scalar expressions in the same SELECT clause are repeated for every emitted row. When mult... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Pragmas 6814
- 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
...CT current_setting('option_name') . Deprecated Assigning configuration settings with PRAGMA name = value is deprecated and emits a warning. Use SET name = value instead. The warning becomes an error when warnings_as_errors is enabled. Function-style P... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work