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

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


+
varaprasad.bheri@... 2013-02-06, 05:54
+
Bryan Beaudreault 2013-02-06, 06:15
+
Jean-Marc Spaggiari 2013-02-06, 13:18
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).

James

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
>>