select      a.artist_id, a.first_name, a.last_name 
           ,s.songs

from                    artist  as a

            left join  (select      artist_id
                                   ,concat('{',concat_ws(',',collect_list(concat(cast(song_id as string),':[',song_name,',',cast(song_date as string),']'))),'}') as songs

                        from        song    as s

                        group by    artist_id
                        ) s

            on          s.artist_id =
                        a.artist_id
;