2013年8月9日星期五

Who knows in the following hadoop project , the following Tablephrases mean ?

CREATE TABLE hbase_orderqueue (key string, ntime int, nside int, nprice int, norders int, nabitems int, itemsdetail string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ": key, a: 1, a: 2, a: 3, a: 4, a: 5, a: 6" ;)
TBLPROPERTIES ("hbase.table.name" = "orderqueue");


About hadoop addition to the above problems, there are some questions , I hope there is an expert answer :
1. we build the table , it is the presence hive inside or hbase inside .
2. an open data is , how to import hdfs in ?
3.hive hbase table of contents and what is the difference ? ? These rather vague ah ! ! !
4. hdfs table how to come out of the warehouse or on the hive hbase in it ?
------ Solution ---------------------------------------- ----


1, the data is present in HBASE
2, HBASE is to establish a database on HDFS , so how the data stored in HDFS, this by the HBASE management .
3, HIVE is MapReduce casing of H-SQL client software is better to use as a data warehouse .
HBASE is a distributed , column stores the NOSQL databases , as online business can be a database , of course, it does not completely replace RDBMS, desirable director bar
4, through HIVE API or HBASE API can be achieved

没有评论:

发表评论