You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Sumanta Gh <su...@tcs.com> on 2016/05/13 11:27:19 UTC
Storage benefits of ARRAY types
Hi,
Do we gain any disk utilization benefit while defining columns as an array?
- Sumanta
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
Re: Storage benefits of ARRAY types
Posted by Sergey Soldatov <se...@gmail.com>.
HI Sumanta,
It's obvious. If it's fixed length, serialized values are stored one by
one. If data type has variable length, than a special separator is inserted
between values.
Thanks,
Sergey
On Wed, May 25, 2016 at 4:07 AM, Sumanta Gh <su...@tcs.com> wrote:
> Hi,
> I found that when a VARCHAR ARRAY is stored in Hbase, lots of extra-bytes
> are also stored as opposed to FLOAT ARRAY. In terms of better disk
> utilization, I think converting non-searchable columns into an ARRAY is
> much more efficient.
>
> Could you please let me know how ARRAY types are stored in HBase.
>
> - Sumanta
>
>
> -----Sumanta Gh <su...@tcs.com> wrote: -----
> To: user@phoenix.apache.org
> From: Sumanta Gh <su...@tcs.com>
> Date: 05/13/2016 04:57PM
> Subject: Storage benefits of ARRAY types
>
>
> Hi,
> Do we gain any disk utilization benefit while defining columns as an array?
>
> - Sumanta
>
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
Re: Storage benefits of ARRAY types
Posted by Sumanta Gh <su...@tcs.com>.
Hi,
I found that when a VARCHAR ARRAY is stored in Hbase, lots of extra-bytes are also stored as opposed to FLOAT ARRAY. In terms of better disk utilization, I think converting non-searchable columns into an ARRAY is much more efficient.
Could you please let me know how ARRAY types are stored in HBase.
- Sumanta
-----Sumanta Gh <su...@tcs.com> wrote: -----
To: user@phoenix.apache.org
From: Sumanta Gh <su...@tcs.com>
Date: 05/13/2016 04:57PM
Subject: Storage benefits of ARRAY types
Hi,
Do we gain any disk utilization benefit while defining columns as an array?
- Sumanta
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you