You are missing key_aliases and column_aliases from system.schema_columnfamies.
-- AY On Friday, March 1, 2013 at 18:38 PM, Haithem Jarraya wrote: > Hi, > > I wanted to retrieve all the column families related to mykeyspace, so I > ran the following query: > > SELECT columnfamily_name FROM system.schema_columns WHERE > keyspace_name='mykeyspace'; > > I am missing two column family, I am not sure if this is the > normal behavior or not? > Are there any other way to get column families of a keyspace via CQL? > > But when I do from cqlsh terminal describe keyspace my keyspace; > I retrieve all the column families. What am I missing? > > I am running a cassandra V1.2.1 > > > Many Thanks, > > H