pv信息只包含用戶(hù)頁(yè)面瀏覽信息
remains in conflict svn提交錯(cuò)誤解決什黑,先同步腌紧,再備份砸脊,在提交
hiveshow create table表名;查看建表語(yǔ)句信息
hive> show create table sum2_live_terminal;
OK
CREATE TABLE `sum2_live_terminal`(
`dim_oem_id` bigint,
`metric_livemod` int COMMENT '0:live,1:vooletv',
`total_num` bigint,
`playnum` bigint,
`playtime` bigint,
`usernum` bigint,
`usernum_new` bigint,
`yes_usernum` bigint,
`lastweek_usernum` bigint,
`lastweek_usernum_new` bigint,
`lastmonth_usernum` bigint,
`lastmonth_usernum_new` bigint,
`authuser` bigint,
`authnum` bigint)
PARTITIONED BY (
`day` string,
`datelevel` int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT