title: How to do MD5 hashing of as string in athena?
body: <p>MD5 hashing function in athena is not working for string. However, athena's document shows that it does : <a href="https://docs.aws.amazon.com/redshift/latest/dg/r_MD5.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/redshift/latest/dg/r_MD5.html</a></p>
  
  <p>Not sure what I am missing here. If I transform varchar to varbinary then the hash that gets generated are not correct.</p>
  
  <p>Getting this error : </p>
  
  <pre><code>
  SYNTAX_ERROR: line 1:8: Unexpected parameters (varchar(15)) for function md5. Expected: md5(varbinary)
  
  This query ran against the "temp" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: dd959e8a-7fa4-4170-8895-ce7cf58be6ea.```
  </code></pre>