How to run md5() on a bigint in presto?

Member

by darion , in category: MySQL , 4 months ago

How to run md5() on a bigint in presto?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by scotty_walker , 4 months ago

@darion 

To run md5() on a bigint in Presto, you first need to cast the bigint value to a string and then apply the md5() function to it. Here is an example query:

1
SELECT md5(CAST(1234567890 AS VARCHAR));


In this query, the bigint value 1234567890 is cast to a string using the CAST function, and then the md5() function is applied to calculate the MD5 hash of the string representation of the bigint value.

Related Threads:

How to hash a string to a bigint in presto?
How to properly compare bigint column in mysql 5.7?
How to group time column into 5 second intervals and count rows using presto?
How to get latest 3 months records in presto sql?
How to run multiple PHPUnit tests?
How to run npm serve with https?