Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: <1467966367146-4081100.post@n3.nabble.com>
References: <1467966367146-4081100.post@n3.nabble.com>
Date: Fri, 8 Jul 2016 07:18:19 -0500
Message-ID: <CA+DCeTHS79rXY_DA_kL3MH1hOSmXHi22HLKrNjchP+nAK7jEiQ@mail.gmail.com>
Subject: Re: Is it ok to store all integers as Strings instead of byte[] in hbase?
From: Dima Spivak <dspivak@cloudera.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a114dad2a4f498505371eccff
archived-at: Fri, 08 Jul 2016 12:18:33 -0000

--001a114dad2a4f498505371eccff
Content-Type: text/plain; charset=UTF-8

Hey Mahesha,

It might be worthwhile to read through the architecture section of our ref
guide: https://hbase.apache.org/book.html#_architecture

Cheers,
  Dima

On Friday, July 8, 2016, Mahesha999 <abnave.m@gmail.com> wrote:

> I am trying out some hbase code. I realised that when I insert data through
> hbase shell using put command, then everything (both numeric and string) is
> put as string:
>
> hbase(main):001:0> create 'employee', {NAME => 'f'}
> hbase(main):003:0> put 'employee', 'ganesh','f:age',30
> hbase(main):004:0> put 'employee', 'ganesh','f:desg','mngr'
> hbase(main):005:0> scan 'employee'
> ROW                   COLUMN+CELL
> ganesh               column=f:age, timestamp=1467926618738, value=30
> ganesh               column=f:desg, timestamp=1467926639557, value=mngr
>
> However when I put data using Java API, non-string stuff gets serialized as
> byte[]:
>
> Cluster lNodes = new Cluster();
> lNodes.add("digitate-VirtualBox:8090");
> Client lClient= new Client(lNodes);
> RemoteHTable remoteht = new RemoteHTable(lClient, "employee");
>
> Put lPut = new Put(Bytes.toBytes("mahesh"));
> lPut.add(Bytes.toBytes("f"), Bytes.toBytes("age"), Bytes.toBytes(25));
> lPut.add(Bytes.toBytes("f"), Bytes.toBytes("desg"), Bytes.toBytes("dev"));
> remoteht.put(lPut);
>
> Scan in hbase shell shows age 25 of mahesh is stored as \x00\x00\x00\x19:
>
> hbase(main):006:0> scan 'employee'
> ROW                   COLUMN+CELL
> ganesh               column=f:age, timestamp=1467926618738, value=30
> ganesh               column=f:desg, timestamp=1467926639557, value=mngr
> mahesh               column=f:age, timestamp=1467926707712,
> value=\x00\x00\x00\x19
> mahesh               column=f:desg, timestamp=1467926707712, value=dev
>
> *1.* Considering I will be storing only numeric and string data in hbase,
> what benefits it does provide to store numeric data as byte[] (as in case
> of
> above) or as string:
> lPut.add(Bytes.toBytes("f"), Bytes.toBytes("age"), Bytes.toBytes("25"));
> //instead of toBytes(25)
>
> *2.*Also why strings are stored as is and are not serialized to byte[] even
> when put using Java API?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Is-it-ok-to-store-all-integers-as-Strings-instead-of-byte-in-hbase-tp4081100.html
> Sent from the HBase User mailing list archive at Nabble.com.
>

--001a114dad2a4f498505371eccff--