Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> Query on JSON Object

Copy link to this message
Re: Query on JSON Object
You can use a utility like this one to convert from JSON to CSV (https://github.com/zeMirco/json2csv) and then Phoenix (https://github.com/forcedotcom/phoenix) to create a table and upload the CSV into HBase (see bin/psql.sh or CSVLoader.java).


On Feb 6, 2013, at 5:19 AM, "Jean-Marc Spaggiari" <[EMAIL PROTECTED]> wrote:

> Hi Vasaprasad,
> Is it the same question that your collegue already asked there:
> http://goo.gl/tx13I ?
> JM
> 2013/2/6, Bryan Beaudreault <[EMAIL PROTECTED]>:
>> HBase deals in byte arrays, so simply convert your json string to a byte
>> array on save, and convert back on read.  Use the Bytes.toBytes(String) and
>> Bytes.toString(byte[]) accordingly.
>> I'm not sure what your example is exactly, a representation of two json
>> blobs?
>> Sent from iPhone.
>> On Feb 6, 2013, at 12:54 AM, [EMAIL PROTECTED] wrote:
>>> Hi,
>>> Need to create the data as given below in JSON Object and put the data
>>> into Hbase table using java
>>> ID      Address Type   Address1 Address2 Address3
>>> 1        home                 x            x            x
>>> 2        office                 y           y             y
>>> How to put Json object in hbase table. Please help.
>>> Thanks & Regards,
>>> Varaprasada Reddy
>>> This e-Mail may contain proprietary and confidential information and is
>>> sent for the intended recipient(s) only.  If by an addressing or
>>> transmission error this mail has been misdirected to you, you are
>>> requested to delete this mail immediately. You are also hereby notified
>>> that any use, any form of reproduction, dissemination, copying,
>>> disclosure, modification, distribution and/or publication of this e-mail
>>> message, contents or its attachment other than by its intended recipient/s
>>> is strictly prohibited.
>>> Visit us at http://www.polarisFT.com