Unable to load Json data to Vertica Flex Table
I am trying to load some really complex JSON data to a vertica flex table but for some reason the data is not getting load. I have two rows results.JSON file first row is slighly simple which is loading but second one which is slightly more complex is getting loaded as null. Cany you please help?
I am trying below.
create Flex Table Start_Json();
copy Start_Json From Local 'C:\Vehicle Results\results.json' parser fjsonparser();
SELECT maptostring(__raw__) FROM start_json;
I have attached my JSON file for your reference.