title: Storing DOUBLE vs INT --> Query time and Ingest time
body: <p>I have a column that is of numeric type. I'm not sure whether it will be a whole number or a decimal number. There are two options here:</p>
  
  <ol>
  <li>I can store the numbers as a DOUBLE whether it's whole or decimal.</li>
  <li>I can infer the type and store the numbers as a DOUBLE if it's a decimal or INT if it's whole.</li>
  </ol>
  
  <p>My question then is, it is much simpler to store it as a DOUBLE (because an int can just be represented as "5.0"), so what's the difference in Ingest time and query time if something is stored as a double vs an int. How 'expensive' is it to incorrectly store the type of an INT as a DOUBLE?</p>