Apache Pinot

Hello folks :wave:, new to the pinot world, just wanted clarification on one point. We have a `Long` type column in one of the tables. Going ahead, for more precision, we want to maintain a `Double` type of column. Would it be possible to directly update the column type in the schema or should we add a new column and delete the old one.

Referred the <https://docs.pinot.apache.org/users/tutorials/schema-evolution|schema evolution link>, but couldn't determine how to proceed from it.

Long to double is not a backward compatible change, and won’t be allowed 

Ahh, okay. Might sound like a noob, but, wouldn't long values still retain their precision on conversion to Double?
The other way around would cause precision loss,  but not sure about the `long` -&gt; `double` case.

<@UDQU92KBK>

Long to double does cause precision loss, due to floating point representation 

Here’s an article for your reference <https://stackoverflow.com/questions/32783923/how-big-is-the-precision-loss-converting-long-to-double|https://stackoverflow.com/questions/32783923/how-big-is-the-precision-loss-converting-long-to-double>

Thank you Mayank, this helps :slightly_smiling_face: