title: Comma delimited string to individual rows - Impala SQL
body: <p>Let's suppose we have a table:</p>
  
  <pre><code>Owner   | Pets
  ------------------------------
  Jack    | "dog, cat, crocodile" 
  Mary    | "bear, pig"
  </code></pre>
  
  <p>I want to get as a result:</p>
  
  <pre><code>Owner   | Pets
  ------------------------------
  Jack    | "dog"
  Jack    | "cat"
  Jack    | "crocodile" 
  Mary    | "bear"
  Mary    | "pig"
  </code></pre>
  
  <p>I found some solutions to similar problems by googling, but Impala SQL does not offer any of these capabilities to apply the suggested solutions.</p>
  
  <p>Any help would be greatly appreciated!</p>