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 jbellis@gmail.com designates
 74.125.82.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=XP/NbHmhZa1PluHCx6yHC5MSgW5s+oktFGvL5yUj6A3DUbyk44Ku1R1wM9kVkzKmBN
         opX5YrfC/irVSEM0GamtO3VJPbRE/rzMTHNQBg5xVkgwa97l0cVDW8AEgTLJUB3Ge6iw
         GSljWMXdRNbYOt9R2WYVma+9zhEqYSeYO8yGI=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=ovLoe6w0Kx3ddJpVMTCK97Nd_WQ@mail.gmail.com>
References: <BANLkTi=ovLoe6w0Kx3ddJpVMTCK97Nd_WQ@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Thu, 16 Jun 2011 09:02:45 -0700
Message-ID: <BANLkTimRaE4bZ3oPGnKpj-vj25MSy7XL-g@mail.gmail.com>
Subject: Re: Unable to access column family in CLI after building CF in CQL
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

If you create CFs outside the cli, you may need to restart it to
refresh its internal cache of the schema.

On Thu, Jun 16, 2011 at 8:51 AM, yikes bigdata <yikes.bigdata@gmail.com> wr=
ote:
> Hi,
> I was following the CQL example on the DataStax website and was able to
> create a new column family and query it. But when I viewed the column fam=
ily
> in the CLI, it gives me the following error.
> # Unable to read column family created from CQL
> [default@store] list users2;
> users2 not found in current keyspace.
> Also, when I try to query the user table from CQL, i'm unable to filter o=
n a
> key. =A0The user table was created in the CLI but accessible by CQL with =
a
> simple select * from users;
> cqlsh> select * from users where key=3D'tyler';
> Bad Request: cannot parse 'tyler' as hex bytes
>
>
>
>
> # In the CLI, the store keyspaces displays two column families .
> [default@store] show keyspaces;
> Keyspace: store:
> =A0 Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
> =A0 =A0 Options: [replication_factor:1]
> =A0 Column Families:
> =A0 =A0=A0ColumnFamily: users
> =A0 =A0 =A0 Key Validation Class: org.apache.cassandra.db.marshal.BytesTy=
pe
> =A0 =A0 =A0 Default column value validator:
> org.apache.cassandra.db.marshal.BytesType
> =A0 =A0 =A0 Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
> =A0 =A0 =A0 Row cache size / save period in seconds: 0.0/0
> =A0 =A0 =A0 Key cache size / save period in seconds: 200000.0/14400
> =A0 =A0 =A0 Memtable thresholds: 0.26718749999999997/57/1440 (millions of
> ops/MB/minutes)
> =A0 =A0 =A0 GC grace seconds: 864000
> =A0 =A0 =A0 Compaction min/max thresholds: 4/32
> =A0 =A0 =A0 Read repair chance: 1.0
> =A0 =A0 =A0 Replicate on write: false
> =A0 =A0 =A0 Built indexes: []
> =A0 =A0 =A0 Column Metadata:
> =A0 =A0 =A0 =A0 Column Name: email
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> =A0 =A0 =A0 =A0 Column Name: userName
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> =A0 =A0=A0ColumnFamily: users2
> =A0 =A0 =A0 Key Validation Class: org.apache.cassandra.db.marshal.UTF8Typ=
e
> =A0 =A0 =A0 Default column value validator:
> org.apache.cassandra.db.marshal.UTF8Type
> =A0 =A0 =A0 Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> =A0 =A0 =A0 Row cache size / save period in seconds: 0.0/0
> =A0 =A0 =A0 Key cache size / save period in seconds: 200000.0/14400
> =A0 =A0 =A0 Memtable thresholds: 0.26718749999999997/57/1440 (millions of
> ops/MB/minutes)
> =A0 =A0 =A0 GC grace seconds: 864000
> =A0 =A0 =A0 Compaction min/max thresholds: 4/32
> =A0 =A0 =A0 Read repair chance: 1.0
> =A0 =A0 =A0 Replicate on write: true
> =A0 =A0 =A0 Built indexes: []
> =A0 =A0 =A0 Column Metadata:
> =A0 =A0 =A0 =A0 Column Name: session_token
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> =A0 =A0 =A0 =A0 Column Name: state
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> =A0 =A0 =A0 =A0 Column Name: password
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> =A0 =A0 =A0 =A0 Column Name: birth_year
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.Lon=
gType
> =A0 =A0 =A0 =A0 Column Name: gender
> =A0 =A0 =A0 =A0 =A0 Validation Class: org.apache.cassandra.db.marshal.UTF=
8Type
> Keyspace: system:
> Able to see the list of keys generate within the CLI
> [default@store] list users;
> Using default limit of 100
> -------------------
> RowKey: foo
> =3D> (column=3Dage, value=3D3339, timestamp=3D1308182349595000)
> =3D> (column=3Demail, value=3Dfoo@email.com, timestamp=3D1308182349594000=
)
> =3D> (column=3DuserName, value=3Dfoo, timestamp=3D1308182349591000)
> -------------------
> RowKey: bar
> =3D> (column=3Demail, value=3Dbar@email.com, timestamp=3D1308182355297000=
)
> =3D> (column=3Dgender, value=3D66, timestamp=3D1308182355299000)
> =3D> (column=3DuserName, value=3Dbar, timestamp=3D1308182355295000)
> -------------------
> RowKey: tyler
> =3D> (column=3Demail, value=3Dtyler@email.com, timestamp=3D13081823553030=
00)
> =3D> (column=3Dsports, value=3D6261736562616c6c, timestamp=3D130818235530=
9000)
> =3D> (column=3DuserName, value=3Dtyler, timestamp=3D1308182355302000)
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com