Results of 1 - 8 of about 8 for wildcard (0.002 sec.)
- Pattern Matching 13013
- 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
...SELECT 'abc' ILIKE '%C'; -- true SELECT 'abc' NOT ILIKE '%C'; -- false To search within a string for a character that is a wildcard ( % or _ ), the pattern must use an ESCAPE clause and an escape character to indicate the wildcard should be treated as a...literal character instead of a wildcard. See an example below. Additionally, the function like_escape has the same functionality as a LIKE expression with an ESCA...orts file name expansion, also known as globbing, for discovering files. DuckDB's glob syntax uses the question mark ( ? ) wildcard to match any single character and the asterisk ( * ) to match zero or more characters. In addition, you can use the bracke... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Text Functions 10537
- 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
...matches the like_specifier (see Pattern Matching ) using case-insensitive matching. escape_character is used to search for wildcard characters in the string . instr(string, search_string) Returns location of first occurrence of search_string in string ,...g matches the like_specifier (see Pattern Matching ) using case-sensitive matching. escape_character is used to search for wildcard characters in the string . lower(string) Converts string to lower case. lpad(string, count, character) Pads the string wit...matches the like_specifier (see Pattern Matching ) using case-insensitive matching. escape_character is used to search for wildcard characters in the string . not_like_escape(string, like_specifier, escape_character) Returns false if the string matches t... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Reading Multiple Files 9290
- 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
...e read_parquet function can either be an exact filename, or use a glob syntax to read multiple files that match a pattern. Wildcard Description * Matches any number of any characters (including none) ** Matches any number of subdirectories (including non...Matches one character given in the bracket [a-z] Matches one character from the range given in the bracket Note that the ? wildcard in globs is not supported for reads over S3 due to HTTP encoding issues. Here is an example that reads all the files that... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- SeaweedFS Import 8458
- Prerequisites For SeaweedFS , the S3-compatible gateway allows you to use DuckDB's S3 support to read and write from SeaweedFS buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only nee
...weedfs-host⟩:8333', URL_STYLE 'path', USE_SSL false ); SeaweedFS serves path-style requests, so set URL_STYLE to path . No wildcard DNS is needed. SeaweedFS does not require a region, so REGION can be omitted. Set USE_SSL false for a plain-HTTP endpoint... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/seaweedfs_import....
- JSON Overview 8260
- DuckDB supports SQL functions that are useful for reading values from existing JSON and creating new JSON data. JSON is supported with the json extension which is shipped with most DuckDB distributions and is auto-loaded on first use. If yo
...fields with .<key> or array elements with [<index>] . Arrays can be indexed from the back and both approaches support the wildcard * . DuckDB does not support the full JSONPath syntax because SQL is readily available for any further transformations. It'... - https://man.mtool.work/duckdb/2.0/data/json/overview.html
- Deploy as Native Image 8043
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...ibduckdb_java.so_osx_universal , and libduckdb_java.so_windows_amd64 . Name the one for your target platform explicitly. A wildcard matching all of them adds roughly 260 MB to the executable. This option produces a single self contained file, around 120... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Run Queries 7627
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...ln!("{list:?} {strukt:?}"); } Value , ValueRef , and Type are marked non-exhaustive, so a match over them should include a wildcard arm to stay forward-compatible as DuckDB adds types. To read whole result sets as columnar batches instead of row by row,... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- JSON Processing Functions 7012
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...family, extracted_list[2] AS species FROM extracted; Processing Extracted Arrays with Lambda Functions When a path with a wildcard such as [*] extracts a JSON array into a LIST , the result can be processed further with lambda functions . For example, u... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work