Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of shahab.yunus@gmail.com
 designates 209.85.214.52 as permitted sender)
MIME-Version: 1.0
Date: Fri, 12 Jul 2013 11:13:41 -0400
Message-ID: 
 <CAEo-6+TFWr+F5jwfuu0EyMcyzkBP3CsE930zWhLpfAWB0osDbQ@mail.gmail.com>
Subject: Representation of dynamically added columns in table (column family)
 schema using cqlsh
From: Shahab Yunus <shahab.yunus@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=485b3979db80c4bef404e151f478

--485b3979db80c4bef404e151f478
Content-Type: text/plain; charset=ISO-8859-1

A basic question and it seems that I have a gap in my understanding.

I have a simple table in Cassandra with multiple column families. I add new
columns to each of these column families on the fly. When I view (using the
'DESCRIBE table' command) the schema of a particular column family, I see
only one entry for column (bolded below). What is the reason for that? The
column that I am adding have string names and byte values, written using
Hector 1.1-3 (
HFactory.createColumn(...) method).

CREATE TABLE mytable (
  key text,
  *column1* ascii,
  value blob,
  PRIMARY KEY (key, column1)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  read_repair_chance=1.000000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'SnappyCompressor'};

cqlsh 3.0.2
Cassandra 1.2.5
CQL spec 3.0.0
Thrift protocol 19.36.0


Given this, I can also only query on this one column1 or value using the
'SELECT' statement.

The OpsCenter on the other hand, displays multiple columns as
expected. Basically the demarcation of multiple columns i clearer.

Thanks a lot.

Regards,
Shahab

--485b3979db80c4bef404e151f478
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">A basic question and it seems that I have a gap in my unde=
rstanding.<div><br></div><div>I have a simple table in Cassandra with multi=
ple column families. I add new columns to each of these column families on =
the fly. When I view (using the &#39;DESCRIBE table&#39; command) the schem=
a of a particular column family, I see only one entry for column (bolded be=
low). What is the reason for that? The column that I am adding have string =
names and byte values, written using Hector=A01.1-3 (<br>
HFactory.createColumn(...) method).<div><br></div><div><div>CREATE TABLE my=
table (<br></div><div style><div>=A0 key text,</div><div>=A0 <b>column1</b>=
 ascii,</div><div>=A0 value blob,</div><div>=A0 PRIMARY KEY (key, column1)<=
/div>
<div>) WITH COMPACT STORAGE AND</div><div>=A0 bloom_filter_fp_chance=3D0.01=
0000 AND</div><div>=A0 caching=3D&#39;KEYS_ONLY&#39; AND</div><div>=A0 comm=
ent=3D&#39;&#39; AND</div><div>=A0 dclocal_read_repair_chance=3D0.000000 AN=
D</div><div>
=A0 gc_grace_seconds=3D864000 AND</div><div>=A0 read_repair_chance=3D1.0000=
00 AND</div><div>=A0 replicate_on_write=3D&#39;true&#39; AND</div><div>=A0 =
populate_io_cache_on_flush=3D&#39;false&#39; AND</div><div>=A0 compaction=
=3D{&#39;class&#39;: &#39;SizeTieredCompactionStrategy&#39;} AND</div>
<div>=A0 compression=3D{&#39;sstable_compression&#39;: &#39;SnappyCompresso=
r&#39;};</div><div><br></div><div><div>cqlsh 3.0.2=A0</div><div>Cassandra 1=
.2.5</div><div>CQL spec 3.0.0</div><div>Thrift protocol 19.36.0</div></div>=
<div>
<br></div><div><br></div><div style>Given this, I can also only query on th=
is one column1 or value using the &#39;SELECT&#39; statement.</div><div sty=
le><br></div><div style>The OpsCenter on the other hand, displays multiple =
columns as expected.=A0Basically=A0the demarcation of multiple columns i cl=
earer.</div>
<div style><br></div><div style>Thanks a lot.</div><div style><br></div><di=
v style>Regards,</div><div style>Shahab</div></div></div></div></div>

--485b3979db80c4bef404e151f478--