Results of 1 - 10 of about 36 for level (0.005 sec.)
- ODBC API on Linux – DuckDB 13693
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ion based on the user home directory to setup the ODBC init files. ./unixodbc_setup.sh -u The -s option changes the system level files that will be visible for all users, because of that it requires root privileges. sudo ./unixodbc_setup.sh -s The opt...ion --help shows the usage of unixodbc_setup.sh prints the help. ./unixodbc_setup.sh --help Usage: ./unixodbc_setup.sh <level> [options] Example: ./unixodbc_setup.sh -u -db ~/database_path -D ~/driver_path/libduckdb_odbc.so Level: -s: System-level,...using 'sudo' to configure DuckDB ODBC at the system-level, changing the files: /etc/odbc[inst].ini -u: User-level, configuring the DuckDB ODBC at the user-level, changing the files... - https://man.mtool.work/duckdb/1.3/clients/odbc/linux.html
- Logging – DuckDB 11950
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...an be queried like any other table. Example: PRAGMA enable_logging ; -- Run some queries.. SELECT * FROM duckdb_logs ; Log Level DuckDB supports different logging levels that control the verbosity of the logs: ERROR : Only logs error messages WARN : L...gs and errors (default) DEBUG : Logs detailed debugging information TRACE : Logs very detailed tracing information The log level can be set using: PRAGMA enable_logging ; SET logging_level = 'TRACE' ; Log Types In DuckDB, log messages can have an asso...nly messages of a specific type: PRAGMA enable_logging ( 'HTTP' ); The above pragma will automatically set the correct log level, and will add the HTTP type to the enabled_log_types settings. Structured Logging Some log types like HTTP will have an as... - https://man.mtool.work/duckdb/1.3/operations_manual/logging/overview.html
- GROUPING SETS – DuckDB 10507
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...oduces the grouping sets (country, city, zip), (country, city), (country), () . This can be useful for producing different levels of detail of a group by clause. This produces n+1 grouping sets where n is the amount of terms in the ROLLUP clause. CUBE...3 3 NULL 1 2023 4 10 0 2023 4 11 0 2023 4 12 0 2023 4 NULL 1 2023 NULL NULL 3 NULL NULL NULL 7 In this example, the lowest level of grouping is at the month level, defined by the grouping set (y, q, m) . Result rows corresponding to that level are sim...GROUPING_ID(y, q, m) function returns 0 for those. The grouping set (y, q) results in super-aggregate rows over the month level, leaving a NULL -value for the m column, and for which GROUPING_ID(y, q, m) returns 1 . The grouping set (y) results in su... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
- Spatial Functions – DuckDB 10365
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...g all of the source input's points, and which can be used to create polygons from points. The ratio parameter dictates the level of concavity; 1.0 returns the convex hull; and 0 indicates to return the most concave hull possible. Set allowHoles to a n...s a polygonized representation of the input geometries ST_QuadKey Compute the quadkey for a given lon/lat point at a given level. ST_ReducePrecision Returns the geometry with all vertices reduced to the given precision ST_RemoveRepeatedPoints Remove r...RING. ST_TileEnvelope The ST_TileEnvelope scalar function generates tile envelope rectangular polygons from specified zoom level and tile indices. ST_Touches Returns true if the geometries touch ST_Transform Transforms a geometry between two coordinat... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- List Functions – DuckDB 9778
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t without the first element. flatten(list_of_lists) Concatenate a list of lists into a single list. This only flattens one level of the list (see examples ). len(list) Return the length of the list. list_aggregate(list, name) Executes the aggregate fu...truncated to the smallest list length. repeat(list, count) Repeat the list count times. unnest(list) Unnests a list by one level. Note that this is a special function that alters the cardinality of the result. See the unnest page for more details. lis...]) Result [5, 6] flatten(list_of_lists) Description Concatenate a list of lists into a single list. This only flattens one level of the list (see examples ). Example flatten([[1, 2], [3, 4]]) Result [1, 2, 3, 4] len(list) Description Return the length... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Avro Extension – DuckDB 9636
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...on type ["int"] also becomes a DuckDB INTEGER . The extension also "flattens" the Avro schema. Avro defines tables as root-level "record" fields, which are the same as DuckDB STRUCT fields. For more convenient handling, this extension turns the entrie...s of a single top-level record into top-level columns. Implementation Internally, this extension uses the "official" Apache Avro C API , albeit wi...ro avro DuckDB read type extension files support union single also schema record currently There example filename contains level reading Apache table work pass list 関連するページ Union Functions Cloudflare R2 Import CSV Import Tips CREATE TYPE Statem... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- R-Tree Indexes – DuckDB 9335
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s the name of the R-tree index as an argument and returns a table with the following columns: Column name Type Description level INTEGER The level of the node in the R-tree. The root node has level 0 bounds BOX_2DF The bounding box of the node row_id...ee index. Notice how the area of the bounding boxes of the branch nodes -- decreases as we go deeper into the tree. SELECT level , bounds :: GEOMETRY AS geom , CASE WHEN row_id IS NULL THEN st_area ( geom ) ELSE NULL END AS area , row_id , CASE WHEN r..._dump ( 'my_idx' ) ORDER BY area DESC ; ┌───────┬──────────────────────────────┬────────────────────┬────────┬─────────┐ │ level │ geom │ area │ row_id │ kind │ │ int32 │ geometry │ double │ int64 │ varchar │ ├───────┼──────────────────────────────┼──... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- SELECT Clause – DuckDB 8621
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...he window function is computed. See the window functions page for more information. unnest Function Unnest an array by one level: SELECT unnest ([ 1 , 2 , 3 ]); Unnest a struct by one level: SELECT unnest ({ 'a' : 42 , 'b' : 84 }); The unnest function...is a special function that can be used together with arrays , lists , or structs . The unnest function strips one level of nesting from the type. For example, INTEGER[] is transformed into INTEGER . STRUCT(a INTEGER, b INTEGER) is transformed... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Profiling – DuckDB 8178
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLAIN , see the “Inspect Query Plans” page . For an in-depth explanation, see the “Profiling” page in t...ORMAT html ) SELECT 42 AS x ; Pragmas DuckDB supports several pragmas for turning profiling on and off and controlling the level of detail in the profiling output. The following pragmas are available and can be set using either PRAGMA or SET . They ca...ics The query tree has two types of nodes: the QUERY_ROOT and OPERATOR nodes. The QUERY_ROOT refers exclusively to the top-level node, and the metrics it contains are measured over the entire query. The OPERATOR nodes refer to the individual operators... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Azure Extension – DuckDB 8035
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...es on the Azure SDK to connect to Azure Blob storage and supports printing the SDK logs to the console. To control the log level, set the AZURE_LOG_LEVEL environment variable. For instance, verbose logs can be enabled in Python as follows: import os i...mport duckdb os . environ [ "AZURE_LOG_LEVEL" ] = "verbose" duckdb . sql ( "CREATE SECRET myaccount (TYPE azure, PROVIDER credential_chain, SCOPE 'az://myaccount.blob.... - https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
DuckDB 1.3 Documentation / man.mtool.work