How to list all column names in a column family in Cassandra?

java cassandra hector
Yelis913 picture Yelis913 · Jul 9, 2012 · Viewed 7.5k times · Source

I'm using Cassandra, and I want to make a data browser which shows the contents of any column family. I need to get the column names to configure a UI grid. Is it possible to collect the names of columns in all rows?

Answer

jbellis picture jbellis · Jul 9, 2012

The best way, if you are using Cassandra 1.1:

SELECT column_name FROM system.schema_columnfamilies WHERE keyspace_name = X AND columnfamily_name = Y

See also http://www.datastax.com/dev/blog/schema-in-cassandra-1-1

Related questions

Cassandra Client Java API's

I have recently started working with Cassandra Database. Now I am in the process of evaluating which Cassandra client we should go forward with. I have seen various post on stackoverflow about which client to use for Cassandra but none …

Read More
in cassandra-cli how to get all column names in a table and how to get it using hector in java?

I'm trying to get column names but could not get way to get only column names. In cli I executed command describe table nodes, it returned the result: CREATE TABLE nodes ( key text PRIMARY KEY, id text, scores text, topic1 …

Read More
Basics of Hector & Cassandra

I'm working with Cassandra-0.8.2. I am working with the most recent version of Hector & My java version is 1.6.0_26 I'm very new to Cassandra & Hector. What I'm trying to do: 1. connect to an up & running instance of cassandra …

Read More