Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of onlinespending@gmail.com
 designates 209.85.192.175 as permitted sender)
From: onlinespending <onlinespending@gmail.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Subject: efficient way to store 8-bit or 16-bit value?
Message-Id: <8DF6CE20-E70E-4107-8EC0-FE344C1D7382@gmail.com>
Date: Wed, 11 Dec 2013 14:42:02 -0800
To: user@cassandra.apache.org
Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\))

What do people recommend I do to store a small binary value in a column? =
I=92d rather not simply use a 32-bit int for a single byte value. Can I =
have a one byte blob? Or should I store it as a single character ASCII =
string? I imagine each is going to have the overhead of storing the =
length (or null termination in the case of a string). That overhead may =
be worse than simply using a 32-bit int.

Also is it possible to partition on a single character or substring of =
characters from a string (or a portion of a blob)? Something like:

CREATE TABLE test (
	id text,
	value blob,
	PRIMARY KEY (string[0:1])
)=20=