title: Hive table taking decimal value as NULL
body: <p>I am  facing strange issue.I tried with tab delimiter both in file and in table definition and comma as well.</p>
  
  <p>But in both cases it reads the decimal values as NULL.But when I define this fields as INT it works fine.</p>
  
  <p>Sample data with comma delimited values:
  1,22.334
  2,445.322
  3,999.233</p>
  
  <p>defined this table as </p>
  
  <p>create table x(ID INT,SAL DECIMAL(3,3)) row format delimited fields terminated by '\t' location '\tmp\data\'</p>
  
  <p>similarly for comma delimited file </p>
  
  <p>create table x(ID INT,SAL DECIMAL(3,3)) row format delimited fields terminated by ',' location '\tmp\data\'</p>
  
  <p>But in both cases it is reading decimal values as NULL?what is the issue</p>