title: Athena- extract substring from string - comma delimited
body: <p>I want to create Athena view from Athena table.</p>
  <p>In table, the column value is &quot;lastname, firstname&quot; so I want to extract these values as 'lastname' and 'firstname' and then need to store it into seperate columns in a view. example- firstname need to be stored into new column- 'first_name' and lastname need to be store into new column - 'last_name'</p>
  <p>whats the SQL function which I can use here? I tried split function but then it's giving me an array.</p>