title: Hive: Create table from text file. Handle special character
body: <p>I have data file in txt format which i need to load to a hive table<a href="https://i.stack.imgur.com/cUEsc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cUEsc.png" alt="Data Sample"></a></p>
  
  <p>I created a table to load data from this file and then LOAD command to insert data as shown below</p>
  
  <pre><code>    CREATE TABLE dev.table
      (Date string,
      c1 string,
      c2 string,
      c3 string,
      c4 string,
      c5 string,
      c6 string,
      c7 string,
      c8 string) 
      row format delimited fields terminated by '\t' stored as textfile;
  
      LOAD DATA LOCAL INPATH 'filepath.txt'  OVERWRITE INTO TABLE dev.table;
  </code></pre>
  
  <p>The data is getting inserted into table but there appears a special character in each column. Below is sample data</p>
  
  <p><a href="https://i.stack.imgur.com/5NVAk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5NVAk.png" alt="Sample output data"></a></p>
  
  <p>Please help to get rid of this special character.</p>