Demo entry 6687572

hh

   

Submitted by anonymous on Dec 29, 2017 at 04:34
Language: SQL. Code size: 562 Bytes.

-- 点击表
create table if not exists  `smrs.tmp_news_click_history`(
  `pptv_visitor_id` string COMMENT '访客唯一标识', 
  `logon_acct_id` string COMMENT '登录用户唯一标识', 
  `itemid` string COMMENT '物品唯一标识', 
  `clicktime` string COMMENT '访问时间')
COMMENT '体育推荐点击历史记录临时表,从点击数据中提取,每日增量更新'
PARTITIONED BY ( 
  `statis_date` string COMMENT '时间分区')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).