Results of 1 - 8 of about 8 for words (0.004 sec.)
- Analyzing a Git Repository – DuckDB 13790
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana..., 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 ().... 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 SELECT unnest ([ 'a' , 'about' , 'above' , 'after' , 'again' , 'agains... - https://man.mtool.work/duckdb/1.3/guides/snippets/analyze_git_repository.html
- DuckDB Environment – DuckDB 8603
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...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...eta number retrieve information instance following available objects columns constraints databases dependencies indexes keywords schemas sequences settings tables 関連するページ Extensions Extension Distribution Advanced Installation Methods Files Cre... - https://man.mtool.work/duckdb/1.3/guides/meta/duckdb_environment.html
- Full-Text Search Extension – DuckDB 8404
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...e 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 ) PRAGMA that creates a FTS index...'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... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Full-Text Search – DuckDB 8404
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...xt 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 full-text index of Shakespeare's p... - https://man.mtool.work/duckdb/1.3/guides/sql_features/full_text_search.html
- Map Type – DuckDB 8404
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...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/1.3/sql/data_types/map.html
- Union Type – DuckDB 8404
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...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/1.3/sql/data_types/union.html
- Text Functions – DuckDB 8205
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...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/1.3/sql/functions/text.html
- DuckDB_% Metadata Functions – DuckDB 8025
- 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
...straints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...E constraints are maintained using indexes, but their details are included in the duckdb_constraints() function. duckdb_keywords The duckdb_keywords() function provides metadata about DuckDB's keywords and reserved words. Column Description Type keywo...olumns duckdb_constraints duckdb_databases duckdb_dependencies duckdb_extensions duckdb_functions duckdb_indexes duckdb_keywords duckdb_log_contexts duckdb_logs duckdb_memory duckdb_optimizers duckdb_prepared_statements duckdb_schemas duckdb_secret_ty... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work