title: How can I create multiple rows based on the value of one column in SQL?
body: <p>I have a column of type string in my table, where multiple values are separated by pipe operator. For example, like this,</p>
  <pre><code>Value1|Value2|Value3
  </code></pre>
  <p>Now, what I want is to have a query, which will show three rows for this row. Basically something similar to the concept of explode in Dataframes.</p>
  <p>Note that I am using Spark SQL. And I want to achieve this using SQL, not dataframes.</p>