-Re: Query on JSON Object
James Taylor 2013-02-06, 16:30
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 ?
> 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
>> Sent from iPhone.
>> On Feb 6, 2013, at 12:54 AM, [EMAIL PROTECTED] wrote:
>>> 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