cqlsh> create KEYSPACE playlist WITH replication 
       = {'class':'SimpleStrategy', 'replication_factor': 1 };

cqlsh> use playlist;

cqlsh:playlist> create table artists_by_first_letter (
       first_letter text, 
       artist text, 
       primary key (first_letter, artist));

cqlsh:playlist> create table track_by_artist (
       track text, 
       artist text, 
       track_id UUID, 
       track_length_in_seconds int, 
       genre text,music_file text, 
       primary key (artist, track, track_id));

cqlsh:playlist> create table track_by_genre (
       track text, artist text, 
       track_id UUID, 
       track_length_in_seconds int, 
       genre text,
       music_file text, 
       primary key (genre, artist, track, track_id));

cqlsh:playlist> copy artists_by_first_letter (first_letter, artist) 
     FROM 'scripts/artists.csv' WITH DELIMITER = '|';

cqlsh:playlist> copy track_by_artist (track_id, genre, artist, track, 
        track_length_in_seconds, music_file) 
     FROM 'scripts/songs.csv' 
     WITH DELIMITER = '|'  AND HEADER=true;

cqlsh:playlist> copy track_by_genre (track_id, genre, artist, track, 
        track_length_in_seconds, music_file) 
     FROM 'scripts/songs.csv' 
     WITH DELIMITER = '|'  AND HEADER=true;

cqlsh:playlist> copy artists_by_first_letter (first_letter, artist) 
     TO 'scripts/artists_out.csv'
     WITH DELIMITER = '|' AND HEADER=true;

cqlsh:playlist> select * from artists_by_first_letter;

exit;