Results of 1 - 10 of about 14 for encoded (0.003 sec.)
- Spatial Functions 12183
- 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
...eomFromGeoJSON Deserializes a GEOMETRY from a GeoJSON fragment. ST_GeomFromHEXEWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFromHEXWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFromText Deserialize a GEOMETRY fro...m a WKT encoded string ST_GeomFromWKB Deserializes a GEOMETRY from a WKB encoded blob ST_GeometryType Returns a GEOMETRY_TYPE enum identif...put line geometry, optionally taking direction into account. ST_LineString2DFromWKB Deserialize a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substring of a line between two fractions of total 2D length. ST_LocateAlong Returns a poi... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Blob Functions 12183
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...ring) Converts the string to BLOB . Converts UTF-8 characters into literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . hex(blob) Co...the blob . sha256(blob) Returns a VARCHAR with the SHA-256 hash of the blob . to_base64(blob) Converts a blob to a base64 encoded string. to_hex(blob) Alias for hex . unbin(value) Converts a value from binary representation to a blob. unhex(value) Conv...| encode('my_string_with_ü') | | Result | my_string_with_\xC3\xBC | from_base64(string) | Description | Converts a base64 encoded string to a character string ( BLOB ). | | Example | from_base64('QQ==') | | Result | A | hex(blob) | Description | Conver... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Text Types 10888
- In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string
...= 10) -- val has a maximum length of 10 ); The VARCHAR field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Specifying a Compression Type You can specify a compression type for a string with the USING COMPRESSION clause.... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- DuckLake 9382
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...ake catalog name catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE...ke catalog named catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type table_name VARCHAR schema_id BIGINT table_id BIGINT table_... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Writing to Iceberg 8752
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...on vectors. In v2 tables, DuckDB-Iceberg writes positional deletes as Parquet files; in v3 tables, the same information is encoded as a much more compact binary deletion vector ( Puffin file ). DuckDB picks the right format automatically based on the ta...and DELETE The UPDATE and DELETE operations have the following limitations: DuckDB-Iceberg only writes positional deletes (encoded as binary deletion vectors for v3 tables). Copy-on-write functionality is not yet supported. DuckDB-Iceberg only supports... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Text Functions 8752
- 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
...uman-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . greatest(arg...n the given base radix , optionally padding with leading zeros to min_length . to_base64(blob) Converts a blob to a base64 encoded string. to_binary(string) Alias for bin . to_hex(string) Alias for hex . translate(string, from, to) Replaces each charact...Result | 15.6 KiB | | Alias | formatReadableSize , pg_size_pretty | from_base64(string) | Description | Converts a base64 encoded string to a character string ( BLOB ). | | Example | from_base64('QQ==') | | Result | A | greatest(arg1, ...) | Descriptio... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Extension Repositories 8314
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...EY----- ...'; Extensions are signed using 2048-bit RSA keys. The key can be provided either in PEM format or as the base64-encoded body of the PEM format. Using a Repository Once a repository is registered, install and load its extensions by referring t... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- Functions 8104
- Function Syntax Function Chaining via the Dot Operator DuckDB supports the dot syntax for function chaining. This allows the function call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...) . For example, take the followi
...qual to width characters when x = max. width defaults to 80 base64 scalar VARCHAR [blob] [BLOB] Convert a blob to a base64 encoded string bin scalar VARCHAR [value] [VARCHAR] Converts the value to binary representation bit_count scalar TINYINT [x] [TINY... - https://man.mtool.work/duckdb/2.0/sql/functions/overview.html
- Azure Extension 7877
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...atures, e.g., SOCKS proxies. On all operating systems, it honors these environment variables: CURL_CA_INFO : path to a PEM encoded file with the certificate authorities for libcurl. It is known to work only on Linux and may fail on other platforms. CURL..._CA_PATH : path to a directory of PEM encoded files with the certificate authorities for libcurl. Example: SET azure_http_stats = false; SET azure_read_transfer_concurr... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Partitioned Writes 7667
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...vailable to build Hive-style paths inside a PARTITION_PATH expression: hive_partition_component(name, value) returns a URL-encoded name=value component. A NULL value produces __HIVE_DEFAULT_PARTITION__ : sql SELECT hive_partition_component('year', 2024)... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
DuckDB 2.0 Documentation / man.mtool.work