Results of 1 - 10 of about 18 for hash (0.004 sec.)
- Utility Functions – DuckDB 13417
- 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
...222f4e14b687 . getenv(var) Returns the value of the environment variable var . Only available in the command line client . hash(value) Returns a UBIGINT with the hash of the value . icu_sort_key(string, collator) Surrogate sort key used to sort speci...equal to the "right-most boundary" of its datatype for the purpose of the histogram function. 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/1.3/sql/functions/utility.html
- Blob Functions – DuckDB 11478
- 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
...decimal representation to a blob. 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...R using hexadecimal encoding. 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(blob) Descript... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Text Functions – DuckDB 11478
- 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
...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/1.3/sql/functions/text.html
- Create Synthetic Data – DuckDB 9368
- 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
...wn Create Synthetic Data DuckDB allows you to quickly generate synthetic data sets. To do so, you may use: range functions hash functions, e.g., hash , md5 , sha256 the Faker Python package via the Python function API using cross products (Cartesian..."random_long_text" , random_long_text , [], VARCHAR , type = "native" , side_effects = True ) res = con . sql ( """ SELECT hash(i * 10 + j) AS id, random_date() AS creationDate, random_short_text() AS short, random_long_text() AS long, IF (j % 2, tru...ows 3 columns │ └───────────────────────────────────────────────┘ 関連キーワード random text date short long fake generate hash Faker import duckdb return create type native side effects functions products chars creationDate series Documentation Guid... - https://man.mtool.work/duckdb/1.3/guides/snippets/create_synthetic_data.html
- Extensions – DuckDB 8527
- 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
...option. 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...ustom_extension_repository = some.url.com , subsequent loads will be attempted at some.url.com/duckdb-wasm/$duckdb_version_hash/$duckdb_platform/$name.duckdb_extension.wasm . Note that GET requests on the extensions needs to be CORS enabled for a bro... - https://man.mtool.work/duckdb/1.3/clients/wasm/extensions.html
- Building Configuration – DuckDB 8527
- 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
...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 ou...YTHON BUILD_SHELL BUILD_BENCHMARK BUILD_JDBC BUILD_ODBC Miscellaneous Flags DISABLE_UNITY DISABLE_SANITIZER Overriding Git Hash and Version... - https://man.mtool.work/duckdb/1.3/dev/building/build_configuration.html
- Result Verification – DuckDB 8441
- 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
...N 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 valu...es hashing to b8126ea73f21372cdb3f2dc483106a12 This approach is useful for reducing the size of tests when results have many outpu... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- Versioning of Extensions – DuckDB 7789
- 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
...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, at the time of writing this, the version of the vss extension is an unstable extension of v...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/1.3/extensions/versioning_of_extensions.html
- Analyzing a Git Repository – DuckDB 7789
- 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
...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 │ varchar │ varchar │ varchar │ ├─────────────────────┼────────────┼──────────────────┼──... - https://man.mtool.work/duckdb/1.3/guides/snippets/analyze_git_repository.html
- Profiling – DuckDB 7704
- 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
..., "Build Min" : "1" , "Build Max" : "3" , "Estimated Cardinality" : "1" }, "operator_cardinality" : 2 , "operator_type" : "HASH_JOIN" , "operator_timing" : 0.00023899999999999998 , "children" : [ ... The second example adds detailed metrics to the ou...opens it in your web browser. python -m duckdb.query_graph /path/to/file.json Notation in Query Plans In query plans, the hash join operators adhere to the following convention: the probe side of the join is the left operand, while the build side is... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
DuckDB 1.3 Documentation / man.mtool.work