Querying a legacy table

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

Using a music service example, select all the columns in the playlists table that was created in CQL. 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.