HRezaei/hamming_distance.sql

Created November 6, 2016 16:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/HRezaei/15efdaebac3b4d93d52a80f0b9661c19.js"></script>
Save HRezaei/15efdaebac3b4d93d52a80f0b9661c19 to your computer and use it in GitHub Desktop.

Download ZIP

Computes hamming distance of two hexadecimal integers

Raw

hamming_distance.sql

select bit_count((conv('7c0c8e868ee0e988', 16, 10) ^ conv('183e3c1c1e587e02', 16, 10)))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment