Results of 1 - 10 of about 11 for words (0.002 sec.)
- Analyzing a Git Repository 14243
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
..., commits related to continuous integration dominate the log! We can also do a more exploratory analysis by looking at all words in the commit messages. To do so, we first tokenize the messages: CREATE TABLE words AS SELECT unnest( message .lower() .r...egexp_replace('\W', ' ') .trim(' ') .string_split_regex('\W') ) AS word FROM commits; Then, we remove stopwords using a pre-defined list: CREATE TABLE stopwords AS SELECT unnest(['a', 'about', 'above', 'after', 'again', 'against', 'al...'who', 'whom', 'why', 'will', 'with', 'you', 'your', 'yours', 'yourself', 'yourselves']) AS word; CREATE OR REPLACE TABLE words AS FROM words NATURAL ANTI JOIN stopwords WHERE word != ''; We use the NATURAL ANTI JOIN clause here, which allows us to e... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- DuckDB Environment 9139
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...een objects duckdb_extensions() : extensions duckdb_functions() : functions duckdb_indexes() : secondary indexes duckdb_keywords() : DuckDB's keywords and reserved words duckdb_optimizers() : the available optimization rules in the DuckDB instance duc... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Unnesting 9139
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...duplicating the 'input' row while populating the field corresponding to the unnest() call with the element value. In other words, the original row becomes a repeating group for element unnnested from the LIST -typed value. Consequently, if unnest() ge...f elements than any of the other results. In a final step, the columns of the input row are added to this result. In other words, the repeating group is created only once, and for all unnest() results, rather than again for each individual unnest() re... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- CREATE MACRO Statement 8730
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...at specifies a default value cannot appear before a definition of a parameter that does not have a default value. In other words, parameters without default values have to be defined "in the front"; any parameters with default values appear "at the ba...lue expression. If a macro call contains named parameters, then they must appear after any positional parameters. In other words, any positional parameters must appear "in the front"; while all named parameters must appear "at the back". By definition... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Full-Text Search 8535
- DuckDB supports full-text search via the fts extension . A full-text index allows for a query to quickly search for all occurrences of individual words within longer text strings. Example: Shakespeare Corpus Here's an example of building a
... - https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html
- Map Type 8535
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...ERE and HAVING clauses, as well as for creating Boolean values . The ordering is defined positionally in the same way that words can be ordered in a dictionary. NULL values compare greater than all other values and are considered equal to each other.... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Union Type 8321
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...ng between Unions UNION types can be cast between each other if the source type is a “subset” of the target type. In other words, all the tags in the source UNION must be present in the target UNION , and all the types of the matching tags must be imp... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Full-Text Search Extension 8126
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...y by the extension. PRAGMA create_fts_index create_fts_index(input_table, input_id, *input_values, stemmer = 'porter', stopwords = 'english', ignore = '(\\.|[^a-z])+', strip_accents = 1, lower = 1, overwrite = 0, incremental = 0) PRAGMA that creates a...'serbian' , 'spanish' , 'swedish' , 'tamil' , 'turkish' , or 'none' if no stemming is to be used. Defaults to 'porter' stopwords VARCHAR Qualified name of table containing a single VARCHAR column containing the desired stopwords, or 'none' if no stopw...ords are to be used. Defaults to 'english' for a pre-defined list of 571 English stopwords ignore VARCHAR Regular expression of patterns to be ignored. Defaults to '(\\.|[^a-z])+' , ignoring all escaped and non-al... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Text Functions 7912
- 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
...ension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one str...ension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one str... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Geometry Data Type 7503
- 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
...e using an older storage version, the geometry statistics will turn into "unknown" statistics when checkpointing. In other words, the bounding box will be set to an infinitely large bounding box and all geometry types and vertex dimensions will be mar... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
DuckDB 2.0 Documentation / man.mtool.work