title: Big-query does now cast automatically long decimal values to numeric, when running a load job from UI
body: <p>I have a value "1.8299324324324324" which if I insert using DML statement to BigQuery, it rounds it off and inserts in Bigquery. </p>
  
  <p>However, for the same value, if BigQuery load job using csv file on console, I get below error.</p>
  
  <blockquote>
    <p>"location" : "query",
          "message" : "Invalid NUMERIC value: 1.8299324324324324 Field: test; Value: 1.8299324324324324",
          "reason" : "invalidQuery"</p>
  </blockquote>
  
  <p>Just wanted to check if this is a limitation of Bigquery, that in load job it is not able to cast or understand this value and how to solve it?</p>