Results of 1 - 10 of about 370 for Pattern (0.004 sec.)
- Regular Expressions – DuckDB 14801
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...t Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Regular Expressions DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Express...ax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pattern , returns the capturing group specified by optional paramet... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Pattern Matching – DuckDB 13823
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Pattern Matching There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , th...operator , and POSIX-style regular expressions . LIKE The LIKE expression 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 equivalent expression is NO... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Reading Multiple Files – DuckDB 8810
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...([ '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 read_parquet ([...rs: 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 read a series... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- Text Functions – DuckDB 8810
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the string matches the regex (see Pattern Matching ). string ^@ search...ntation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-insensitive matching. escape_character is used to search for wildcard characters in the string . ins... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Partitioned Writes – DuckDB 8414
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...to many small partitions is expensive. It is generally recommended to have at least 100 MB of data per partition. Filename Pattern By default, files will be named data_0.parquet or data_0.csv . With the flag FILENAME_PATTERN a pattern with {i} or {uuid}...in the filename: COPY orders TO 'orders' ( FORMAT parquet , PARTITION_BY ( year , month ), OVERWRITE_OR_IGNORE , FILENAME_PATTERN 'orders_{i}' ); Write a table to a Hive partitioned data set of .parquet files, with unique filenames: COPY orders TO 'ord... - https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html
- Dot Commands – DuckDB 7145
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...rogram with return-code CODE .headers on/off Turn display of headers on or off . Does not apply to duckbox mode .help -all PATTERN Show help text for PATTERN .highlight on/off Toggle syntax highlighting in the shell on / off . See the query syntax highl....read FILE Read input from FILE .rows Row-wise rendering of query results (default) .safe_mode Activates safe mode .schema PATTERN Show the CREATE statements matching PATTERN .separator COL ROW Change the column and row separators .shell CMD ARGS... Run... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Utility Functions – DuckDB 6352
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...UNION ALL BY NAME semantics. read_blob(source) Returns the content from source (a filename, a list of filenames, or a glob pattern) as a BLOB . See the read_blob guide for more details. read_text(source) Returns the content from source (a filename, a li...st of filenames, or a glob pattern) as a VARCHAR . The file content is first validated to be valid UTF-8. If read_text attempts to read a file with invalid U... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Star Expression – DuckDB 6255
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...allows you to replace specific columns. SELECT * RENAME ( col1 AS height , col2 AS width ) FROM tbl ; Column Filtering via Pattern Matching Operators The pattern matching operators LIKE , GLOB , SIMILAR TO and their variants allow you to select columns...by matching their names to patterns. SELECT * LIKE 'col%' FROM tbl ; SELECT * GLOB 'col*' FROM tbl ; SELECT * SIMILAR TO 'col.' FROM tbl ; COLUMNS Expression... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Storage Versions and Format – DuckDB 5665
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...00000010 00 00 00 00 |....| 00000014 A simple example of reading the storage version using Python is below. import struct pattern = struct . Struct ( '<8x4sQ' ) with open ( 'test/sql/storage_version/storage_version.db' , 'rb' ) as fh : print ( pattern.... unpack ( fh . read ( pattern . size ))) Storage Version Table For changes in each given release, check out the change log on GitHub. To see the commits... - https://man.mtool.work/duckdb/1.3/internals/storage.html
- Text Types – DuckDB 5665
- 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
...nctions Enum Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone F...; ┌──────────────┐ │ msg │ │ varchar │ ├──────────────┤ │ Hello\nworld │ └──────────────┘ Functions See Text Functions and Pattern Matching . 関連キーワード length strings type characters character Specifying Text storage text literals Types allows Unic...ibility reasons example Type compression zstd Values 関連するページ Bitstring Type Information Schema Values Literal Types Pattern Matching Array Type See this page as Markdown Edit this page on GitHub Report content issue © 2026 DuckDB Foundation, Amst... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
DuckDB 1.3 Documentation / man.mtool.work