Results of 1 - 9 of about 9 for stats (0.005 sec.)
- Querying Parquet Metadata 12438
- 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
...ns BIGINT row_group_bytes BIGINT column_id BIGINT file_offset BIGINT num_values BIGINT path_in_schema VARCHAR type VARCHAR stats_min VARCHAR stats_max VARCHAR stats_null_count BIGINT stats_distinct_count BIGINT stats_min_value VARCHAR stats_max_value... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Iceberg Functions 11791
- 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
...ns the snapshots of an Iceberg table. iceberg_column_stats(source) Returns per-data-file, per-column statistics of an Iceberg table. iceberg_partition_stats(source) Returns per-part...Iceberg metadata, you can use the iceberg_metadata function: Warning In DuckDB 2.0.0, iceberg_metadata and iceberg_column_stats fail on the sample lineitem_iceberg table with an Invalid Configuration Error about manifest_entry.sequence_number . SELEC...berg_snapshots does not take allow_moved_paths , snapshot_from_id or snapshot_from_timestamp as parameters. iceberg_column_stats The iceberg_column_stats function returns the statistics stored in the manifests for every data file and column. Its colum... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- CREATE VIEW Statement 9688
- The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT
...42; New The SECURE VIEW feature was introduced in DuckDB 2.0. Create a secure view (hides internals from functions such as stats() and EXPLAIN ANALYZE ): CREATE SECURE VIEW users AS SELECT username FROM all_users WHERE access_level = 'standard'; The S...les through statistics or query plans. Regular views can expose data that the view query would filter out (for example via stats() ). Secure views return NULL for those internals and show a Secure View node in EXPLAIN ANALYZE . If a schema name is giv... - https://man.mtool.work/duckdb/2.0/sql/statements/create_view.html
- Geometry Data Type 8124
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...ry types and vertex dimensions that are present within the row group. You can inspect the statistics of a column using the stats() function: CREATE TABLE geometries AS SELECT 'POINT Z (30 10 5)'::GEOMETRY AS geom; SELECT stats(geom) AS geom_stats FROM... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Utility Functions 7980
- 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
...A-256 hash of the string . sleep_ms(milliseconds) Pause execution for the specified number of milliseconds. Returns NULL . stats(expression) Returns a VARIANT with statistics about the expression. Expression can be a column, constant, or SQL expressio...| Pause execution for the specified number of milliseconds. Returns NULL . | | Example | sleep_ms(500) | | Result | NULL | stats(expression) | Description | Returns a VARIANT with statistics about the expression. Expression can be a column, constant,...or SQL expression. | | Example | stats(5) | | Result | {'approx_unique': 1, 'has_no_null': true, 'has_null': false, 'max': 5, 'min': 5} | txid_current() | Descri... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- COPY Statement 7980
- 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
...ritten as part of the COPY statement: 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 1...or each part. For example, if we have a column name STRUCT(field1 INTEGER, field2 INTEGER) the column statistics will have stats for name.field1 and name.field2 . An expression may be used as the target of a COPY ... TO command if it is placed within...LES Whether or not to include the created filepath(s) (as a files VARCHAR[] column) in the query result. BOOL false RETURN_STATS Whether or not to return the files and their column statistics that were written as part of the COPY statement. BOOL false... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Iceberg Options 7855
- 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
...d) marker. Set to 0 to omit the body. Scan Options The following parameters can be passed to iceberg_scan , iceberg_column_stats , iceberg_metadata , iceberg_partition_stats , iceberg_snapshots : Parameter Type Default Description allow_moved_paths BO... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Azure Extension 7729
- 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
...configuration options to control how the extension reads and writes remote files: Name Description Type Default azure_http_stats Include HTTP info from Azure Storage in the EXPLAIN ANALYZE statement . BOOLEAN false azure_http_logging Write Azure HTTP...L_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_concurrency = 5; SET azure_read_transfer_chunk_size = 8_388_608; SET azure_read_buffer_si... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Pragmas 7208
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ge chunk compression VARCHAR Compression type used for this column – see the “Lightweight Compression in DuckDB” blog post stats VARIANT has_updates BOOLEAN persistent BOOLEAN false if temporary table block_id BIGINT Empty unless persistent block_offs... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work