Search Result: checksum - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 3 of about 3 for checksum (0.002 sec.)

Sharing Macros – DuckDB 11868: 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 ... ─────────┤ │ 42k │ └─────────┘ Sharing a Table Macro It's also possible to share table macros. For example, we created the checksum macro as follows: duckdb compute_table_checksum.duckdb CREATE MACRO checksum ( table_name ) AS TABLE SELECT bit_xor ( md5_ ... TALL httpfs ; You can attach to the remote endpoint and use the macro: ATTACH 'https://blobs.duckdb.org/data/compute_table_checksum.duckdb' AS compute_table_checksum_db ; CREATE TABLE stations AS FROM 'https://blobs.duckdb.org/stations.parquet' ; .mode l ... ine FROM compute_table_checksum_db. checksum ( 'stations' ); id = -132780776949939723506211681506129908318 code = 126327004005066229305810236187733612209 ...; https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html

CREATE MACRO Statement – DuckDB 8426: 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 ... define macros on arbitrary tables, use the query_table function . For example, the following macro computes a column-wise checksum on a table: CREATE MACRO checksum ( table_name ) AS TABLE SELECT bit_xor ( md5_number ( COLUMNS ( * ):: VARCHAR )) FROM qu ... ery_table ( table_name ); CREATE TABLE tbl AS SELECT unnest ([ 42 , 43 ]) AS x , 100 AS y ; SELECT * FROM checksum ( 'tbl' ); Overloading It is possible to overload a macro based on the amount of parameters it takes, this works for both ...; https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html

Storage Versions and Format – DuckDB 7571: 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 ... v1.0.0' ); COPY FROM DATABASE file1 TO converted_file ; Storage Header DuckDB files start with a uint64_t which contains a checksum for the main header, followed by four magic bytes ( DUCK ), followed by the storage version number in a uint64_t . hexdump ...; https://man.mtool.work/duckdb/1.3/internals/storage.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work