title: SparkSQL split using Regex
body: <p>I'm trying to split a line into an array using a regular expression.
  My line contains an apache log and I'm looking to split using sql.</p>
  
  <p>I tried split and array function, but nothing.</p>
  
  <pre>
  Select split('10.10.10.10 - - [08/Sep/2015:00:00:03 +0000] "GET /index.html HTTP/1.1" 206 - - "Apache-HttpClient" -', '^([^ ]+) ([^ ]+) ([^ ]+) \[([^\]]+)\] "([^"]+)" \d+ - - "([^"]+)".*')
  ;
  </pre>
  
  <p>I'm expecting an array with 6 elements</p>
  
  <p>Thanks</p>