cqlsh:music> 
cqlsh:music> 
cqlsh:music> 
cqlsh:music> CREATE TABLE songs (
         ...   id uuid PRIMARY KEY,
         ...   title text,
         ...   album text,
         ...   artist text,
         ...   data blob
         ...  );
cqlsh:music> 
cqlsh:music> 
cqlsh:music> CREATE TABLE playlists (
         ...   id uuid,
         ...   song_order int,
         ...   song_id uuid,
         ...   title text,
         ...   album text,
         ...   artist text,
         ...   PRIMARY KEY  (id, song_order ) );

cqlsh:music> 
cqlsh:music> 
cqlsh:music> INSERT INTO playlists (id, song_order, song_id, title, artist, album)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee77204, 1,
         ...   a3e64f8f-bd44-4f28-b8d9-6938726e34d4, 'La Grange', 'ZZ Top', 'Tres Hombres');
cqlsh:music> 
cqlsh:music> INSERT INTO playlists (id, song_order, song_id, title, artist, album)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee77204, 2,
         ...   8a172618-b121-4136-bb10-f665cfc469eb, 'Moving in Stereo', 'Fu Manchu', 'We Must Obey');
cqlsh:music> 
cqlsh:music> INSERT INTO playlists (id, song_order, song_id, title, artist, album)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee77204, 3,
         ...   2b09185b-fb5a-4734-9b56-49077de9edbf, 'Outside Woman Blues', 'Back Door Slam', 'Roll Away');
cqlsh:music> 
cqlsh:music> 
cqlsh:music> SELECT * FROM playlists;

 id                                   | song_order | album                 | artist         | song_id                              | title
--------------------------------------+------------+-----------------------+----------------+--------------------------------------+---------------------
 62c36092-82a1-3a00-93d1-46196ee77204 |          1 |          Tres Hombres |         ZZ Top | a3e64f8f-bd44-4f28-b8d9-6938726e34d4 |           La Grange
 62c36092-82a1-3a00-93d1-46196ee77204 |          2 |          We Must Obey |      Fu Manchu | 8a172618-b121-4136-bb10-f665cfc469eb |    Moving in Stereo
 62c36092-82a1-3a00-93d1-46196ee77204 |          3 |             Roll Away | Back Door Slam | 2b09185b-fb5a-4734-9b56-49077de9edbf | Outside Woman Blues
 62c36092-82a1-3a00-93d1-46196ee77204 |          4 | No One Rides for Free |      Fu Manchu | 7db1a490-5878-11e2-bcfd-0800200c9a66 |            Ojo Rojo

(4 rows)

cqlsh:music> 
cqlsh:music> 
cqlsh:music> INSERT INTO playlists (id, song_order, song_id, title, artist, album)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee77204, 4,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a66,
         ...   'Ojo Rojo', 'Fu Manchu', 'No One Rides for Free');
cqlsh:music>  
cqlsh:music> 
cqlsh:music> CREATE INDEX ON playlists(artist );
cqlsh:music> SELECT * FROM playlists WHERE artist = 'Fu Manchu';

 id                                   | song_order | album                 | artist    | song_id                              | title
--------------------------------------+------------+-----------------------+-----------+--------------------------------------+----------
 62c36092-82a1-3a00-93d1-46196ee77204 |          4 | No One Rides for Free | Fu Manchu | 7db1a490-5878-11e2-bcfd-0800200c9a66 | Ojo Rojo

(1 rows)

cqlsh:music> 
cqlsh:music> 
cqlsh:music>
cqlsh:music> SELECT * FROM playlists WHERE id = 62c36092-82a1-3a00-93d1-46196ee77204
         ...   ORDER BY song_order DESC LIMIT 50;

 id                                   | song_order | album                 | artist         | song_id                              | title
--------------------------------------+------------+-----------------------+----------------+--------------------------------------+---------------------
 62c36092-82a1-3a00-93d1-46196ee77204 |          4 | No One Rides for Free |      Fu Manchu | 7db1a490-5878-11e2-bcfd-0800200c9a66 |            Ojo Rojo
 62c36092-82a1-3a00-93d1-46196ee77204 |          3 |             Roll Away | Back Door Slam | 2b09185b-fb5a-4734-9b56-49077de9edbf | Outside Woman Blues
 62c36092-82a1-3a00-93d1-46196ee77204 |          2 |          We Must Obey |      Fu Manchu | 8a172618-b121-4136-bb10-f665cfc469eb |    Moving in Stereo
 62c36092-82a1-3a00-93d1-46196ee77204 |          1 |          Tres Hombres |         ZZ Top | a3e64f8f-bd44-4f28-b8d9-6938726e34d4 |           La Grange

(4 rows)

cqlsh:music> ALTER TABLE songs ADD tags set<text>;
cqlsh:music> 
cqlsh:music> 
cqlsh:music> UPDATE songs SET tags = tags + {'2007'}
         ...   WHERE id = 8a172618-b121-4136-bb10-f665cfc469eb;
cqlsh:music> UPDATE songs SET tags = tags + {'covers'}
         ...   WHERE id = 8a172618-b121-4136-bb10-f665cfc469eb;
cqlsh:music> UPDATE songs SET tags = tags + {'1973'}
         ...   WHERE id = a3e64f8f-bd44-4f28-b8d9-6938726e34d4;
cqlsh:music> UPDATE songs SET tags = tags + {'blues'}
         ...   WHERE id = a3e64f8f-bd44-4f28-b8d9-6938726e34d4;
cqlsh:music> UPDATE songs SET tags = tags + {'rock'}
         ...   WHERE id = 7db1a490-5878-11e2-bcfd-0800200c9a66;
cqlsh:music> 
cqlsh:music> 
cqlsh:music> ALTER TABLE songs ADD reviews list<text>;
cqlsh:music> ALTER TABLE songs ADD venue map<timestamp, text>;

cqlsh:music> 
cqlsh:music> UPDATE songs
         ...   SET tags = tags + {'rock'}
         ...   WHERE id = 7db1a490-5878-11e2-bcfd-0800200c9a66;
cqlsh:music> 
cqlsh:music> 
cqlsh:music> UPDATE songs
         ...   SET reviews = reviews + [ 'hot dance music' ]
         ...   WHERE id = 7db1a490-5878-11e2-bcfd-0800200c9a66;
cqlsh:music> 
cqlsh:music> INSERT INTO songs (id, venue)
         ...   VALUES (7db1a490-5878-11e2-bcfd-0800200c9a66,
         ...   { '2013-9-22 12:01'  : 'The Fillmore',
         ...   '2013-10-1 18:00' : 'The Apple Barrel'});
cqlsh:music> 
cqlsh:music> SELECT id, tags FROM songs;

 id                                   | tags
--------------------------------------+--------------------
 7db1a490-5878-11e2-bcfd-0800200c9a66 |           {'rock'}
 a3e64f8f-bd44-4f28-b8d9-6938726e34d4 |  {'1973', 'blues'}
 8a172618-b121-4136-bb10-f665cfc469eb | {'2007', 'covers'}

(3 rows)

cqlsh:music> 
cqlsh:music> 
cqlsh:music> SELECT id, venue FROM songs;

 id                                   | venue
--------------------------------------+----------------------------------------------------------------------------------------------
 7db1a490-5878-11e2-bcfd-0800200c9a66 | {'2013-09-22 12:01:00+1200': 'The Fillmore', '2013-10-01 18:00:00+1200': 'The Apple Barrel'}
 a3e64f8f-bd44-4f28-b8d9-6938726e34d4 |                                                                                         null
 8a172618-b121-4136-bb10-f665cfc469eb |                                                                                         null

(3 rows)

cqlsh:music> 
cqlsh:music> 


===============================================================================
10 additional Songs with 3 tags each and 4 playlists and 8 queries
===============================================================================


cqlsh:music> 
cqlsh:music> 
cqlsh:music> CREATE TABLE myplaylists (
         ...   id uuid ,
         ...   song_order int,
         ...   song_id uuid,
         ...   title text,
         ...   album text,
         ...   artist text,
         ...   tags set<text>,
         ...   PRIMARY KEY  (id, song_order) );
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10001, 1,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a01,
         ...   'Time to Go', 'Foo Bar', 'The Last Foo',{'Rock','FromBrother','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10001, 2,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a02,
         ...    'Classic Car Foo', 'Foo Bar', 'The Last Foo',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10002, 1,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a03,
         ...   'Last Call', 'Foo Bar', 'The Last Foo',{'Relax','FromBrother','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10002, 2,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a04,
         ...   'Rebar', 'Foo Bar', 'The Last Foo',{'Relax','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10003, 1,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a05,
         ...   'Pound', 'The Sarp C', 'Razor',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10003, 2,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a06,
         ...   'Lets Go', 'The Sarp C', 'Razor',{'Relax','FromBrother','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10003, 3,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a07,
         ...   'Model it', 'The Sarp C', 'The UN',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10004, 1,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a08,
         ...   'The Prez', 'The Sarp C', 'The UN',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10004, 2,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a09,
         ...   'Under Ground', 'Move It', 'Go Get It',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> INSERT INTO myplaylists (id, song_order, song_id, title, artist, album, tags)
         ...   VALUES (62c36092-82a1-3a00-93d1-46196ee10004, 3,
         ...   7db1a490-5878-11e2-bcfd-0800200c9a10,
         ...   'Chrome', 'Move It', 'Go Get It',{'Rock','RoadMix','MasterCollection'});
cqlsh:music> 
cqlsh:music> 
cqlsh:music> select * from myplaylists;

 id                                   | song_order | album        | artist     | song_id                              | tags                                         | title
--------------------------------------+------------+--------------+------------+--------------------------------------+----------------------------------------------+-----------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |       The UN | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a08 |      {'MasterCollection', 'RoadMix', 'Rock'} |        The Prez
 62c36092-82a1-3a00-93d1-46196ee10004 |          2 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a09 |      {'MasterCollection', 'RoadMix', 'Rock'} |    Under Ground
 62c36092-82a1-3a00-93d1-46196ee10004 |          3 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a10 |      {'MasterCollection', 'RoadMix', 'Rock'} |          Chrome
 62c36092-82a1-3a00-93d1-46196ee10002 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a03 | {'FromBrother', 'MasterCollection', 'Relax'} |       Last Call
 62c36092-82a1-3a00-93d1-46196ee10002 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a04 |     {'MasterCollection', 'Relax', 'RoadMix'} |           Rebar
 62c36092-82a1-3a00-93d1-46196ee10001 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a01 |  {'FromBrother', 'MasterCollection', 'Rock'} |      Time to Go
 62c36092-82a1-3a00-93d1-46196ee10001 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a02 |      {'MasterCollection', 'RoadMix', 'Rock'} | Classic Car Foo
 62c36092-82a1-3a00-93d1-46196ee10003 |          1 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a05 |      {'MasterCollection', 'RoadMix', 'Rock'} |           Pound
 62c36092-82a1-3a00-93d1-46196ee10003 |          2 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a06 | {'FromBrother', 'MasterCollection', 'Relax'} |         Lets Go
 62c36092-82a1-3a00-93d1-46196ee10003 |          3 |       The UN | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a07 |      {'MasterCollection', 'RoadMix', 'Rock'} |        Model it

(10 rows)

cqlsh:music> 
cqlsh:music> update myplaylists set artist = 'New Band' where id = 62c36092-82a1-3a00-93d1-46196ee10004 and song_order = 1;
cqlsh:music> 
cqlsh:music> select * from myplaylists;

 id                                   | song_order | album        | artist     | song_id                              | tags                                         | title
--------------------------------------+------------+--------------+------------+--------------------------------------+----------------------------------------------+-----------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |       The UN |   New Band | 7db1a490-5878-11e2-bcfd-0800200c9a08 |      {'MasterCollection', 'RoadMix', 'Rock'} |        The Prez
 62c36092-82a1-3a00-93d1-46196ee10004 |          2 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a09 |      {'MasterCollection', 'RoadMix', 'Rock'} |    Under Ground
 62c36092-82a1-3a00-93d1-46196ee10004 |          3 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a10 |      {'MasterCollection', 'RoadMix', 'Rock'} |          Chrome
 62c36092-82a1-3a00-93d1-46196ee10002 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a03 | {'FromBrother', 'MasterCollection', 'Relax'} |       Last Call
 62c36092-82a1-3a00-93d1-46196ee10002 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a04 |     {'MasterCollection', 'Relax', 'RoadMix'} |           Rebar
 62c36092-82a1-3a00-93d1-46196ee10001 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a01 |  {'FromBrother', 'MasterCollection', 'Rock'} |      Time to Go
 62c36092-82a1-3a00-93d1-46196ee10001 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a02 |      {'MasterCollection', 'RoadMix', 'Rock'} | Classic Car Foo
 62c36092-82a1-3a00-93d1-46196ee10003 |          1 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a05 |      {'MasterCollection', 'RoadMix', 'Rock'} |           Pound
 62c36092-82a1-3a00-93d1-46196ee10003 |          2 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a06 | {'FromBrother', 'MasterCollection', 'Relax'} |         Lets Go
 62c36092-82a1-3a00-93d1-46196ee10003 |          3 |       The UN | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a07 |      {'MasterCollection', 'RoadMix', 'Rock'} |        Model it

(10 rows)

cqlsh:music> update myplaylists set tags = tags - {'MasterCollection'} where id = 62c36092-82a1-3a00-93d1-46196ee10003 and song_order = 3;
cqlsh:music> 
cqlsh:music> select * from myplaylists;

 id                                   | song_order | album        | artist     | song_id                              | tags                                         | title
--------------------------------------+------------+--------------+------------+--------------------------------------+----------------------------------------------+-----------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |       The UN |   New Band | 7db1a490-5878-11e2-bcfd-0800200c9a08 |      {'MasterCollection', 'RoadMix', 'Rock'} |        The Prez
 62c36092-82a1-3a00-93d1-46196ee10004 |          2 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a09 |      {'MasterCollection', 'RoadMix', 'Rock'} |    Under Ground
 62c36092-82a1-3a00-93d1-46196ee10004 |          3 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a10 |      {'MasterCollection', 'RoadMix', 'Rock'} |          Chrome
 62c36092-82a1-3a00-93d1-46196ee10002 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a03 | {'FromBrother', 'MasterCollection', 'Relax'} |       Last Call
 62c36092-82a1-3a00-93d1-46196ee10002 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a04 |     {'MasterCollection', 'Relax', 'RoadMix'} |           Rebar
 62c36092-82a1-3a00-93d1-46196ee10001 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a01 |  {'FromBrother', 'MasterCollection', 'Rock'} |      Time to Go
 62c36092-82a1-3a00-93d1-46196ee10001 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a02 |      {'MasterCollection', 'RoadMix', 'Rock'} | Classic Car Foo
 62c36092-82a1-3a00-93d1-46196ee10003 |          1 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a05 |      {'MasterCollection', 'RoadMix', 'Rock'} |           Pound
 62c36092-82a1-3a00-93d1-46196ee10003 |          2 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a06 | {'FromBrother', 'MasterCollection', 'Relax'} |         Lets Go
 62c36092-82a1-3a00-93d1-46196ee10003 |          3 |       The UN | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a07 |                          {'RoadMix', 'Rock'} |        Model it

(10 rows)

cqlsh:music> DELETE album FROM myplaylists WHERE id = 62c36092-82a1-3a00-93d1-46196ee10002 and song_order = 2;
cqlsh:music> 
cqlsh:music> select * from myplaylists;

 id                                   | song_order | album        | artist     | song_id                              | tags                                         | title
--------------------------------------+------------+--------------+------------+--------------------------------------+----------------------------------------------+-----------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |       The UN |   New Band | 7db1a490-5878-11e2-bcfd-0800200c9a08 |      {'MasterCollection', 'RoadMix', 'Rock'} |        The Prez
 62c36092-82a1-3a00-93d1-46196ee10004 |          2 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a09 |      {'MasterCollection', 'RoadMix', 'Rock'} |    Under Ground
 62c36092-82a1-3a00-93d1-46196ee10004 |          3 |    Go Get It |    Move It | 7db1a490-5878-11e2-bcfd-0800200c9a10 |      {'MasterCollection', 'RoadMix', 'Rock'} |          Chrome
 62c36092-82a1-3a00-93d1-46196ee10002 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a03 | {'FromBrother', 'MasterCollection', 'Relax'} |       Last Call
 62c36092-82a1-3a00-93d1-46196ee10002 |          2 |         null |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a04 |     {'MasterCollection', 'Relax', 'RoadMix'} |           Rebar
 62c36092-82a1-3a00-93d1-46196ee10001 |          1 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a01 |  {'FromBrother', 'MasterCollection', 'Rock'} |      Time to Go
 62c36092-82a1-3a00-93d1-46196ee10001 |          2 | The Last Foo |    Foo Bar | 7db1a490-5878-11e2-bcfd-0800200c9a02 |      {'MasterCollection', 'RoadMix', 'Rock'} | Classic Car Foo
 62c36092-82a1-3a00-93d1-46196ee10003 |          1 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a05 |      {'MasterCollection', 'RoadMix', 'Rock'} |           Pound
 62c36092-82a1-3a00-93d1-46196ee10003 |          2 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a06 | {'FromBrother', 'MasterCollection', 'Relax'} |         Lets Go
 62c36092-82a1-3a00-93d1-46196ee10003 |          3 |       The UN | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a07 |                          {'RoadMix', 'Rock'} |        Model it

(10 rows)

cqlsh:music> select * from myplaylists where id = 62c36092-82a1-3a00-93d1-46196ee10004;

 id                                   | song_order | album     | artist   | song_id                              | tags                                    | title
--------------------------------------+------------+-----------+----------+--------------------------------------+-----------------------------------------+--------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |    The UN | New Band | 7db1a490-5878-11e2-bcfd-0800200c9a08 | {'MasterCollection', 'RoadMix', 'Rock'} |     The Prez
 62c36092-82a1-3a00-93d1-46196ee10004 |          2 | Go Get It |  Move It | 7db1a490-5878-11e2-bcfd-0800200c9a09 | {'MasterCollection', 'RoadMix', 'Rock'} | Under Ground
 62c36092-82a1-3a00-93d1-46196ee10004 |          3 | Go Get It |  Move It | 7db1a490-5878-11e2-bcfd-0800200c9a10 | {'MasterCollection', 'RoadMix', 'Rock'} |       Chrome

(3 rows)

cqlsh:music>
cqlsh:music> CREATE INDEX on myplaylists (artist);
cqlsh:music> 
cqlsh:music> 
cqlsh:music> select album, artist, tags, song_order from myplaylists where artist='Move It';

 id                                   | song_order | album     | artist   | song_id                              | tags                                    | title
--------------------------------------+------------+-----------+----------+--------------------------------------+-----------------------------------------+--------------
 62c36092-82a1-3a00-93d1-46196ee10004 |          1 |    The UN | New Band | 7db1a490-5878-11e2-bcfd-0800200c9a08 | {'MasterCollection', 'RoadMix', 'Rock'} |     The Prez

(1 rows)

cqlsh:music>
cqlsh:music> 
cqlsh:music> select album, artist, tags, song_order from myplaylists where id = 62c36092-82a1-3a00-93d1-46196ee10004 order by song_order;

 album     | artist   | tags                                    | song_order
-----------+----------+-----------------------------------------+------------
    The UN | New Band | {'MasterCollection', 'RoadMix', 'Rock'} |          1
 Go Get It |  Move It | {'MasterCollection', 'RoadMix', 'Rock'} |          2
 Go Get It |  Move It | {'MasterCollection', 'RoadMix', 'Rock'} |          3

(3 rows)

cqlsh:music> 
cqlsh:music> 
cqlsh:music> CREATE INDEX on myplaylists (album);
cqlsh:music> CREATE INDEX on myplaylists (song_order);
cqlsh:music> 
cqlsh:music> 
cqlsh:music> select album, artist, tags, song_order from myplaylists WHERE song_order = 1 and album = 'Razor' ALLOW FILTERING;

 id                                   | song_order | album        | artist     | song_id                              | tags                                         | title
--------------------------------------+------------+--------------+------------+--------------------------------------+----------------------------------------------+-----------------
 62c36092-82a1-3a00-93d1-46196ee10003 |          1 |        Razor | The Sarp C | 7db1a490-5878-11e2-bcfd-0800200c9a05 |      {'MasterCollection', 'RoadMix', 'Rock'} |           Pound

(1 rows)