Results of 1 - 10 of about 63 for match (0.002 sec.)
- Pattern Matching 12560
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...pression returns true if the string matches the supplied pattern. (As expected, the NOT LIKE expression returns false if LIKE returns true , and vice versa. An equi...represents the string itself; in that case LIKE acts like the equals operator. An underscore ( _ ) in pattern stands for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching alway...s covers the entire string. Therefore, if it's desired to match a sequence anywhere within a string, the pattern must start and end with a percent sign. Some examples: SELECT 'abc' LIKE... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Reading Multiple Files 11595
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...LECT * FROM read_csv(['flights1.csv', 'flights2.csv'], union_by_name = true, filename = true); Parquet Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet'; Read three Parquet files and treat them as a single table: SELECT * FROM...two specific folders: SELECT * FROM read_parquet(['folder1/*.parquet', 'folder2/*.parquet']); Read all Parquet files that match the glob pattern at any depth: SELECT * FROM read_parquet('dir/**/*.parquet'); Multi-File Reads and Globs DuckDB can also...quet files have the same schema. You can specify which Parquet files you want to read using a list parameter, glob pattern matching syntax, or a combination of both. Directory Paths The read_parquet function accepts a local directory path and recursiv... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Map Functions 10961
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
...y provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging the input map...a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Returns the value for a given key or NUL...L if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_from_entries(STRUCT(k, v)[]) Returns a map created from the entr... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- WHERE Clause 10644
- The WHERE clause specifies any filters to apply to the data. This allows you to select only a subset of the data in which you are interested. Logically the WHERE clause is applied immediately after the FROM clause. Examples Select all rows
...where the id is equal to 3: SELECT * FROM tbl WHERE id = 3; Select all rows that match the given case-sensitive LIKE expression: SELECT * FROM tbl WHERE name LIKE '%mark%'; Select all rows that match the given...sensitive expression formulated with the ILIKE operator: SELECT * FROM tbl WHERE name ILIKE '%mark%'; Select all rows that match the given composite expression: SELECT * FROM tbl WHERE id = 3 OR id = 7; Syntax... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/where.html
- MERGE INTO Statement 9592
- The MERGE INTO statement is an alternative to INSERT INTO ... ON CONFLICT that doesn't need a primary key since it allows for a custom match condition. This is a very useful alternative for upserting use cases ( INSERT + UPDATE ) when the d
...0.0), (2, 'Anna', 100_000.0); The simplest upsert would be to use a whole row in the USING clause. This way, if there is a match, the row can be updated to the new row without further instuctions ( WHEN MATCHED THEN UPDATE ), and when there is no matc...h, the row can be trivially inserted into the table ( WHEN NOT MATCHED THEN INSERT ). MERGE INTO people USING ( SELECT unnest([3, 1]) AS id, unnest(['Sarah', 'John']) AS name, unnest([95_000....0, 105_000.0]) AS salary ) AS upserts ON (upserts.id = people.id) WHEN MATCHED THEN UPDATE WHEN NOT MATCHED THEN INSERT; FROM people ORDER BY id; id name salary 1 John 105000.0 2 Anna 100000.0 3 Sara... - https://man.mtool.work/duckdb/2.0/sql/statements/merge_into.html
- Regular Expressions 9477
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...egex in string and returns the capturing groups as a list of structs with corresponding names from name_list . regexp_full_match(string, regex[, options]) Returns true if the entire string matches the regex . regexp_matches(string, pattern[, options])...se otherwise. regexp_replace(string, pattern, replacement[, options]) If string contains the regexp pattern , replaces the matching part with replacement . By default, only the first occurrence is replaced. A set of optional options , including the gl...14', '(\w+):\s*(\d+)', ['name', 'age']) | | Result | [{'name': Peter, 'age': 33}, {'name': Paul, 'age': 14}] | regexp_full_match(string, regex[, options]) | Description | Returns true if the entire string matches the regex . A set of optional options... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- FROM and JOIN Clauses 9160
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...sed on how they are written in the join clause. Each result row has the columns from both relations. A join uses a rule to match pairs of rows from each relation. Often this is a predicate, but there are other implied rules that may be specified. Oute...r Joins Rows that do not have any matches can still be returned if an OUTER join is specified. Outer joins can be one of: LEFT (All rows from the left relation ap...with cities, airport codes and airport names. Note that both tables are intentionally incomplete, i.e., they do not have a matching pair in the other table. CREATE TABLE city_airport (city_name VARCHAR, iata VARCHAR); CREATE TABLE airport_names (iata... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- PostgreSQL Compatibility 8843
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...in DuckDB: SELECT true AS x UNION SELECT 2; PostgreSQL returns an error: ERROR: UNION types boolean and integer cannot be matched DuckDB performs an enforced cast, therefore, it completes the query and returns the following: x 1 2 Implicit Casting on...CREATE TABLE MyTaBLe (x INTEGER); SELECT table_name FROM duckdb_tables(); table_name mytable However, the case insensitive matching in the system for identifiers cannot be turned off. Using Double Equality Sign for Comparison DuckDB supports both = an...like PostgreSQL's regexp_substr function, DuckDB's regexp_extract returns empty strings instead of NULL s when there is no match. to_date Function DuckDB does not support the to_date PostgreSQL date formatting function . Instead, please use the strpti... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Full-Text Search Extension 8426
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...ed table. Name Type Description input_table VARCHAR Qualified name of input table, e.g., 'table_name' or 'main.table_name' match_bm25 Function match_bm25(input_id, query_string, fields := NULL, k := 1.2, b := 0.75, conjunctive := 0) When an index is b...d by Muhleisen . This retrieves doc1 : SELECT document_identifier, text_content, score FROM ( SELECT *, fts_main_documents.match_bm25( document_identifier, 'Muhleisen', fields := 'author' ) AS score FROM documents ) sq WHERE score IS NOT NULL AND doc_...out small cats . This retrieves doc2 : SELECT document_identifier, text_content, score FROM ( SELECT *, fts_main_documents.match_bm25( document_identifier, 'small cats' ) AS score FROM documents ) sq WHERE score IS NOT NULL ORDER BY score DESC; docume... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Unit Tester Configuration 8426
- 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
...run identity; the RUN_ID path level; shared across a run's tests; auto = generate --select-tag <string> Select tests which match named tag (as singleton set; multiple sets are OR'd) --select-tag-set <comma-separated strings> Select tests which match a...rather than fail tests that fail with a message that contains any of these substrings --skip-tag <string> Skip tests which match named tag (as singleton set; multiple sets are OR'd) --skip-tag-set <comma-separated strings> Skip tests which match all n... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
DuckDB 2.0 Documentation / man.mtool.work