Results of 1 - 10 of about 13 for encode (0.002 sec.)
- Blob Functions 12475
- 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
...trict' (default, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore' (removes invalid characters). encode(string) Converts the string to BLOB . Converts UTF-8 characters into literal encoding. from_base64(string) Converts a base...64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . hex(blob) C...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) Con... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Iceberg Options 11789
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...OLLBACK or retries of the COMMIT . PURGE_REQUESTED BOOLEAN false Sends the PurgeRequested parameter when dropping a table. ENCODE_ENTIRE_PREFIX BOOLEAN false URL-encode the entire path prefix when communicating with the catalog. MAX_TABLE_STALENESS INT...ed into REST Catalog request URLs after /v1/ , for example /v1/⟨prefix⟩/namespaces/… . Catalogs such as AWS Glue use it to encode a warehouse or account/catalog identifier. It is normally discovered from the catalog's configuration response; set it exp...licitly to override. A prefix containing / is split into path components unless ENCODE_ENTIRE_PREFIX is set. NAMESPACE_SEPARATOR VARCHAR 0x1F Separator used to join the levels of a nested namespace into a sing... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Schema 10099
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...ion query that returns the average day-of-the month from the timestamps in two configurations. First, we use a DATETIME to encode the values and run the query using the extract datetime function : SELECT avg(extract('day' FROM creationDate)) FROM Comme... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- PHP Client (PDO) 9413
- The PHP DuckDB PDO extension is a tertiary client and is maintained by a third-party. To use pdo_duckdb , follow the instructions below . The latest version of pdo_duckdb supports DuckDB 2.0.0. pdo_duckdb is a native DuckDB database driver
...ay # ( # [aaa] => aaa # [bbb] => bbb # [ccc] => ccc # ) # ) Read JSON files <?php file_put_contents('/tmp/logs.json', json_encode(['log' => 'log text']) . PHP_EOL, FILE_APPEND); file_put_contents('/tmp/logs.json', json_encode(['log' => 'log text 2']) .... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php_pdo.html
- My Workload Is Slow 9413
- If you find that your workload in DuckDB is slow, we recommend performing the following checks. More detailed instructions are linked for each point. Do you have enough memory? DuckDB works best if you have 1-4 GB memory per thread . Is you
...disabling them , which boosts load and update performance. Are you using the correct types? For example, use TIMESTAMP to encode datetime values . Are you reading from Parquet files? If so, do they have row group sizes between 100k and 1M and file siz... - https://man.mtool.work/duckdb/2.0/guides/performance/my_workload_is_slow.html
- Share a DuckDB Database That Only Stores Views 8745
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...location and format. This is useful for publishing a curated “semantic layer” over a data lake, where the view definitions encode the joins, filters, and column names that consumers should use, without copying or moving the data itself. Prerequisites T... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Quack on WebAssembly 8393
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...ck-demo \ --region us-east-2 \ --query 'Stacks[0].Outputs' \ --output table Now you can visit the relevant link, that will encode connecting to the just created quack server via DuckDB-Wasm. Destroy aws cloudformation delete-stack \ --stack-name my-qua... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Conversion between DuckDB and Python 8058
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...l → DECIMAL / DOUBLE / FLOAT uuid.UUID → UUID The rest of the conversion rules are as follows. str A str that UTF-8 cannot encode, such as one that holds a lone surrogate ( "\ud800" ), raises an InvalidInputException that says it cannot encode str as U... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Partitioned Writes 7724
- 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...avoid clashes). Handling Slashes in Columns To handle slashes in column names, use Percent-Encoding implemented by the url_encode function .... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- Text Functions 7724
- 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(ar...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 charac...string) Converts string to upper case. url_decode(string) Decodes a URL from a representation using Percent-Encoding . url_encode(string) Encodes a URL to a representation using Percent-Encoding . string[index] | Description | Extracts a single charact... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
DuckDB 2.0 Documentation / man.mtool.work