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

Switch to Threaded View
HBase, mail # user - Regarding Rowkey and Column Family


Copy link to this message
-
Re: Regarding Rowkey and Column Family
Mohammad Tariq 2012-12-26, 15:39
I would rather serialize the JSON object into a byte array and then store
it into an HBase cell. Later whenever I need to pull out some value, I can
deserialize it and get the result.

If you know the column name in advance, you can use the QualifierFilter to
get the rows.

Best Regards,
Tariq
+91-9741563634
https://mtariq.jux.com/
On Wed, Dec 26, 2012 at 8:35 PM, Ramasubramanian Narayanan <
[EMAIL PROTECTED]> wrote:

> Hi,
>
> Thanks a lot... Can you please help me a sample code how to insert & read
> Json object in HBase...
>
> Also how  to select the particular row from column (inserted thru Json
> sobject).
>
> Have given the script based on  google'ng we did... Please help in using
> this script how to use in HBase shell script also in Java..
>
>
> -----------------------------
> { "Customer": {
> "Customer Detail": [
> {"CustomerNumber": "10000000001",
>         "DOB": "01/01/01",
>         "Fname": "Fname1",
>         "Mname": "Mname1",
>         "Lname": "Lname1",
> "address": {
>         "AddressType": "Home",
>       "AddressLine1" :"1.1.Address Line1",
>     "AddressLine2" :"1.1.Address Line2",
>       "AddressLine3" :"1.1.Address Line3",
>       "AddressLine4" :"1.1.Address Line4",
>      "State" :"1.1.State",
>     "City" :"1.1.City",
>       "Country" :"1.1.Country"
>       }
> },
>     { "CustomerNumber": "10000000002",
>         "DOB": "01/02/01",
>         "Fname": "Fname2",
>         "Mname": "Mname2",
>         "Lname": "Lname2",
> "address": [{
>         "AddressType": "Home",
>       "AddressLine1" :"2.1.Address Line1",
>     "AddressLine2" :"2.1.Address Line2",
>       "AddressLine3" :"2.1.Address Line3",
>       "AddressLine4" :"2.1.Address Line4",
>      "State" :"2.1.State",
>     "City" :"2.1.City",
>       "Country" :"2.1.Country"
>       },
>   {
>         "AddressType": "Office",
>       "AddressLine1" :"2.2.Address Line1",
>     "AddressLine2" :"2.2.Address Line2",
>       "AddressLine3" :"2.2.Address Line3",
>       "AddressLine4" :"2.2.Address Line4",
>      "State" :"2.2.State",
>     "City" :"2.2.City",
>       "Country" :"2.2.Country"
>       }
> ]
>
>       },
>       { "CustomerNumber": "10000000003",
>         "DOB": "01/03/01",
>         "Fname": "Fname3",
>         "Mname": "Mname3",
>         "Lname": "Lname3",
> "address": [{
>         "AddressType": "Home",
>       "AddressLine1" :"3.1.Address Line1",
>     "AddressLine2" :"3.1.Address Line2",
>       "AddressLine3" :"3.1.Address Line3",
>       "AddressLine4" :"3.1.Address Line4",
>      "State" :"3.1.State",
>     "City" :"3.1.City",
>       "Country" :"3.1.Country"
>       },
>   {
>         "AddressType": "Office",
>       "AddressLine1" :"3.2.Address Line1",
>     "AddressLine2" :"3.2.Address Line2",
>       "AddressLine3" :"3.2.Address Line3",
>       "AddressLine4" :"3.2.Address Line4",
>      "State" :"3.2.State",
>     "City" :"3.2.City",
>       "Country" :"3.2.Country"
>       },
>   {
>         "AddressType": "Others",
>       "AddressLine1" :"3.3.Address Line1",
>     "AddressLine2" :"3.3.Address Line2",
>       "AddressLine3" :"3.3.Address Line3",
>       "AddressLine4" :"3.3.Address Line4",
>      "State" :"3.3.State",
>     "City" :"3.3.City",
>       "Country" :"3.3.Country"
>       }
> ]
>       },
>       { "CustomerNumber": "10000000004",
>         "DOB": "01/04/01",
>         "Fname": "Fname4",
>         "Mname": "Mname4",
>         "Lname": "Lname4",
> "address": [{
>         "AddressType": "Home",
>       "AddressLine1" :"4.1.Address Line1",
>     "AddressLine2" :"4.1.Address Line2",
>       "AddressLine3" :"4.1.Address Line3",
>       "AddressLine4" :"4.1.Address Line4",
>      "State" :"4.1.State",
>     "City" :"4.1.City",
>       "Country" :"4.1.Country"
>       },
>   {
>         "AddressType": "Office",
>       "AddressLine1" :"4.2.Address Line1",
>     "AddressLine2" :"4.2.Address Line2",
>       "AddressLine3" :"4.2.Address Line3",
>       "AddressLine4" :"4.2.Address Line4",
>      "State" :"4.2.State",