HI @Aidan Condron, If you're not bulk loading, you can upload to HBase through Hive. Head to Hive through Ambari. You can upload your .csv files to HDFS, I use the tmp folder. Then use the following in Hive, create table MyTable (col_value STRING);
LOAD DATA INPATH '/tmp/MyData.csv' OVERWRITE INTO TABLE MyTable;
CREATE TABLE MyHiveTable (FirstName STRING, LastName STRING);
insert overwrite table MyHiveTable
SELECT
regexp_extract(col_value, '^(?:([^,]*)\,?){1}', 1) FirstName,
regexp_extract(col_value, '^(?:([^,]*)\,?){2}', 1) LastName
from MyTable;
CREATE TABLE MyHBaseTable(firstname STRING, lastname STRING)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key, f:c1')
TBLPROPERTIES ('hbase.table.name' = 'MyNamesTable');
FROM MyHiveTable INSERT INTO TABLE MyHBaseTable
Select MyHiveTable.*; It's not a fast method, but the Regex and intermediary stages are useful if you need to additional control over your data before it goes into HBase
... View more
