fthash.md

select feature_hashing(array("userid#4505:3.3","movieid#2331:4.999", "movieid#2331"));

["1828616:3.3","6238429:4.999","6238429"]

SELECT
  features_hashing(
    array_concat(
      categorical_features(
          array('displayurl','adid','advetiserid','userid','gender'),
          displayurl,adid,advetiserid,userid,gender
      ),        
      quantitative_features(
          array('depth','position','age'),
          depth,position,age
      )
    )
  ) as features,
  label
FROM
  source