Results of 1 - 10 of about 17 for split (0.004 sec.)
- Text Functions 13156
- 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
...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]) Alias for string_split_regex . regexp_split_to_table(string, regex) Splits the string a...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) Alias for string_split . split_part(string, separator, index) Splits the string along the separator and...to match PostgreSQL's behavior). starts_with(string, search_string) Returns true if string begins with search_string . str_split(string, separator) Alias for string_split . str_split_regex(string, regex[, options]) Alias for string_split_regex . strin... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- CSV Auto Detection 12018
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...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 spl...it 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 syste...m 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/2.0/data/csv/auto_detection.html
- Regular Expressions 10966
- 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
...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]) | Des..., 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... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Interval Type 9449
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...NTH FROM 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 is...not split into additional units. To demonstrate this, the following query generates an INTERVAL called period by summing random amou...TERVAL (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. The following table descr... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Python Client API 8776
- 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
...or by the parts of a qualified name: col(“t”, “i”) is “t”.”i” . Every part is quoted whole, so any name works and none is split; a struct field is col(“st”)[“field”] . duckdb. ColumnExpression ( * names : str ) → Expression A column by name, or by th...e parts of a qualified name: ColumnExpression(“t”, “a”) is “t”.”a” . A name is taken whole and never split, so ColumnExpression(“a.b”) is the column called a.b ; the one name * is the star, as StarExpression() is. duckdb. Constan...AR']), 'rtrim': ('rtrim', 0, ['VARCHAR']), 'sha1': ('sha1', 0, ['VARCHAR']), 'sha256': ('sha256', 0, ['VARCHAR']), 'string_split': ('string_split', 0, ['VARCHAR', 'VARCHAR']), 'string_split_regex': ('string_split_regex', 0, ['VARCHAR', 'VARCHAR']), 's... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- PIVOT Statement 8586
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...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; count... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Hive Partitioning 7931
- Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, mont
...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/2.0/data/partitioning/hive_partitioning.html
- Indexes 7724
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...DATE 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/2.0/sql/indexes.html
- SELECT Statement 7724
- The SELECT statement retrieves rows from the database. Examples Select all columns from the table tbl : SELECT * FROM tbl; Select the rows from tbl : SELECT j FROM tbl WHERE i = 3; Perform an aggregate grouped by the column i : SELECT i, su
...⟨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/2.0/sql/statements/select.html
- Migrating Python Code to DuckDB 2.0 7638
- This page lists what Python code written for DuckDB 1.x must change to run on DuckDB 2.0. Each item gives the 1.x form, the 2.0 form and the page that explains it. For changes outside the Python client, see Migrating to DuckDB v2.0 . Python
...Expression API and update . Dotted column names. 1.x: ColumnExpression("t.x") was the column x of t . 2.0: a name is never split at a dot, so "t.x" is one column name, and a query without a column of that name raises a BinderException . Write col("t",... - https://man.mtool.work/duckdb/2.0/clients/python/migration.html
DuckDB 2.0 Documentation / man.mtool.work