Results of 1 - 10 of about 35 for pattern (0.004 sec.)
- Regular Expressions 13653
- 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
...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...be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns the capturing groups as a struct with corresponding.... regexp_full_match(string, regex[, options]) Returns true if the entire string matches the regex . regexp_matches(string, pattern[, options]) Returns true if string contains the regexp pattern , false otherwise. regexp_replace(string, pattern, replacem... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Pattern Matching 13414
- 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 equivalent expression is NO...T (string LIKE pattern) .) If pattern does not contain percent signs or underscores, then the pattern only 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 patt... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Reading Multiple Files 10104
- 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
...d_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 read_parquet(['f...olders: 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 of...the Parquet 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 re... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Partitioned Writes 9738
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...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}...index 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 dataset of .parquet files, with unique filenames: COPY orders TO 'order...s' (FORMAT parquet, PARTITION_BY (year, month), OVERWRITE_OR_IGNORE, FILENAME_PATTERN 'file_{uuid}'); Custom Partition Paths New As of DuckDB 2.0, the PARTITION_PATH option gives full control over the subdire... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- Text Functions 9484
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...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...string . like_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-sensitive matching. escape_character is used to search for wildcard characters in the string . lower... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Dot Commands 9118
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...separator used when rendering numbers. Only for duckbox mode .dump ⟨TABLE⟩ Render database content as SQL. TABLE is a LIKE pattern for the tables to dump .display_colors ⟨bold/underline⟩ Display all terminal colors and their names. See the 8-bit colors...m 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 . Use .help shortcuts to display keyboard shortcuts .highlight ⟨on/off⟩ Toggle syntax highligh...ax Highlighting page .rows Row-wise rendering of query results (default) .safe_mode Activates safe mode .schema ⟨OPTIONS⟩ ⟨PATTERN⟩ Show the CREATE statements matching PATTERN . Pretty-prints and highlights by default; use --no-indent (alias --no-format... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Star Expression 8561
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...AME 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; The NOT variants of t...hese operators are also supported to exclude columns that match the pattern: SELECT * NOT SIMILAR TO 'col.' FROM tbl; COLUMNS Expression The COLUMNS expression is similar to the regular star express... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
- Utility Functions 7956
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...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...wo tables) | read_blob(source) | Description | 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. | | Example | read_blob('hello.bin') | | Result | hello\x0A | read_... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Python Client API 7829
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...uiltins.list [ str ] | None = None , write_partition_columns : bool | None = None , append : bool | None = None , filename_pattern : str | None = None , file_size_bytes : str | int | None = None ) → None Write the relation object to a Parquet file in ‘f...uiltins.list [ str ] | None = None , write_partition_columns : bool | None = None , append : bool | None = None , filename_pattern : str | None = None , file_size_bytes : str | int | None = None ) → None Write the relation object to a Parquet file in ‘f...its SQL text. ignore_nulls ( ) → Expression Skip NULLs, for first_value , last_value , lag , lead and nth_value . ilike ( pattern : object , * , escape : str | None = None ) → Expression like , ignoring case. is_not_null ( ) → Expression Whether this i... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Hugging Face Support 7701
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL pattern
...ata table as follows: SELECT * FROM data; Multiple Files To query all files under a specific directory, you can use a glob pattern . For example: SELECT count(*) AS count FROM 'hf://datasets/cais/mmlu/astronomy/*.parquet'; count 173 By using glob patter... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
DuckDB 2.0 Documentation / man.mtool.work