Results of 1 - 10 of about 370 for variable (0.005 sec.)
- SET VARIABLE and RESET VARIABLE Statements – DuckDB 16837
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...ew Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Statements Copy Markdown SET VARIABLE and RESET VARIABLE Statements DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIA...BLE statements. Variable Scopes DuckDB supports two levels of variable scopes: Scope Description SESSION Variables with a SESSION scope are local t... - https://man.mtool.work/duckdb/1.3/sql/statements/set_variable.html
- Aggregate Functions – DuckDB 13409
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...FLOAT s, then the result is a LIST of the corresponding discrete quantiles. regr_avgx(y, x) The average of the independent variable for non- NULL pairs, where x is the independent variable and y is the dependent variable. regr_avgy(y, x) The average of t...he dependent variable for non- NULL pairs, where x is the independent variable and y is the dependent variable. regr_count(y, x) The number of n... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Bitstring Type – DuckDB 6916
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...vot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Bitstring Type Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A bitstring valu...string length strings Bitstrings padded zeroes values Functions Documentation Types Copy Markdown Type Aliases Description Variable type variable requires byte group bits plus fixed 関連するページ Bitstring Functions Text Types Functions Data Types Neste... - https://man.mtool.work/duckdb/1.3/sql/data_types/bitstring.html
- Struct Functions – DuckDB 6916
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...ame := any, ...) Add field(s)/value(s) to an existing STRUCT with the argument values. The entry name(s) will be the bound variable name(s). struct_pack(name := any, ...) Create a STRUCT containing the argument values. The entry name will be the bound va......) Description Add field(s)/value(s) to an existing STRUCT with the argument values. The entry name(s) will be the bound variable name(s). Example struct_insert({'a': 1}, b := 2) Result {'a': 1, 'b': 2} struct_pack(name := any, ...) Description Create... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Azure Extension – DuckDB 6563
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...l curl capabilities (for example using a socks proxies). On all operating systems, it will honor the following environment variables: CURL_CA_INFO : Path to a PEM encoded file containing the certificate authorities sent to libcurl. Note that this option...'http://localhost:3128' , PROXY_USER_NAME 'john' , PROXY_PASSWORD 'doe' ); When using secrets, the HTTP_PROXY environment variable will still be honored except if you provide an explicit value for it. When using secrets, the SET variable of the Authenti... - https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
- UI Extension – DuckDB 6299
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...rt The local port of the HTTP server can be configured with a SQL command like: SET ui_local_port = 4213 ; The environment variable ui_local_port can also be used. The default port is 4213. (Why? 4 = D, 21 = U, 3 = C) Remote URL The local HTTP server fet...ernate remote URL can be configured with a SQL command like: SET ui_remote_url = 'https://ui.duckdb.org' ; The environment variable ui_remote_port can also be used. This setting is available mainly for testing purposes. Be sure you trust any URL you conf... - https://man.mtool.work/duckdb/1.3/core_extensions/ui.html
- Union Functions – DuckDB 6211
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...union_value(tag := any) Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected tag of the union as an Enum . union.tag Description Dot notation se...tag := any) Description Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. Example union_value(k := 'hello') Result 'hello'::UNION(k VARCHAR) union_tag(union) Description Retrieve the current... - https://man.mtool.work/duckdb/1.3/sql/functions/union.html
- Text Types – DuckDB 6035
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...icode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string VARCHAR(n) CHAR(n) , BPCHAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum...ード length strings type characters character Specifying Text storage text literals Types allows Unicode Internally encoded Variable maximum effect compatibility reasons example Type compression zstd Values 関連するページ Bitstring Type Information Schema... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Array Type – DuckDB 5859
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...g ARRAY , LIST and STRUCT types. Arrays can be used to store vectors such as word embeddings or image embeddings. To store variable-length lists, use the LIST type . See the data types overview for a comparison between nested data types. The ARRAY type i...n PostgreSQL allows variable-length fields. DuckDB's ARRAY type is fixed-length. Creating Arrays Arrays can be created using the array_value(expr, ...)... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
- marimo Notebooks – DuckDB 5770
- 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
...W CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL PIVOT Profiling SELECT SET / RESET SET VARIABLE SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS...m DuckDB connection instead of using the default global connection, create a cell and create a DuckDB connection as Python variable: import duckdb # Create a DuckDB connection conn = duckdb . connect ( "path/to/my/duckdb.db" ) marimo automatically discov...ata Sources Panel Reference a Local Dataframe Reference a local dataframe in your SQL cell by using the name of the Python variable that holds the dataframe. If you have a database connection with a table of the same name, the database table will be used... - https://man.mtool.work/duckdb/1.3/guides/python/marimo.html
DuckDB 1.3 Documentation / man.mtool.work