incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: Extract meta-data using cql 3
Date Fri, 12 Jul 2013 09:13:48 GMT
The "raw" answer is that you should query the system tables. The schema is
stored in the 3 following tables: System.schema_keyspaces,
System.schema_columnfamilies and System.schema_columns. Unfortunately, the
information stored in there is, for different reasons, not in a form that
makes
a lot of sense from a CQL3 point of view.

So in practice, you should probably rely on your client drivers that might
provide that same information but in a more usable way. For instance, with
cqlsh, you have a DESCRIBE command. Of if you say use the DataStax Java
driver,
you can access all those metadata through
cluster.getMetadata().getKeyspaces(),
etc...



On Fri, Jul 12, 2013 at 10:52 AM, Murali <muralidharan.tnj@gmail.com> wrote:

> Hi experts,
>
> How to extract meta-data of a table or a keyspace using CQL 3.0?
>
> --
> Thanks,
> Murali
>
>

Mime
View raw message