title: How to convert TIMESTAMPS formats to be compatible with Impala
body: <p>Here is a sample of my data in CSV format:</p>
  
  <pre><code>6/30/2014 23:57,2006,604,131
  7/1/2014 0:24,2217,263,143
  6/30/2014 23:26,173,3481,134
  ...
  </code></pre>
  
  <p>I would like to load this CSV file in Impala table and have the first column as "TIMESTAMP":</p>
  
  <pre><code>CREATE TABLE my_table(col1 timestamp, col2 int, col3 int, col4 int)
    row format delimited
    fields terminated by ',';
  
  LOAD DATA INPATH '/dataset/data' INTO TABLE my_table;
  </code></pre>
  
  <p>But Impala accepts TIMESTAMPS as the following format: </p>
  
  <pre><code>YYYY-MM-DD HH:MM:SS.sssssssss
  </code></pre>
  
  <p>While my data is: </p>
  
  <pre><code>MM/DD/YYYY HH:MM 
  </code></pre>
  
  <p>How can I convert my data in the fastest way to be readable by Impala as TIMESTAMPS? I am trying to use <code>regexp_replace</code> but was not quite successful to make a good regular expression.  </p>