Results of 1 - 8 of about 8 for Splits (0.004 sec.)
- Regular Expressions 12091
- 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
..., including the global flag g , can be set. regexp_split_to_array(string, regex[, options]) Alias of string_split_regex . Splits the string along the regex . regexp_split_to_table(string, regex[, options]) Splits the string along the regex and returns...', '-') | | Result | he-lo | regexp_split_to_array(string, regex[, options]) | Description | Alias of string_split_regex . Splits the string along the regex . A set of optional options can be set. | | Example | regexp_split_to_array('hello world; 42',...';? ') | | Result | ['hello', 'world', '42'] | regexp_split_to_table(string, regex[, options]) | Description | Splits the string along the regex and returns a row for each part. A set of optional options can be set. | | Example | regexp_spl... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Text Functions 12091
- 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
...e set. regexp_split_to_array(string, regex[, options]) Alias for string_split_regex . regexp_split_to_table(string, regex) Splits the string along the regex and returns a row for each part. repeat(string, count) Repeats the string count number of times...ith the SHA-256 hash of the value . split(string, separator) Alias for string_split . split_part(string, separator, index) Splits the string along the separator and returns the data at the (1-based) index of the list. If the index is outside the bounds...or string_split . str_split_regex(string, regex[, options]) Alias for string_split_regex . string_split(string, separator) Splits the string along the separator . string_split_regex(string, regex[, options]) Splits the string along the regex . A set of... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Utility Functions 8657
- 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
...w(varargs, num_rows) Returns a table with num_rows rows, each containing the fields defined in varargs . sql_tokenize(sql) Splits the sql string into tokens. Returns a table with the columns start (the byte offset of the token), token_type (e.g., KEYWO...| | Example | repeat_row(1, 2, 'foo', num_rows = 3) | | Result | 3 rows of 1, 2, 'foo' | sql_tokenize(sql) | Description | Splits the sql string into tokens. Returns a table with the columns start (the byte offset of the token), token_type (e.g., KEYWO... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Write User Defined Functions 8404
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...is a type that implements the VTab trait, registered with register_table_function() and queried like any other table. VTab splits the work across three callbacks: bind runs once when the statement is prepared. It declares the result columns with add_re... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- R-Tree Indexes 8133
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...orm a somewhat costly splitting operation when a node reaches max capacity after an insert, potentially causing additional splits to cascade up the tree. However, when the R-tree index is created on an already populated table, a special bottom up "bulk... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Connect 7609
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...memory_limit=4GB;jdbc_stream_results=true Each entry is a key=value pair and surrounding whitespace is trimmed. The driver splits the URL on ; and each entry on = , so a value that itself contains a semicolon or an equals sign has to be passed in a Pro... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Python Client API 7609
- 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
...Expr Returns a VARCHAR with the SHA-256 hash of the value . SQL: sha256 . string_split ( * args : ValueOrExpr ) → ListExpr Splits the string along the separator . Arguments: separator. SQL: string_split . string_split_regex ( * args : ValueOrExpr ) → L...istExpr Splits the string along the regex . Arguments: regex. SQL: string_split_regex . strip_accents ( * args : ValueOrExpr ) → StrExpr... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Geometry Data Type 7609
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...r geometry columns where all values share the same geometry type and vertex dimensions. When a row group qualifies, DuckDB splits the geometry segment within the row group into primitive STRUCT , LIST , and DOUBLE segments that can be compressed indepe... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work