hive常用命令

一、添加hive自定义函数

add jar /opt/cloudera/parcels/CDH/lib/hive/lib/bhdp-base-0.0.2.jar;

create temporary function decode_order_moblie as 'com.baihe.hadoop.hive.udf.DecodeOrderMobile';


select mobile,decode_order_moblie(mobile) 
from bhdp.extend_order
where payTime>='2014-04-23'
and mobile is not null
limit 100;


drop temporary function decode_order_moblie;