|
CREATE TABLE LogTable(Key string,IpAddress string,Url string,UserBrowser string,OSstring,AccressTime string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,Info:IpAddress,Info:Url,Info:UserBrowser,Info:OS,Info:AccressTime") TBLPROPERTIES ("hbase.table.name" = "LogTable");
ROW COLUMN+CELL
192.168.1.10 http:// column=Info:IpAddress, timestamp=1406908690106, value=192.
www.aboutyun.com/thr 168.1.10
ead-8472-1-1.html 12
3
1 row(s) in 0.1050 seconds
hive> select * from logtable;
OK
192.168.1.10 http://www.aboutyun.com/thread-8472-1-1.html 123 192.168.1.10 NULL NULL NULL NULL
Time taken: 3.024 seconds, Fetched: 1 row(s)