Re: Query on JSON Object

2013-02-06 Thread James Taylor
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 Spag

Re: Query on JSON Object

2013-02-06 Thread Jean-Marc Spaggiari
Hi Vasaprasad, Is it the same question that your collegue already asked there: http://goo.gl/tx13I ? JM 2013/2/6, Bryan Beaudreault : > 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.t

Re: Query on JSON Object

2013-02-05 Thread Bryan Beaudreault
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,

Query on JSON Object

2013-02-05 Thread varaprasad . bheri
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 1home xxx 2office y y y How to put Json object i