In BigQuery the MD5 hash function by default stores the hash as type BYTES which results in the following output for our example:

op6QlI9O7lIWj6tfqc+8+A==

If you want to get the actual hash you need to use the TO_HEX() function which outputs:

a29e90948f4eee52168fab5fa9cfbcf8