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.

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.