HBASE INSERT json

[#1]

Hi:

I need to insert every day 1 json into HBASE, there are any api to do it without schema???

Also i dont want to use HIVE.

Thanks

[#2 · Accepted solution]

you can treat each json as string then in HBase you would do the following where line is a json string. Full example here https://github.com/dbist/workshops/blob/master/hbase/HBaseJsonLoad/src/main/java/com/hortonworks/hba...

p.addColumn(CF, Bytes.toBytes("json"), Bytes.toBytes(line));

[#3]

Hi;

thanks, and them how can i get some keys from the json???

[#4]

You read the string, convert it up json obj and read it. Look at my example how I read the key to make it a row key, you will do the same after calling a Get.

[#5]

Ok, thanks i saw the code, you are right,

and what about autoincrement id row from pig'

[#6]

I see you asked this question in a separate thread, that's the right approach to keep them separate.