Results of 1 - 10 of about 28 for root (0.002 sec.)
- Azure Extension 16517
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...ers afterwards. The following example shows how a glob is performed through each endpoint. Using the following filesystem: root ├── l_receiptmonth=1997-10 │ ├── l_shipmode=AIR │ │ └── data_0.csv │ ├── l_shipmode=SHIP │ │ └── data_0.csv │ └── l_shipmo...└── l_shipmode=TRUCK └── data_0.csv The following query is performed through the Blob endpoint: SELECT count(*) FROM 'az://root/l_receiptmonth=1997-*/l_shipmode=SHIP/*.csv'; It will perform the following steps: List all the files with the prefix root.../l_receiptmonth=1997- root/l_receiptmonth=1997-10/l_shipmode=SHIP/data_0.csv root/l_receiptmonth=1997-10/l_shipmode=AIR/data_0.csv root/l_receiptmont... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- HTTP User-Agent 8668
- HTTP User-Agent Core DuckDB sets the default user-agent as follows: duckdb/v2.0.0(osx_arm64) cli which indicates the DuckDB version, the platform and the client API (the value of the duckdb_api setting, e.g., cli , capi or cpp ). If the cus
...Azure Identity: azsdk-cpp-identity/1.11.0 (Darwin 25.2.0 arm64 Darwin Kernel Version 25.2.0: Tue Nov 18 21:07:05 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T6020 Cpp/201402) via Azure Blob/ADLSv2: azsdk-cpp-storage-blobs/12.15.0 (Darwin 25.2.0 ar...m64 Darwin Kernel Version 25.2.0: Tue Nov 18 21:07:05 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T6020 Cpp/201402) Delta (and Unity Catalog) The Delta extension employs calls from DuckDB... - https://man.mtool.work/duckdb/2.0/operations_manual/user_agents.html
- Profile and Monitor 8537
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...ling is not enabled. ProfilingInfo is a tree whose metrics are grouped and named in lowercase (see the metrics list ): the root's children are the root plan operator, with metrics such as type , timing and intermediate_rows , followed by one node per... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Profile and Monitor 8324
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...a Metrics map of metric name to value and a Children slice of child nodes. Metrics are grouped and named in lowercase: the root's children are the root plan operator, whose metrics include type and timing , followed by one node per metric group, e.g.... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- MySQL Extension 8258
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...database accessible to DuckDB use the ATTACH command with the mysql or the mysql_scanner type: ATTACH 'host=localhost user=root port=0 database=mysql' AS mysqldb (TYPE mysql); USE mysqldb; Warning Avoid including credentials, such as a password, dire...o MySQL. Below is a brief example of how to create a new table in MySQL and load data into it. ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql); CREATE TABLE mysql_db.tbl (id INTEGER, name VARCHAR); INSERT INTO...EAD_ONLY property which prevents making modifications to the underlying database. For example: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db (TYPE mysql, READ_ONLY); Supported Operations Below is a list of supported opera... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Numeric Functions 8258
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...om a set of n elements. Returns a HUGEINT . bit_count(x) Returns the number of bits that are set. cbrt(x) Returns the cube root of the number. ceil(x) Rounds the number up. ceiling(x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine o...gnbit is set or not. sin(x) Computes the sin of x . sinh(x) Computes the hyperbolic sine of x . sqrt(x) Returns the square root of the number. subtract(x, y) Alias for x - y . tan(x) Computes the tangent of x . tanh(x) Computes the hyperbolic tangent...rns the number of bits that are set. | | Example | bit_count(31) | | Result | 5 | cbrt(x) | Description | Returns the cube root of the number. | | Example | cbrt(8) | | Result | 2 | ceil(x) | Description | Rounds the number up. | | Example | ceil(17.... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Linux 8193
- Prerequisites On Linux, install the required packages with the package manager of your distribution. Ubuntu and Debian CLI Client On Ubuntu and Debian (and also MX Linux, Linux Mint, etc.), the requirements for building the DuckDB CLI clien
...ake-3.22/Modules/FindPackageHandleStandardArgs.cmake:230 (message): Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the system variable OPENSSL_ROOT_DIR (missing: OPENSSL_CRYPTO_LIBRARY OPENSSL_INCLUDE_DIR) Solution: Install the... - https://man.mtool.work/duckdb/2.0/dev/building/linux.html
- sqllogictest Introduction 8193
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...pecify --test-dir <root_directory> and make sure provided test file paths are relative to that root directory. The test describes a series of SQL... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- SELECT Clause 8127
- The SELECT clause specifies the list of columns that will be returned by the query. While it appears first in the clause, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that
...T * FROM tbl; Perform arithmetic on the columns in a table, and provide an alias: SELECT col1 + col2 AS res, sqrt(col1) AS root FROM tbl; Use prefix aliases: SELECT res: col1 + col2, root: sqrt(col1) FROM tbl; Select all unique cities from the addres... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/select.html
- Unit Tester Configuration 8045
- 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
...in bytes after which to trigger automatic checkpointing --comment <string> Extra free form comment line --data-dir <path> Root dir for test data; default WORKING_DIR/data. Relative values resolve per test cwd; absolute/remote (e.g. az://... ) values...rize-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. s3:// ) --temp-dir-create <never|on-absent|always> Default on-absent: m... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
DuckDB 2.0 Documentation / man.mtool.work