Results of 1 - 10 of about 24 for hash (0.002 sec.)
- Utility Functions 12610
- 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
...lient . getvariable('variable_name') Returns the value of the SQL variable named variable_name , or NULL if it is not set. hash(value) Returns a UBIGINT with a hash of value . The used hash function may change across DuckDB versions. icu_sort_key(str...type(name, ...) Constructs a value of type TYPE from a type name and optional type parameters. md5(string) Returns the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the string as a UHUGEINT . md5_number_lower(string...) Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . md5_number_upper(string) Returns the upper 64-bit segment of the MD5 hash of the string as a... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Blob Functions 11726
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...from_hex(value) Alias for unhex . hex(blob) Converts blob to VARCHAR using hexadecimal encoding. md5(blob) Returns the MD5 hash of the blob as a VARCHAR . md5_number(blob) Returns the MD5 hash of the blob as a HUGEINT . octet_length(blob) Number of b...for more details. repeat(blob, count) Repeats the blob count number of times. sha1(blob) Returns a VARCHAR with the SHA-1 hash of the blob . sha256(blob) Returns a VARCHAR with the SHA-256 hash of the blob . to_base64(blob) Converts a blob to a base...ding. | | Example | hex('\xAA\xBB'::BLOB) | | Result | AABB | | Alias | to_hex | md5(blob) | Description | Returns the MD5 hash of the blob as a VARCHAR . | | Example | md5('\xAA\xBB'::BLOB) | | Result | 58cea1f6b2b06520613e09af90dc1c47 | md5_number(... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Building Configuration 11459
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...e problems. Julia is an example of this. With this flag enabled, the sanitizers are disabled for the build. Overriding Git Hash and Version It is possible to override the Git hash and version when building from source using the OVERRIDE_GIT_DESCRIBE...building from sources that are not part of a complete Git repository (e.g., an archive file with no information on commit hashes and tags). For example: OVERRIDE_GIT_DESCRIBE=v0.10.0-843-g09ea97d0a9 GEN=ninja make Will result in the following output...t Git and Python are optional dependencies for building DuckDB from source. DuckDB normally derives its version and commit hash from Git, so OVERRIDE_GIT_DESCRIBE is primarily useful when building from sources that are not a complete Git checkout. Th... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Text Functions 11025
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...al order. Note that lowercase characters are considered larger than uppercase characters and collations are not supported. hash(value, ...) Returns a UBIGINT with the hash of the value . Note that this is not a cryptographic hash. hex(string) Convert...ces of any of the characters from the left side of the string . characters defaults to space . md5(string) Returns the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the string as a HUGEINT . md5_number_lower(string)...Returns the lower 64-bit segment of the MD5 hash of the string as a UBIGINT . md5_number_upper(string) Returns the upper 64-bit segment of the MD5 hash of the string as a... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Create Synthetic Data 10141
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...s page shows each building block with a runnable example. Generating Rows range functions hash functions, e.g., hash , md5 , sha256 the Faker Python package via the Python function API using cross products (Cartesian...ns the current local timestamp: SELECT today() AS date, get_current_time() AS time, current_localtimestamp() AS timestamp; Hashing Hash functions such as hash , md5 and sha256 turn a row number into a deterministic pseudo-random value, which is usefu...l when you want reproducible identifiers: SELECT hash(i) AS id, md5(i::VARCHAR) AS token FROM range(3) t(i); Repeating Strings repeat(string, count) builds a string by repeatin... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Result Verification 8557
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...84 UNION ALL SELECT 10, 20; ---- 42 84 10 20 # value-wise query II SELECT 42, 84 UNION ALL SELECT 10, 20; ---- 42 84 10 20 Hashes and Outputting Values Besides direct result verification, the sqllogic test suite also has the option of using MD5 hashe...s for value comparisons. A test using hashes for result verification looks like this: query I SELECT g, string_agg(x,',') FROM strings GROUP BY g ---- 200 values has...oach is useful for reducing the size of tests when results have many output rows. However, it should be used sparingly, as hash values make the tests more difficult to debug if they do break. After it is ensured that the system outputs the correct re... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- EXPLAIN ANALYZE: Profile Queries 8557
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
...─────────────────────╮ │ Projections: name │ │ 2 rows 0µs │ ╰────────────────────────────┒┎───────────────────────────╯ ╭─ Hash Join ────────────────┚┖───────────────────────────╮ │ Join Type: INNER │ │ Conditions: sid = sid │ │ 2 rows 0µs │ ╰───────...ors also show the number of row groups scanned and any dynamic filters that were pushed into them at runtime, e.g., by the hash join. See Also For more information, see the ”Profiling” page .... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Load Extensions 8456
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...is set. When installing extensions, a relevant URL will be built that will look like extensions.duckdb.org/$duckdb_version_hash/$duckdb_platform/$name.duckdb_extension.gz . DuckDB-Wasm extension are fetched only on load, and the URL will look like: e...xtensions.duckdb.org/duckdb-wasm/$duckdb_version_hash/$duckdb_platform/$name.duckdb_extension.wasm . Note that an additional duckdb-wasm is added to the folder structure, and t...pository = 'https://some.url.com' , subsequent loads will be attempted at https://some.url.com/duckdb-wasm/$duckdb_version_hash/$duckdb_platform/$name.duckdb_extension.wasm . Note that GET requests for the extensions must be CORS enabled for a browse... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Analyzing a Git Repository 7756
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...CSV ?SV: CREATE TABLE commits AS FROM read_csv( 'git-log.csv', delim = '?', header = false, column_names = ['timestamp', 'hash', 'author', 'message'] ); This will result in a nice DuckDB table: FROM commits LIMIT 5; ┌──────────────────────────┬─────...───────┬──────────────────┬───────────────────────────────────────────────────────────────────────────────┐ │ timestamp │ hash │ author │ message │ │ timestamp with time zone │ varchar │ varchar │ varchar │ ├──────────────────────────┼────────────┼─... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Versioning of Extensions 7672
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...es regarding their current stability, or their goals of becoming stable. Unstable extensions are tagged with the short git hash of the extension. For example, an unstable extension may have a version such as 690bfc5 . What to expect from an extension...has a version number in the unstable format? The state of the source code of the extension can be found by looking up the hash in the extension repository Functionality may change or be removed completely with every release This extension's API coul... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
DuckDB 2.0 Documentation / man.mtool.work