Results of 1 - 7 of about 7 for normalize (0.006 sec.)
- Variant Functions 12959
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...iant_comparator(v) Return a binary sort key that orders a VARIANT value by the logical ordering of VARIANT values. variant_normalize(v) Return a canonical representation of a VARIANT value, so that values representing the same data share the same form. va...olumn matches the order of the underlying values: SELECT i FROM range(-2, 2) t(i) ORDER BY i::VARIANT; i -2 -1 0 1 variant_normalize(v) | Description | Return a canonical representation of a VARIANT value. Two VARIANT values that represent the same data n...they were constructed or physically stored. This is useful when comparing or storing VARIANT values. | | Example | variant_normalize({'b': [1, 2, 3], 'a': 42}::VARIANT) | | Result | A normalized VARIANT | variant_group_object(key, value) | Description | A... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- JSON Processing Functions 10178
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...d and added keys appear with their new values, and unchanged keys are omitted. Nested objects are diffed recursively. json_normalize(json) Return json in a canonical form by recursively sorting the keys of every object, including objects nested inside arr...:3}} json_deep_merge accepts any number of patches: SELECT json_deep_merge('{"a": 1}', '{"a": null}', '{"a": 2}'); {"a":2} Normalize the key order of a document, e.g., to compare or hash documents that only differ in key order: SELECT json_normalize('{"c"...: {"b": {"z": 1, "a": 2}, "a": 3}, "a": 4}'); {"a":4,"c":{"a":3,"b":{"a":2,"z":1}}} SELECT md5(json_normalize('{"z": 1, "a": 2}')) = md5(json_normalize('{"a": 2, "z": 1}')) AS same_hash; true Remove null -valued keys recursively: SE... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- Python Client API 9087
- 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
...]), 'ltrim': ('ltrim', 0, ['VARCHAR']), 'md5': ('md5', 0, ['VARCHAR']), 'md5_number': ('md5_number', 0, ['VARCHAR']), 'nfc_normalize': ('nfc_normalize', 0, ['VARCHAR']), 'not_ilike_escape': ('not_ilike_escape', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'not_.... md5_number ( * args : ValueOrExpr ) → Expression Returns the MD5 hash of the string as a HUGEINT . SQL: md5_number . nfc_normalize ( * args : ValueOrExpr ) → StrExpr Converts string to Unicode NFC normalized string. SQL: nfc_normalize . not_ilike_escape...']), 'month': ('month', 0, ['DATE']), 'monthname': ('monthname', 0, ['DATE']), 'nanosecond': ('nanosecond', 0, ['DATE']), 'normalized_interval': ('normalized_interval', 0, ['INTERVAL']), 'part': ('date_part', 1, ['VARCHAR', 'DATE']), 'quarter': ('quarter'... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- CSV Import 8342
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...aracter and double-character line delimiters. Therefore, it does not differentiate between '\r' and '\n' . VARCHAR (empty) normalize_names Normalize column names. This removes any non-alphanumeric characters from them. Column names that are reserved SQL k... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Text Functions 7979
- 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
...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 string to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed betwee...n NFC normalized and not. not_ilike_escape(string, like_specifier, escape_character) Returns false if the string matches the like_specifie...of the MD5 hash of the string as a UBIGINT . | | Example | md5_number_upper('abc') | | Result | 12704604231530709392 | nfc_normalize(string) | Description | Converts string to Unicode NFC normalized string. Useful for comparisons and ordering if text data... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Spatial Functions 7779
- 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
...inestring, produced by combining a collection of input linestrings and adding additional vertices where they intersect. ST_Normalize Returns the "normalized" representation of the geometry ST_NumGeometries Returns the number of component geometries in a c...ext('MULTILINESTRING((0 0, 2 2), (0 2, 2 0))') ); ---- MULTILINESTRING ((0 0, 1 1), (1 1, 2 2), (0 2, 1 1), (1 1, 2 0)) ST_Normalize Signature GEOMETRY ST_Normalize (geom GEOMETRY) Description Returns the "normalized" representation of the geometry ST_Num... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Relational API 7234
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...n omitted. * all_varchar : bool, keyword-only, default: None Read every column as VARCHAR , without detecting the types. * normalize_names : bool, keyword-only, default: None Normalize the column names; for example, My Col becomes my_col . * null_padding... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work