CQL for Cassandra 1.2

Querying a legacy table

You can use the CLI GET command to query tables created with or without the COMPACT STORAGE directive in CQL 3 or created with the Thrift API, CLI, or early version of CQL.

Using CQL 3, you can query a legacy table. A legacy table managed in CQL 3 includes an implicit WITH COMPACT STORAGE directive.

Continuing with the music service example, select all the columns in the playlists table that was created in CQL 3. This output appears:

[default@music ] GET playlists  [62c36092-82a1-3a00-93d1-46196ee77204 ];
                 =>  ( column =7db1a490-5878-11e2-bcfd-0800200c9a66:,value =,  timestamp =1357602286168000 ) 
                 =>  ( column =7db1a490-5878-11e2-bcfd-0800200c9a66:album,
                   value =4e6f204f6e6520526964657320666f722046726565,  timestamp =1357602286168000 )
                 .
                 .
                 .
                 =>  ( column =a3e64f8f-bd44-4f28-b8d9-6938726e34d4:title,
                   value =4c61204772616e6765,  timestamp =1357599350478000 )
                 Returned 16 results.

The output of cell values is unreadable because GET returns the values in byte format.

Show/hide