title: null values getting uploaded into hive table from a csv file
body: <p>I am new to hadoop hive . we are using open source hadoop hive. It is installed on ubuntu a single node cluster. I have 1 million rows of data in a csv file which i moved it from windows to linux. when uploading data into the hive using the foolwing command null values are getting uploaded into the table.</p>
  
  <pre><code>LOAD DATA INPATH '/home/goldstone/Desktop/RejectStats.csv' 
  OVERWRITE INTO TABLE rejstats;
  </code></pre>
  
  <p>I even tried to upload the values by tplacing the file hdfs but stil the same issue.</p>
  
  <p>My table structure is as follows:</p>
  
  <pre><code>CREATE TABLE rejstats( amount_requested INT , appdate TIMESTAMP , loan_title STRING , dbt_income_ratio FLOAT , city STRING , state STRING , employment_lenght STRING)
  ROW FORMAT
  DELIMITED FIELDS TERMINATED BY '\t'
  STORED AS TEXTFILE;
  </code></pre>
  
  <p>I am attaching the screen shot of the null values returned.</p>
  
  <p>please anyone could help me with this issue. Thank You.</p>
  
  <p>Regards,
  Divya.</p>