ALTER TABLE table1 DROP PARTITION (day='2015-07-14');ALTER TABLE table1 ADD COLUMNS (visit int); reflect("java.net.URLDecoder", "decode", url,"UTF-8")CASE WHEN b.user_account is null then 0 else b.user_account end