Presto如何使用md5

select
 md5(to_utf8(
 concat(
      if(id is null, '-', cast(id as VARCHAR)),
      if(city_id is null, '-', cast(city_id as VARCHAR)),
      if(user_id is null, '-', cast(user_id as VARCHAR)),
      if(type is null, '-', cast(type as VARCHAR))
  )
 )) as record_key 
from
 flow_test.fact_user_model_day
where dt=20190603