2 Temmuz 2013 Salı

Hive-Hbase Mapping For Nutch webpage Table


CREATE EXTERNAL TABLE webpage_h(
key string,
baseUrl string,
status int,
prevFetchTime bigint,
fetchtime bigint,
fetchInterval int,
retriesSinceFetch int,
reprUrl string,
content string,
contentType string,
protocolStatus int,
modifiedTime bigint,
prevModifiedTime bigint,
batchId string,
title string,
text string,
parseStatus int,
signature string,
prevSignature string,
score float,
language string
) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = ":key,f:bas,f:st#b,f:pts#b,f:ts#b,f:fi#b,f:rsf#b,f:rpr,f:cnt,f:typ,f:prot#b,f:mod#b,f:pmod#b,f:bid,p:t,p:c,p:st#b,p:sig,p:psig,s:s#b,mtdt:language") TBLPROPERTIES ("hbase.table.name" = "webpage");

Hiç yorum yok:

Yorum Gönder