hive 建立表结构，添加分区

最新推荐文章于 2023-03-27 09:58:35 发布

冥想者-定

最新推荐文章于 2023-03-27 09:58:35 发布

阅读量1.3k

点赞数

分类专栏： __Hive

__Hive 专栏收录该内容

66 篇文章 1 订阅

订阅专栏

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types

drop table appuserprofile ;

CREATE EXTERNAL TABLE `appuserprofile`(

`mark` string,

`appkey` string,

`idfa` string,

`imei` string,

`androidid` string,

`mac` string,

`active_timestamp` bigint,

`active_hour` int,

`tbl_start_timestamp` bigint,

`tbl_start_hour` int,

`last_start_timestamp` bigint,

`last_start_hour` int,

`total_start_num` int,

`current_day_start_num` int,

`history_start_days_num` int,

`total_visit_app_time` int,

`is_update_appversion` int,

`appversion` string,

`channelid` string,

`countryid` string,

`provinceid` string,

`cityid` string,

`devicetype` string,

`screen` string,

`osversion` string,

`sp` string,

`network` string,

`brand` string,

`insert_timestamp` bigint,

`events` ARRAY<STRING>,

`current_hour_start_num` int

)

PARTITIONED BY (

`dt` string)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY '\t'

COLLECTION ITEMS TERMINATED BY ','

STORED AS INPUTFORMAT

'org.apache.hadoop.mapred.SequenceFileInputFormat'

OUTPUTFORMAT

'org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat'

LOCATION

'hdfs://SHYF-H11-BH03:52310/bh/warehouse/mobile_tracking'

TBLPROPERTIES (

'transient_lastDdlTime'='1439198366');

alter table appuserprofile add if not exists partition (dt='2016042700') location '/bh/warehouse/mobile_tracking/AppUserProfileAddDurationJob/2016042700';

select events from appuserprofile where size( events) >1 limit 10;

hive -e "alter table appuserprofile add if not exists partition (dt='2016042600') location '/bh/warehouse/mobile_tracking/AppUserProfileAddDurationJob/2016042600’";