Results of 1 - 10 of about 25 for lower (0.004 sec.)
- Out-of-Memory Issues 12968
- Configuration Options If you are experiencing out-of-memory issues with DuckDB, try tweaking the following configuration options: Reduce the number of threads using the SET threads = ... command. Setting the memory limit lower than the defa
...eserve_insertion_order option to false : SET preserve_insertion_order = false . In short, try the settings: SET threads = ⟨lower_than_the_number_of_available_threads⟩; SET memory_limit = ⟨lower_than_80%_of_system_memory⟩; SET preserve_insertion_order... - https://man.mtool.work/duckdb/2.0/guides/performance/oom.html
- Utility Functions 12370
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...ptional config is a MAP(VARCHAR, VARCHAR) with the keys 'indent_size' , 'inline_threshold' and 'keyword_case' ( 'upper' , 'lower' or 'preserve' ). Provided by the autocomplete extension. error(message) Throws the given error message . equi_width_bins(...the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the string as a UHUGEINT . md5_number_lower(string) Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . md5_number_upper(string) Returns the...ring (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on invalid input. pg_typeof(expression) Returns the lower case name of the data type of the result of the expression. For PostgreSQL compatibility. query( query_string ) Table func... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Text Functions 11773
- 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
...nbin . from_hex(value) Alias for unhex . greatest(arg1, ...) Returns the largest value in lexicographical order. Note that lowercase characters are considered larger than uppercase characters and collations are not supported. hash(value, ...) Returns...ion of first occurrence of search_string in string , counting from 1. Returns 0 if no match found. lcase(string) Alias for lower . least(arg1, ...) Returns the smallest value in lexicographical order. Note that uppercase characters are considered smal...ler than lowercase characters and collations are not supported. left(string, count) Extracts the left-most count characters. left_graphem... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- SELECT Clause 8966
- The SELECT clause specifies the list of columns that will be returned by the query. While it appears first in the clause, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that
...ddresses table: SELECT * EXCLUDE (city) FROM addresses; Select all columns from the addresses table, but replace city with lower(city) : SELECT * REPLACE (lower(city) AS city) FROM addresses; Select all columns matching the given regular expression fr... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/select.html
- Full-Text Search Extension 8767
- 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
...ut_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 FTS index for the specified table. Name Type Description input_...ARCHAR Regular expression of patterns to be ignored. Defaults to '(\\.|[^a-z])+' , ignoring all escaped and non-alphabetic lowercase characters strip_accents BOOLEAN Whether to remove accents (e.g., convert á to a ). Defaults to 1 lower BOOLEAN Whethe...r to convert all text to lowercase. Defaults to 1 overwrite BOOLEAN Whether to overwrite an existing index on a table. Defaults to 0 incremental BOOLEAN... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Iceberg Functions 8767
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...istics stored in the manifests for every data file and column. Its columns include file_path , column_name , column_type , lower_bound , upper_bound , value_count , null_value_count and nan_value_count . SELECT * FROM iceberg_column_stats('data/iceber...ics per partition field. Its columns include partition_field_name , partition_source_columns , partition_field_transform , lower_bound and upper_bound . SELECT * FROM iceberg_partition_stats(my_datalake.default.t); iceberg_load_table_response The iceb...format, partition, record count, file size and column-level statistics ( column_sizes , value_counts , null_value_counts , lower_bounds , upper_bounds , readable_metrics , etc.). iceberg_manifests(source) allow_moved_paths , snapshot_from_id , snapsho... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Working with Huge Databases 8767
- This page contains information for working with huge DuckDB database files. While most DuckDB databases are well below 1 TB, in our 2024 user survey , 1% of respondents used DuckDB files of 2 TB or more (corresponding to roughly 10 TB of CS
...ctions, however, there are a few things to keep in mind when working with huge database files. Object storage systems have lower limits on file sizes than block-based storage systems. For example, AWS S3 limits the file size to 5 TB . Checkpointing a... - https://man.mtool.work/duckdb/2.0/guides/performance/working_with_huge_databases...
- Analyzing a Git Repository 8568
- 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
...a simple question: which topic was the most commonly mentioned in the commit messages: CI, CLI, or Python? SELECT message.lower().regexp_extract('\b(ci|cli|python)\b') AS topic, count(*) AS num_commits FROM commits WHERE topic <> '' GROUP BY ALL ORDE...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... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Python Client API 8369
- 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
...the values. The same as mean . SQL: avg . between ( low : object = <object object> , high : object = <object object> , * , lower : object = <object object> , upper : object = <object object> ) → Expression Inclusive range; lower and upper are the earl...htein': ('levenshtein', 0, ['VARCHAR', 'VARCHAR']), 'like_escape': ('like_escape', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'lower': ('lower', 0, ['VARCHAR']), 'lpad': ('lpad', 0, ['VARCHAR', 'INTEGER', 'VARCHAR']), 'ltrim': ('ltrim', 0, ['VARCHAR']), '...ValueOrExpr ) → Expression Whether it matches the pattern. Arguments: like_specifier, escape_character. SQL: like_escape . lower ( * args : ValueOrExpr ) → StrExpr Converts string to lower case. SQL: lower . lpad ( * args : ValueOrExpr ) → StrExpr Pad... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- CSV Auto Detection 8169
- 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
...rmat options manually. The system considers the following formats for dates ( dateformat ). Higher entries are chosen over lower entries in case of ambiguities (i.e., ISO 8601 is preferred over MM-DD-YYYY ). dateformat ISO 8601 %y-%m-%d %Y-%m-%d %d-%m...-%y %m-%d-%Y The system considers the following formats for timestamps ( timestampformat ). Higher entries are chosen over lower entries in case of ambiguities. timestampformat ISO 8601 %y-%m-%d %H:%M:%S %Y-%m-%d %H:%M:%S %d-%m-%y %H:%M:%S %d-%m-%Y %H... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
DuckDB 2.0 Documentation / man.mtool.work