title: Load data into Hive with custom delimiter
body: <p>I'm trying to create an internal (managed) table in hive that can store my incremental log data. The table goes like this:</p>
  
  <pre><code>CREATE TABLE logs (foo INT, bar STRING, created_date TIMESTAMP)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '&lt;=&gt;'
  STORED AS TEXTFILE;
  </code></pre>
  
  <p>I need to load data into this table periodically.</p>
  
  <pre><code>LOAD DATA INPATH '/user/foo/data/logs' INTO TABLE logs;
  </code></pre>
  
  <p>But the data is not getting inserted into the table properly. There might be some problem with the delimiter.Can't find why.</p>
  
  <p>Example log line:</p>
  
  <pre><code>120&lt;=&gt;abcdefg&lt;=&gt;2016-01-01 12:14:11
  </code></pre>
  
  <p>On <code>select * from logs;</code> I get,</p>
  
  <pre><code>120  =&gt;abcdefg  NULL
  </code></pre>
  
  <p>first attribute is fine, the second contains a part of delimiter but since it's string that is getting inserted and third will be null since it expects date time.</p>
  
  <p>Can anyone please help on how to provide custom delimiters and load data successfully.</p>