Results of 1 - 10 of about 140 for default (0.007 sec.)
- Relational API – DuckDB 12130
- 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
...ne if no header. compression : Optional[str] Compression type (e.g., 'gzip', 'bz2'). sep : Optional[str] Delimiter to use; defaults to comma. delimiter : Optional[str] Alternative delimiter to use. dtype : Optional[Dict[str, str]], Optional[List[str]] D...arquet Parameters file_glob : str File path or glob pattern pointing to Parquet files to be read. binary_as_string : bool, default: False Interpret binary columns as strings instead of blobs. file_row_number : bool, default: False Add a column containin...g the row number within each file. filename : bool, default: False Add a column containing the name of the file each row came from. hive_partitioning : bool, default: False Enable au... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- ALTER TABLE Statement – DuckDB 10450
- 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
...TABLE integers ( i INTEGER , j INTEGER ); Add a new column with name k to the table integers , it will be filled with the default value NULL : ALTER TABLE integers ADD COLUMN k INTEGER ; Add a new column with name l to the table integers, it will be fi...lled with the default value 10: ALTER TABLE integers ADD COLUMN l INTEGER DEFAULT 10 ; Drop the column k from the table integers: ALTER TABLE in...to convert the data for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat ( i , '_' , j ); Set the default value of a column: ALTER TABLE integers ALTER COLUMN i SET DEFAULT 10 ; Drop the default value of a column: ALTER TABLE in... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- ATTACH and DETACH Statements – DuckDB 9807
- 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
...); Detach the database with alias file : DETACH file ; Show a list of all attached databases: SHOW DATABASES ; Change the default database that is used to the database file : USE file ; ATTACH The ATTACH statement adds a new database file to the catalo...a between different database files. ATTACH supports HTTP and S3 endpoints. For these, it creates a read-only connection by default. Therefore, the following two commands are equivalent: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stat...to be closed and detached, releasing any locks held on the database file. Note that it is not possible to detach from the default database: if you would like to do so, issue the USE statement to change the default database to another one. For example,... - https://man.mtool.work/duckdb/1.3/sql/statements/attach.html
- Pragmas – DuckDB 9664
- 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
...lumn type VARCHAR , -- type of the column notnull BOOLEAN , -- if the column is marked as NOT NULL dflt_value VARCHAR , -- default value of the column, or NULL if not specified pk BOOLEAN -- part of the primary key or not Database Size Get the file and...eads for parallel query execution: SET threads = 4 ; Collations List all available collations: PRAGMA collations ; Set the default collation to one of the available ones: SET default_collation = 'nocase' ; Default Ordering for NULLs Set the default orde...for NULLs to be either NULLS_FIRST , NULLS_LAST , NULLS_FIRST_ON_ASC_LAST_ON_DESC or NULLS_LAST_ON_ASC_FIRST_ON_DESC : SET default_null_order = 'NULLS_FIRST' ; SET default_null_order = 'NULLS_LAST_ON_ASC_FIRST_ON_DESC' ; Set the default result set order... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- ORDER BY Clause – DuckDB 9473
- 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
...exing starts from 1), or the keyword ALL . Each expression can optionally be followed by an order modifier ( ASC or DESC , default is ASC ), and/or a NULL order modifier ( NULLS FIRST or NULLS LAST , default is NULLS LAST ). ORDER BY ALL The ALL keyword...mbination with other expressions in the ORDER BY clause – it must be by itself. See examples below. NULL Order Modifier By default, DuckDB sorts ASC and NULLS LAST , i.e., the values are sorted in ascending order and NULL values are placed last. This is...identical to the default sort order of PostgreSQL. The default sort order can be changed with the following configuration options. Use the default_... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
- Appender – DuckDB 8675
- 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
...duckdb_appender appender ); duckdb_state duckdb_appender_end_row ( duckdb_appender appender ); duckdb_state duckdb_append_default ( duckdb_appender appender ); duckdb_state duckdb_append_default_to_chunk ( duckdb_appender appender , duckdb_data_chunk c...tion : The connection context to create the appender in. schema : The schema of the table to append to, or nullptr for the default schema. table : The table name to append to. out_appender : The resulting appender object. Return Value DuckDBSuccess on s...on : The connection context to create the appender in. catalog : The catalog of the table to append to, or nullptr for the default catalog. schema : The schema of the table to append to, or nullptr for the default schema. table : The table name to appen... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- Window Functions – DuckDB 8627
- 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
...row that is the first row (with a non-null value of expr if IGNORE NULLS is set) of the window frame. lag(expr[, offset[, default]][ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is offset rows (among rows with a non-null va...ue of expr if IGNORE NULLS is set) before the current row within the window frame; if there is no such row, instead return default (which must be of the Same type as expr ). Both offset and default are evaluated with respect to the current row. If omitt...ed, offset defaults to 1 and default to NULL . last_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- CREATE MACRO Statement – DuckDB 8484
- 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
...ependent, and have an alias, FUNCTION : CREATE FUNCTION main. my_avg ( x ) AS sum ( x ) / count ( x ); Create a macro with default constant parameters: CREATE MACRO add_default ( a , b : = 5 ) AS a + b ; Create a macro arr_append (with a functionality e...add explicit type casts. Candidate functions: add(DATE, INTEGER) -> DATE add(INTEGER, INTEGER) -> INTEGER Macros can have default parameters. Unlike some languages, default parameters must be named when the macro is invoked. b is a default parameter: C...REATE MACRO add_default ( a , b : = 5 ) AS a + b ; The following will result in 42: SELECT add_default ( 37 ); The following will throw an error:... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Configuration – DuckDB 8329
- 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
...SET threads TO 1 ; Enable printing of a progress bar during long-running queries. SET enable_progress_bar = true ; Set the default null order to NULLS LAST . SET default_null_order = 'nulls_last' ; Return the current value of a specific setting. SELECT...Show a list of all available settings. SELECT * FROM duckdb_settings (); Reset the memory limit of the system back to the default. RESET memory_limit ; Secrets Manager DuckDB has a Secrets manager , which provides a unified user interface for secrets a...cross all backends (e.g., AWS S3) that use them. Configuration Reference Configuration options come with different default scopes : GLOBAL and LOCAL . Below is a list of all available configuration options by scope. Global Configuration Options... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Dot Commands – DuckDB 8091
- 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
...ilable commands, use the .help command. List of Dot Commands Command Description .bail on/off Stop after hitting an error. Default: off .binary on/off Turn binary output on or off . Default: off .cd DIRECTORY Change the working directory to DIRECTORY .c...al code used for keywords .large_number_rendering all/footer/off Toggle readable rendering of large numbers (duckbox only, default: footer ) .log FILE/off Turn logging on or off . FILE can be stderr / stdout .maxrows COUNT Sets the maximum number of row...s for display. Only for duckbox mode .maxwidth COUNT Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode .mode MODE TABLE Set output mode .multiline Set multi-line mode (default) .nullv... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
DuckDB 1.3 Documentation / man.mtool.work