Results of 1 - 10 of about 51 for bytes (0.003 sec.)
- Metrics 16126
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...l_intermediate_rows uint64 rows Cumulative number of intermediate rows produced by the query query.total_intermediate_size_bytes uint64 bytes Cumulative size in bytes of all intermediate results produced by the query query.total_row_groups_scanned uin...em.blocked_thread_time double seconds Time spent waiting for a thread to become available system.peak_buffer_memory uint64 bytes Peak memory usage of the buffer manager system.peak_streaming_buffer_size uint64 bytes Peak number of bytes a streaming qu...ery result held: queued bytes plus the units blocked workers hold, both exact. Units still under construction are not counted system.peak_temp_dir_size... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- COPY Statement 10356
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ent: COPY (SELECT l_orderkey, l_comment FROM lineitem) TO 'lineitem_part.parquet' (RETURN_STATS); filename count file_size_bytes footer_size_bytes column_statistics partition_keys lineitem_part.parquet 600572 8579141 1445 {'"l_comment"'={column_size_b...ytes=7642227, max=zzle. slyly, min=' Tiresias above the blit', null_count=0}, '"l_orderkey"'={column_size_bytes=935457, max=600000, min=1, null_count=0}} NULL Note: for nested columns (e.g., structs) the column statistics are defined...Only has an effect when used with options that write multiple files, such as PARTITION_BY , PER_THREAD_OUTPUT or FILE_SIZE_BYTES . BOOL false OVERWRITE When true , all existing files inside targeted directories will be removed (not supported on remote... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Blob Type 10041
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...ata with no restrictions. What the actual bytes represent is opaque to the database system. Create a BLOB value with a single byte (170): SELECT '\xAA'::BLOB; Create a BL...OB value with three bytes (170, 171, 172): SELECT '\xAA\xAB\xAC'::BLOB; Create a BLOB value with two bytes (65, 66): SELECT 'AB'::BLOB; A BLOB value...g of hexadecimal digits prefixed with X . The number of hex digits must be even. For example, create a BLOB value with two bytes (202, 254): SELECT X'CAFE'; New Starting with DuckDB 2.0, X'…' literals are BLOB values. In earlier versions, X'CAFE' was... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Numeric Types 9396
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...pts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHORT - 2^15 2^15 - 1 2 INTEGER INT4 , INT32 , INT , SIGNED - 2^31 2^...NT2 , INT4 and INT8 for signed integers were inherited from PostgreSQL, where digits in these names indicate their size in bytes , whereas the type aliases for their unsigned equivalents, UINT8 , UINT16 , UINT32 and UINT64 , indicate their size in bit...common that the numbers in the minimum and maximum range all have the same storage size, UTINYINT is 1 byte, SMALLINT is 2 bytes, etc. But sometimes you need numbers that are even bigger than what is supported by a HUGEINT ! In these situations, you c... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Configuration 8932
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...y that the block allocator is allowed to use. This memory is allocated once, never freed, and cannot be reduced. VARCHAR 0 bytes ca_cert_file Path to a custom certificate file for self-signed certificates. VARCHAR cache_local_files Whether the externa...nly be set at startup, not while the database is running. VARCHAR external_file_cache_local_max_block_size Maximum size in bytes of an external file cache block for local (non-remote) files. Larger reads are split into blocks of this size, which are f...etched in parallel. UBIGINT 16384 external_file_cache_remote_max_block_size Maximum size in bytes of an external file cache block for remote files (e.g., HTTP/S3). Larger reads are split into blocks of this size, which a... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- SQL Quirks 8527
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...widths: UINT8 corresponds to UTINYINT because it's an 8-bit unsigned integer INT8 corresponds to BIGINT because it's an 8-byte signed integer Explanation: the n in the numeric type INTn and UINTn denote the width of the number in either bytes or bits.... INT1 , INT2 , INT4 correspond to the number of bytes, while INT16 , INT32 and INT64 correspond to the number of bits. The same applies to UINT values. However, the value n = 8...is a valid choice for both the number of bits and bytes. For unsigned values, UINT8 corresponds to UTINYINT (8 bits). For signed values, INT8 corresponds to BIGINT (8 bytes). Exp... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Iceberg Functions 8212
- 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
...id , is_default , field_id , name , transform , source_id and source_column . SELECT file_path, record_count, file_size_in_bytes FROM iceberg_files(my_datalake.default.t); SELECT * FROM iceberg_partition_specs(my_datalake.default.t); iceberg_scan_plan...ding position and equality deletes. It returns the columns rewritten_data_files_count , added_data_files_count , rewritten_bytes_count , failed_data_files_count and removed_delete_files_count . Parameter Type Default Description target_file_size_bytes...VARCHAR or integer The table's write.target-file-size-bytes property, or 512 MiB The target size of the rewritten files. min_file_size_bytes VARCHAR or integer 75% of the target file... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Reference 8212
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...ttings control how results and inserted data are batched and buffered. Setting Type Default Description quack_target_batch_bytes UBIGINT 33554432 (32 MiB) Target in-memory size of one batch (one wire message payload). Batches are cut when they reach t...of FETCH requests the client keeps in flight ahead of the scan. 0 uses the number of async threads. quack_rebalance_buffer_bytes UBIGINT 0 Pending bytes the batch rebalancer buffers before gating non-minimum producers. 0 means automatic, governed by t...he memory manager. quack_server_stream_buffer_bytes UBIGINT 268435456 (256 MiB) Server-side per-stream byte budget, at most a quarter of memory_limit . FETCH counts serialize... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Utility Functions 8063
- 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
.... nullif(a, b) Return NULL if a = b , else return a . Equivalent to CASE WHEN a = b THEN NULL ELSE a END . parse_formatted_bytes(string) Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on inval...'abc') | | Result | 152195979970564155685860391459828531600 | md5_number_lower(string) | Description | Returns the lower 8 bytes of the MD5 hash of string as a UBIGINT . | | Example | md5_number_lower('abc') | | Result | 8250560606382298838 | md5_numb...er_upper(string) | Description | Returns the upper 8 bytes of the MD5 hash of string as a UBIGINT . | | Example | md5_number_upper('abc') | | Result | 12704604231530709392 | nextval... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Querying Parquet Metadata 7898
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...tadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_rows BIGINT row_group_num_columns BIGINT row_group_bytes BIGINT column_id BIGINT file_offset BIGINT num_values BIGINT path_in_schema VARCHAR type VARCHAR stats_min VARCHAR stats_m...BLOB) bloom_filter_offset BIGINT bloom_filter_length BIGINT min_is_exact BOOLEAN max_is_exact BOOLEAN row_group_compressed_bytes BIGINT Parquet Schema The parquet_schema function can be used to query the internal schema contained within a Parquet file...INT num_row_groups BIGINT format_version BIGINT encryption_algorithm VARCHAR footer_signing_key_metadata VARCHAR file_size_bytes UBIGINT footer_size UBIGINT column_orders VARCHAR[] Parquet Key-Value Metadata The parquet_kv_metadata function can be use... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
DuckDB 2.0 Documentation / man.mtool.work