Results of 1 - 10 of about 100 for instead (0.007 sec.)
- Window Functions – DuckDB 14563
- 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
...a non-null value 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 curren...nt row (among rows with a non-null value of expr if IGNORE NULLS is set) 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 curren...tition rows. If an ORDER BY clause is specified, the distribution is computed within the frame using the provided ordering instead of the frame ordering. Return type DOUBLE Example cume_dist() dense_rank() Description The rank of the current row without... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Text Functions – DuckDB 10480
- 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
...to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. regexp_escape(string) Escapes special patterns to turn string into a regular ex...character start up to the end of the string. If optional argument length is set, extracts a substring of length characters instead. Note that a start value of 1 refers to the first character of the string . substring(string, start[, length]) Extracts su...character start up to the end of the string. If optional argument length is set, extracts a substring of length characters instead. Note that a start value of 1 refers to the first character of the string . substring_grapheme(string, start[, length]) Ex... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Configuration – DuckDB 10090
- 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
...ans. If fewer than MAX(index_scan_max_count, index_scan_percentage * total_row_count) rows match, we perform an index scan instead of a table scan. UBIGINT 2048 index_scan_percentage The index scan percentage sets a threshold for index scans. If fewer t...han MAX(index_scan_max_count, index_scan_percentage * total_row_count) rows match, we perform an index scan instead of a table scan. DOUBLE 0.001 lock_configuration Whether or not the configuration can be altered BOOLEAN false logging_lev...n ORDER BY clauses. BOOLEAN true produce_arrow_string_view Whether strings should be produced by DuckDB in Utf8View format instead of Utf8 BOOLEAN false s3_access_key_id S3 Access Key ID VARCHAR s3_endpoint S3 Endpoint VARCHAR s3_kms_key_id S3 KMS Key I... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- SQLite Extension – DuckDB 9700
- 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 above: Mismatch Type Error: Invalid type in column "i": column was declared as integer, found "hello" of type "text" instead. This error can be avoided by setting the sqlite_all_varchar option: SET GLOBAL sqlite_all_varchar = true ; When set, this...option overrides the type conversion rules described above, and instead always converts the SQLite columns into a VARCHAR column. Note that this setting must be set before sqlite_attach is calle...d. Opening SQLite Databases Directly SQLite databases can also be opened directly and can be used transparently instead of a DuckDB database file. In any client, when connecting, a path to a SQLite database file can be provided and the SQLite... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html
- Friendly SQL – DuckDB 8920
- 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
...thout manually defining a schema. INSERT INTO ... BY NAME : this variant of the INSERT statement allows using column names instead of positions. INSERT OR IGNORE INTO ... : insert the rows that do not result in a conflict due to UNIQUE or PRIMARY KEY co...umns with different expressions in a * expression. UNION BY NAME : perform the UNION operation along the names of columns (instead of relying on positions). Prefix aliases in the SELECT and FROM clauses : write x: 42 instead of 42 AS x for improved read...ables clause allows names query aliases schema using rows clauses group expression expressions files features queries more instead conflict syntax specific 関連するページ INSERT Statement SELECT Clause SELECT Statement Star Expression CREATE TABLE State... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- INSERT Statement – DuckDB 8920
- 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
...constraint, do nothing on conflict: INSERT OR IGNORE INTO tbl ( i ) VALUES ( 1 ); Or update the table with the new values instead: INSERT OR REPLACE INTO tbl ( i ) VALUES ( 1 ); Syntax INSERT INTO inserts new rows into a table. One can insert one or mo...OTHING ; DO UPDATE Clause (Upsert) The DO UPDATE clause causes the INSERT to turn into an UPDATE on the conflicting row(s) instead. The SET expressions that follow determine how these rows are updated. The expressions can use the special virtual table E...ional WHERE clause that can exclude certain rows from the update. The conflicts that don't meet this condition are ignored instead. Because we need a way to refer to both the to-be-inserted tuple and the existing tuple, we introduce the special EXCLUDED... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- Glossary of Terms – DuckDB 8725
- 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
...common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional client–server setup. An alternative term is embeddabl...s are used when a table name used by a query does not exist in the catalog. These scans can substitute another data source instead of the table. Using replacement scans allows DuckDB to, e.g., seamlessly read Pandas DataFrames or read input data from re...used to distributed DuckDB binaries and extension packages . 関連キーワード DuckDB used scans Terms common client process instead term database management system embedded Replacement replacement table These allows read details extension functionality D... - https://man.mtool.work/duckdb/1.3/guides/glossary.html
- Directly Reading Files – DuckDB 8530
- 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
...to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8, an error is thrown suggesting to use read_blob instead. read_blob The read_blob table function reads from the selected source(s) to a BLOB : SELECT size , content , filename FRO...ble to provide some of this data due (e.g., because HTTPFS can't always return a valid timestamp), the cell is set to NULL instead. Support for Projection Pushdown The table functions also utilize projection pushdown to avoid computing properties unnece...files content size text blob filename column functions DuckDB glob last reads selected parse path Hello World three valid instead Documentation Guides Formats 関連するページ Caveats Reading and Writing Parquet Files Reading Multiple Files Full CSV Impo... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Casting – DuckDB 8335
- 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
...will be attempted to be converted. TRY_CAST TRY_CAST can be used when the preferred behavior is not to throw an error, but instead to return a NULL value. TRY_CAST will never throw an error, and will instead return NULL if a cast is not possible. SELECT...st type hello Casting example types casting also throw return syntax explicit expr DuckDB generate series convert behavior instead allows column macros input world addition 関連するページ Typecasting JSON Type Union Type CREATE TYPE Statement Nested Fun... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- SQL Quirks – DuckDB 8140
- 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
...of examples. Aggregating Empty Groups On empty groups, the aggregate functions sum , list , and string_agg all return NULL instead of 0 , [] and '' , respectively. This is dictated by the SQL Standard and obeyed by all SQL implementations we know. This...order, like all other data types (beware the consequences for greatest / least ). age Function age(x) is current_date - x instead of current_timestamp - x . Another quirk inherited from PostgreSQL. Extract Functions list_extract / map_extract return NU...s bits DuckDB indexing integer types it's values extract clause others Standard different empty aggregate functions return instead inherited 関連するページ List Type PostgreSQL Import Overview List Tables PostgreSQL Extension PostgreSQL Compatibility Se... - https://man.mtool.work/duckdb/1.3/sql/dialect/sql_quirks.html
DuckDB 1.3 Documentation / man.mtool.work