hive

  select count(distinct idfa+mac+imei+androidid) from  appuserprofile ;        
 
  concat(nvl(idfa, ''), nvl(mac, ''), nvl(imei, ''), nvl(android_id, ''))
 
   select  concat(nvl(idfa, ''), nvl(mac, ''), nvl(imei, ''), nvl(android_id, ''))  from  appuserprofile where dt='2015122114' limit 10;     
 
   
  alter table AppUserProfile add partition(dt='2015122114') location '/bh/warehouse/mobile_tracking/AppUserProfileAddDurationJob/2015122114';