title: Creating Table in Apache Hive with regex returns all NULL values
body: <p>I Have many log file *.log and i want to import to Hive Table with below Syntax:</p>
  
  <pre><code>CREATE EXTERNAL TABLE cache_22 ( 
  a STRING, 
  b STRING, 
  c STRING, 
  d STRING, 
  e STRING, 
  f STRING,
  g STRING,
  h  STRING, 
  i STRING
  )
  ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' 
  WITH SERDEPROPERTIES ( 'input.regex' =  '(\d+\w+\d+)\:.*?\[.*?\]\s(\d+\.\d+)\s(\d+\.\d+)\s\w*\s\d*\s(\d*)\s\d\s\w*\s(((?:[0-9]{1,3}\.){3}[0-9]{1,3}))\s(((?:[0-9]{1,3}\.){3}[0-9]{1,3}))\:\d*\s(?:-|http:\/\/|www\.|https:\/\/)([^\/]+)','output.format.string' = "%1$$s %2$$s %3$$s %4$$s %5$$s %6$$s %7$$s %8$$s %9$$s")';
  </code></pre>
  
  <p>but when i query it bring null values as below : </p>
  
  <pre><code>NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  </code></pre>
  
  <p>this is my sample for logs:</p>
  
  <pre><code>25Oct2016:103130.123456 [1234567a3] 0.522550 1.244476 TCP_PARTIAL_HIT 206 65871 0 GET 10.10.10.199 11.11.11.11:80 
  25Oct2016:103130.654321 [1234567e8] 0.144449 0.178851 TCP_MISS 200 7035 0 GET 5.5.5.5 10.20.30.40:80 http://stackoverflow.com/questions/23668713/getting-null-values-in-hive-create-load-query-with-regex
  </code></pre>
  
  <p>please correct my mistake.</p>
  
  <p>Thanks.</p>