HIVE的分区、hive关联Hbase、UDF函数

Hive and HDFS

                                             原始数据

//建立hive和Hdfs的外部关联表

CREATE EXTERNAL TABLE people(id int,sex string,name string)
partitioned by (logdate string,hour string)
row format delimited fields terminated by ‘,’;

//追加数据

ALTER TABLE people ADD IF NOT EXISTS PARTITION(logdate=20160111,hour=00)
LOCATION ‘/user/yuhui/20160111/00’;