Apache Druid

image.png

quoted-longs.json

Try adding a transformation that casts it as long. Here are the <https://druid.apache.org/docs/24.0.0/ingestion/ingestion-spec.html#transformspec|docs on that>.

Since those numbers are decimal, you'd need to load them as `double` rather than `long` (`long` can only hold whole numbers; decimals can't be loaded and turn into either null or default value of zero)

thanks <@U0344FW86DD> - this fixed the issue.  Also good to know options in `transformSpec`

are there any plans for being able to supply parser options beyond those already supported?
<https://druid.apache.org/docs/latest/ingestion/data-formats.html#csv>
<https://opencsv.sourceforge.net/apidocs/com/opencsv/CSVParser.html>

no current plans that i am aware of, but you could always make a pull request adding a new feature!

ok thanks (however doing PR would mean i'd have to (re)learn java! :sweat_smile:)