Error loading FLOAT INFINITY using FJSONPARSER
I found error on loading JSON into flex table.
Vertica report something like:
udx/supported/flextable/FJsonParser.cpp:35], error code: 0, message: Malformed record found: Error [Invalid value.] at character 589
Checking JSON file, it contains FLOAT Infinity:
"myfield" : Infinity
Typically myfield contains FLOAT like "myfield":4.567
but in this case it is word Infinity, without double quotes.
Quick check show that Vertica do support Infinity for FLOAT:
Vertica follows the IEEE specification for floating point, including NaN (not a number) and Infinity (Inf).
What to do to make FJSONPARSER to load Infinity
Error message from FJSONPARSER can be more explanatory.