Results of 1 - 10 of about 11 for footer (0.003 sec.)
- Parquet Encryption 14243
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...After specifying the key (e.g., key256 ), files can be encrypted as follows: COPY tbl TO 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Reading Encrypted Parquet Files An encrypted Parquet file using a specific key (e.g., key256 ), can then...be read as follows: COPY tbl FROM 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Or: SELECT * FROM read_parquet('tbl.parquet', encryption_config = {footer_key: 'key256'}); Interoperabili...ed Parquet files written by the Arrow C++ API (e.g., via PyArrow), as long as the same encryption key is used for both the footer and all columns. Limitations DuckDB's Parquet encryption currently has the following limitations. DuckDB encrypts the foot... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- Extension Distribution 9513
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...m, DuckDB will throw an error and refuse to load the extension. DuckDB stores this compatibility information in a metadata footer appended to the end of the extension binary. Warning Do not run strip on an extension binary. Stripping removes or corrupt...s the appended metadata footer, after which DuckDB reports the metadata as invalid and refuses to load the extension. On some platforms, strip fails outr...ight because the footer extends beyond the binary's segments. Skipping the Compatibility Check For debugging purposes, extension developers can sk... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Output Formats 8873
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...ws human-readable rendering of large numbers. It has three levels: off – All numbers are printed using regular formatting. footer (default) – Large numbers are augmented with the human-readable format. Only applies to single-row results. all - All larg...──────────────┐ │ x │ │ double │ ├───────────────────┤ │ 3141592653.589793 │ └───────────────────┘ .large_number_rendering footer SELECT pi() * 1_000_000_000 AS x; ┌───────────────────┐ │ x │ │ double │ ├───────────────────┤ │ 3141592653.589793 │ │ (3.... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Querying Parquet Metadata 8784
- 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
...e_name VARCHAR created_by VARCHAR num_rows BIGINT 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 Metadat... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Dot Commands 8588
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...to TABLE . Supports --csv , --json , --parquet options .indexes ⟨TABLE⟩ Show names of indexes .large_number_rendering ⟨all/footer/off⟩ Toggle readable rendering of large numbers (duckbox only, default: footer ) .last Render the last result without trun...value cyan underline .highlight_colors temporal_value red bold .highlight_colors string_value green bold .highlight_colors footer gray The result highlighting can be disabled using .highlight_results off . Shorthands DuckDB's CLI allows using shorthand... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Agent Mode 8321
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...-agent -c "SELECT 42 AS answer;" Output Format In agent mode, DuckDB: Renders results as compact Markdown tables. Prints a footer with the row count and, when the whole result was read, an order-independent hash of the result. Emits errors as JSON on s... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- COPY Statement 8126
- 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
...OPY (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_bytes=76...VARCHAR V1 CHUNK_SIZE Alias for ROW_GROUP_SIZE . BIGINT 122880 KV_METADATA Custom key-value metadata to embed in the file footer, supplied as a STRUCT of keys to values. BLOB values are written as raw bytes; other values are cast to string. STRUCT (em... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Write User Defined Functions 8037
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...ain cargo build does not produce a loadable file: DuckDB requires a file ending in .duckdb_extension with a valid metadata footer. Start from the official extension-template-rs template, whose make debug produces a .duckdb_extension that loads with duc... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Azure Extension 7859
- 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
...ppens. Warning An intermediate commit makes an incomplete file visible to readers. A Parquet file cannot be read until its footer is written at the end, so keep the default 0 for Parquet files and for Delta, Iceberg or DuckLake tables. Writing Large Fi... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Relational API 7770
- 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
...his relation, as text; under Jupyter the default is shown as HTML. preview The first limit rows drawn as a table, with the footer __repr__ prints for the relation. query Run the given SQL query in sql_query on the view named virtual_table_name that ref...ows │ ╰────────────────────╯ preview preview(self, limit: int = 10) -> str The first limit rows drawn as a table, with the footer __repr__ prints for the relation. Parameters limit : int, default: 10 The number of rows to draw. Example import duckdb du... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
DuckDB 2.0 Documentation / man.mtool.work