Results of 1 - 10 of about 16 for upper (0.005 sec.)
- Utility Functions 12788
- 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
...rds. The optional 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_w...idth_bins(min, max, bincount, nice := false) Returns the upper boundaries of a partition of the interval [min, max] into bin_count equal-sized subintervals (for use with, e.g., histogra...UGEINT . 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 upper 64-bit segment of the MD5 hash of the string as a UBIGINT . nextval('sequence_name') Return the... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Text Functions 12182
- 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(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 a UBIGINT with the hash of the value . Note that...tch found. lcase(string) Alias for lower . least(arg1, ...) Returns the smallest value in lexicographical order. Note that uppercase characters are considered smaller than lowercase characters and collations are not supported. left(string, count) Extr...UGEINT . 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 upper 64-bit segment of the MD5 hash of the string as a UBIGINT . nfc_normalize(string) Converts strin... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Expression API 9946
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...he function name and any number of arguments, with fn(name, *args) . An argument that is a plain string is a value, so fn('upper', 's') passes the text s ; use col('s') for the column. import duckdb import pandas as pd from duckdb import col, fn df =...ve the string, date and time, list and JSON functions as methods that apply the function to the expression: col("s").str().upper() is upper("s") . rel = duckdb.sql("SELECT 'duck' AS s, DATE '2024-05-01' AS d, [3, 1, 2] AS l") print(rel.select( col("s"...).str().upper(), col("d").dt().year(), col("l").list().sort(), ).fetchall()) [('DUCK', 2024, [1, 2, 3])] Common Operations The Expressio... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Security 9738
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...onnection id and the full SQL text. Common shapes: Example: Read-Only CREATE MACRO read_only(sid, query) AS regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN|DESCRIBE|SHOW)\b'); SET GLOBAL quack_authorization_function = 'read_only'; For m...STS (SELECT 1 FROM quack_tokens WHERE auth_token = client_token) ); CREATE MACRO read_only(sid, query) AS ( regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN)\b') ); CALL quack_serve('quack:localhost', token = 'analytics-team-token'); SET...( SELECT 1 FROM quack_sessions s JOIN quack_user_acls a ON a.user_name = s.user_name WHERE s.sid = sid AND regexp_matches(upper(trim(query)), '^' || a.query_kind || '\b') ) ); SET GLOBAL quack_authorization_function = 'acl_check';... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Python Client API 9132
- 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
...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 earlier API's names for the same two bo...tandard deviation. SQL: stddev_samp . str ( ) → StrExpr This expression with the string functions in scope, col(“s”).str().upper() ; nothing is checked or cast. string_agg ( * args : ValueOrExpr ) → Expression The values joined as text. Pass the separ...RCHAR']), 'unbin': ('unbin', 0, ['VARCHAR']), 'unhex': ('unhex', 0, ['VARCHAR']), 'unicode': ('unicode', 0, ['VARCHAR']), 'upper': ('upper', 0, ['VARCHAR']), 'url_decode': ('url_decode', 0, ['VARCHAR']), 'url_encode': ('url_encode', 0, ['VARCHAR'])} M... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Iceberg Functions 9132
- 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
...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/iceberg/lineitem_ice...n 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 iceberg_load_table_r...on, 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 , snapshot_from_timestam... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Aggregate Functions 8733
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...irs representing buckets and counts. histogram(arg, boundaries) Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A bou...her_bin . histogram_values(source, col_name, technique, bin_count) A table macro (not an aggregate function) returning the upper boundary of each bin and its count for a column; see the detailed entry for the available technique values. last(arg) Retu...ple | histogram(A) | histogram(arg, boundaries) | Description | Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype. A bou... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Comparisons 8317
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...n_result separate_result true false For the expression BETWEEN x AND y , x is used as the lower bound and y is used as the upper bound. Therefore, if x > y , the result will always be false .... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Unit Tester Configuration 7711
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...} Environment Variables Most Configuration Options can also be set as environment variables, prefixed with DUCKDB_TEST_ , upper-cased with underscores: Example: DUCKDB_TEST_CHECKPOINT_ON_SHUTDOWN=1 unittest Configuration Options List The following co... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Friendly SQL 7711
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...ing) , e.g.: FROM 'my-data/part-*.parquet' Functions and Expressions Dot operator for function chaining : SELECT ('hello').upper() String formatters: the format() function with the fmt syntax and the printf() function List comprehensions List slicing... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
DuckDB 2.0 Documentation / man.mtool.work