Search Result: stats - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 5 of about 5 for stats (0.003 sec.)

Querying Parquet Metadata – DuckDB 12777: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... 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 ... es my_file.parquet 0 true … … … my_file.parquet 9 false 関連キーワード parquet metadata Parquet columns schema column type stats used group offset bloom types Metadata query contained within Below table returned Type filter Bloom internal groups 関連す ...; https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html

Utility Functions – DuckDB 8659: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... turns a VARCHAR with the SHA-1 hash of the string . sha256(string) Returns a VARCHAR with the SHA-256 hash of the string . stats(expression) Returns a string with statistics about the expression. Expression can be a column, constant, or SQL expression ... e SHA-256 hash of the string . Example sha256('?') Result d7a5c5e0d1d94c32218539e7e47d4ba9c3c7b77d61332fb60d633dde89e473fb stats(expression) Description Returns a string with statistics about the expression. Expression can be a column, constant, or SQ ... L expression. Example stats(5) Result '[Min: 5, Max: 5][Has Null: false]' txid_current() Description Returns the current transaction's identifier, a B ...; https://man.mtool.work/duckdb/1.3/sql/functions/utility.html

COPY Statement – DuckDB 8659: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... en 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 ... 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 . COPY ... TO Options Zero or more copy options may be provided as a part of the copy oper ... 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/1.3/sql/statements/copy.html

Azure Extension – DuckDB 8254: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ion Use the following configuration options how the extension reads remote files: Name Description Type Default azure_http_stats Include HTTP info from Azure Storage in the EXPLAIN ANALYZE statement . BOOLEAN false azure_read_transfer_concurrency Maxi ... a directory which holds PEM encoded files, containing the certificate authorities sent to libcurl. Example: SET azure_http_stats = false ; SET azure_read_transfer_concurrency = 5 ; SET azure_read_transfer_chunk_size = 1_048_576 ; SET azure_read_buffer ...; https://man.mtool.work/duckdb/1.3/core_extensions/azure.html

Pragmas – DuckDB 7592: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ge chunk compression VARCHAR Compression type used for this column – see the “Lightweight Compression in DuckDB” blog post stats VARCHAR has_updates BOOLEAN persistent BOOLEAN false if temporary table block_id BIGINT Empty unless persistent block_offs ...; https://man.mtool.work/duckdb/1.3/configuration/pragmas.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work