Spaarsh commented on issue #14044: URL: https://github.com/apache/datafusion/issues/14044#issuecomment-2616461779
@alamb @HectorPascual these are the final query outputs. I have added support for individual values of the types ```Utf8```, ```Int32```, ```Int64```, ```UInt32``` and ```UInt64```. ``` > SELECT xxhash64('1') AS xxhash64_result; +------------------+ | xxhash64_result | +------------------+ | b7b41276360564d4 | +------------------+ 1 row(s) fetched. Elapsed 0.004 seconds. ``` ``` > SELECT xxhash64(1) AS xxhash64_result; +------------------+ | xxhash64_result | +------------------+ | b7b41276360564d4 | +------------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` ``` > SELECT xxhash32('1') AS xxhash32_result; +-----------------+ | xxhash32_result | +-----------------+ | b6ecc8b2 | +-----------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` ``` > SELECT xxhash32(1) AS xxhash32_result; +-----------------+ | xxhash32_result | +-----------------+ | b6ecc8b2 | +-----------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` ``` > SELECT xxhash32('foobar') AS xxhash32_result; +-----------------+ | xxhash32_result | +-----------------+ | eda34aaf | +-----------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` ``` > SELECT xxhash64(12345678901234567890) AS xxhash64_result; +------------------+ | xxhash64_result | +------------------+ | ebab9f9f8b4ae622 | +------------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` ``` > SELECT xxhash32(12345678901234567890) AS xxhash32_result; +-----------------+ | xxhash32_result | +-----------------+ | 2d0c3d1b | +-----------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` If this is alright, then I will add the tests for these functions. > Perhaps consider adding a non cryptographic module and add wyhash as well (here some of the crates I've used for similar usecase but in polars: https://github.com/ion-elgreco/polars-hash/blob/main/polars_hash%2FCargo.toml) @alamb should I open a new issue for adding wyhash and the other functions? Or they can be added along with this PR? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org