Results of 1 - 10 of about 26 for along (0.003 sec.)
- Regular Expressions 11869
- 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
...lobal 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 p...| 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_split_to_table('hell... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Text Functions 11869
- 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
...t_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. replace(string,...sh 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 of the list, ret...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 optional regex o... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- GROUP BY Clause 11869
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...ditional examples in the “Friendlier SQL with DuckDB” blog post . Multiple Dimensions Normally, the GROUP BY clause groups along a single dimension. Using the GROUPING SETS , CUBE or ROLLUP clauses it is possible to group along multiple dimensions. Se... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- GROUPING SETS 10943
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...income) FROM addresses GROUP BY GROUPING SETS ((city, street_name), (city), (street_name), ()); Compute the average income along the same dimensions: SELECT city, street_name, avg(income) FROM addresses GROUP BY CUBE (city, street_name); Compute the a...verage income along the dimensions (city, street_name) , (city) and () : SELECT city, street_name, avg(income) FROM addresses GROUP BY ROLLUP... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- My Workload Is Slow 9389
- If you find that your workload in DuckDB is slow, we recommend performing the following checks. More detailed instructions are linked for each point. Do you have enough memory? DuckDB works best if you have 1-4 GB memory per thread . Is you
...threads . Are you aware of other common issues? If so, please click the Report content issue link below and describe them along with their workarounds.... - https://man.mtool.work/duckdb/2.0/guides/performance/my_workload_is_slow.html
- Friendly CLI 9092
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Metrics 9092
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...b patterns, e.g., ['query.*', 'operator.timing'] . By default, all metrics are collected ( ['*'] ). The available metrics, along with their types and units, can be listed with the duckdb_available_metrics() table function: SELECT metric_name, metric_t...al plan Examples The following example enables profiling, sets the output to a file and only collects the total query time along with the operator metrics. CREATE TABLE students (name VARCHAR, sid INTEGER); CREATE TABLE exams (eid INTEGER, subject VAR... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Summarize 8463
- The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 ,
...q50 , q75 , count ), and return these along the column name, column type, and the percentage of NULL values in the column. Note that the quantiles and percentiles are... - https://man.mtool.work/duckdb/2.0/guides/meta/summarize.html
- Spatial Functions 8166
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...the input geometry in meters, using an ellipsoidal model of the earth ST_LineInterpolatePoint Returns a point interpolated along a line at a fraction of total 2D length. ST_LineInterpolatePoints Returns a multi-point interpolated along a line at a fra...from a WKB encoded blob ST_LineSubstring Returns a substring of a line between two fractions of total 2D length. ST_LocateAlong Returns a point or multi-point, containing the point(s) at the geometry with the given measure ST_LocateBetween Returns a...Point Signature GEOMETRY ST_LineInterpolatePoint (line GEOMETRY, fraction DOUBLE) Description Returns a point interpolated along a line at a fraction of total 2D length. ST_LineInterpolatePoints Signature GEOMETRY ST_LineInterpolatePoints (line GEOMET... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Importing Data 8166
- The first step to using a database system is to insert data into that system. DuckDB can directly connect to many popular data sources and offers several data ingestion methods that allow you to easily and efficiently fill up the database.
...ds. The simplest is to use the CSV file's name: SELECT * FROM 'test.csv'; Alternatively, use the read_csv function to pass along options: SELECT * FROM read_csv('test.csv', header = false); Or use the COPY statement : COPY tbl FROM 'test.csv' (HEADER... - https://man.mtool.work/duckdb/2.0/data/overview.html
DuckDB 2.0 Documentation / man.mtool.work