title: Hive: Using RegexSerDe to define input format
body: <p>I looked at several solutions but none of them worked before deciding to post my question here. I a trying to create a table in hive and load data in it from a csv of the form <code>String A, "String B"</code>. I tried writing the regex myself but whenever i load data, all values are NULL.</p>
  
  <p>My create table command is as follows:-</p>
  
  <pre><code>create table tab1 (col1 string, col2 string)                    
      ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'     
      WITH SERDEPROPERTIES (                                                 
      "input.regex" = "\"([^\"]*)\",\"([^\"]*)\"$") 
  </code></pre>
  
  <p>And i am loading data by the following command:-</p>
  
  <pre><code>load data inpath '/path/to/file.csv' into table tab1;
  </code></pre>
  
  <p>Any ideas on what i am doing wrong?</p>