Results of 1 - 9 of about 9 for split (0.010 sec.)
- Text Functions – DuckDB 13265
- 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
...ring contains the regex , replaces the matching part with replacement . A set of optional regex options can be set. regexp_split_to_array(string, regex[, options]) Splits the string along the regex . A set of optional regex options can be set. 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 time...e) Returns a VARCHAR with the SHA-1 hash of the value . sha256(value) Returns a VARCHAR with the SHA-256 hash of the value split(string, separator) Splits the string along the separator . split_part(string, separator, index) Splits the string along th... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- CSV Auto Detection – DuckDB 10371
- 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
...NY|Los Angeles, CA 1988-01-03|AA|New York, NY|Los Angeles, CA In this file, the dialect detection works as follows: If we split by a | every row is split into 4 columns If we split by a , rows 2-4 are split into 3 columns, while the first row is spli...t into 1 column If we split by ; , every row is split into 1 column If we split by \t , every row is split into 1 column In this example – the system...selects the | as the delimiter. All rows are split into the same amount of columns, and there is more than one column per row meaning the delimiter was actually found in the... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Regular Expressions – DuckDB 9760
- 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
...fault, only the first occurrence is replaced. A set of optional options , 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 a row for each part. regexp_extract(string, pattern[, group = 0][, options]) Descr...ional options , including the global flag g , can be set. Example regexp_replace('hello', '[lo]', '-') 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... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Interval Type – DuckDB 8843
- 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
...OM range ( 12 ) t ( i ); When INTERVAL s are deconstructed via the datepart function, the months component is additionally split into years and months, and the microseconds component is split into hours, minutes, and microseconds. The days component i...s not split into additional units. To demonstrate this, the following query generates an INTERVAL called period by summing random amou...random () * 12_345 ) DAYS + INTERVAL ( random () * 12_345 ) MONTHS ) ) _ ( period ); Warning The microseconds component is split only into hours, minutes, and microseconds, rather than hours, minutes, seconds , and microseconds. Additionally, the amou... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- PIVOT Statement – DuckDB 8106
- 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
...ate a separate column for each year and calculate the total population in each. The ON clause specifies which column(s) to split into separate columns. It is equivalent to the columns parameter in a spreadsheet pivot table. The USING clause determines...how to aggregate the values that are split into separate columns. This is equivalent to the values parameter in a spreadsheet pivot table. If the USING clause is not...d in the USING clause. In this example, both the sum and max of the population column are calculated for each year and are split into separate columns. PIVOT cities ON year USING sum ( population ) AS total , max ( population ) AS max GROUP BY country... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- Hive Partitioning – DuckDB 7675
- 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
...will include year, month partition columns Hive Partitioning Hive partitioning is a partitioning strategy that is used to split a table into multiple files based on partition keys . The files are organized into folders. Within each folder, the partit... - https://man.mtool.work/duckdb/1.3/data/partitioning/hive_partitioning.html
- Indexes – DuckDB 7621
- 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
...ATE my_table SET i = i + 1 ; Constraint Error: Duplicate key "i: 2048" violates primary key constraint. A workaround is to split the UPDATE into a DELETE ... RETURNING ... followed by an INSERT , with some additional logic to (temporarily) store the r... - https://man.mtool.work/duckdb/1.3/sql/indexes.html
- SELECT Statement – DuckDB 7621
- 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
...T n ; Optionally, the SELECT statement can be prefixed with a WITH clause . As the SELECT statement is so complex, we have split up the syntax diagrams into several parts. The full syntax diagram can be found at the bottom of the page. SELECT Clause T... - https://man.mtool.work/duckdb/1.3/sql/statements/select.html
- Analyzing a Git Repository – DuckDB 7549
- 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
...messages: CREATE TABLE words AS SELECT unnest ( message . lower () . regexp_replace ( '\W' , ' ' ) . trim ( ' ' ) . string_split_regex ( '\W' ) ) AS word FROM commits ; Then, we remove stopwords using a pre-defined list: CREATE TABLE stopwords AS SELE... - https://man.mtool.work/duckdb/1.3/guides/snippets/analyze_git_repository.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work