Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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).

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
>>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB