Member since
12-31-2020
1
Post
0
Kudos Received
0
Solutions
12-31-2020
11:39 AM
I have loaded data from Hive to HBase. Hive source record has 3000 rows but after loading in Hbase . The HBase table has only 1200 records. I'm not understanding the reason for it. Can anyone explain please. CREATE TABLE events_Hbase( src_util_id int, event_log_id bigint, event_id int, event_text string, partition_date date, load_date date) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:event_log_id ,cf:event_id , cf:event_text , cf:partition_date , cf:load_date") TBLPROPERTIES ("hbase.table.name" = "HbaseEvents"); INSERT INTO TABLE events_Hbase select * from Meterevents; select count(*) from Meterevents --3000(hive source table) select count(*) from events_Hbase ---1200( hbase table) Can someone please explain .
... View more
Labels:
- Labels:
-
Apache HBase