Skipping Records with Unspecified JSON Fields
Phil Molea, Sr. Information Developer, Vertica
June 26, 2018
Serge Bonte and Jim Knicely authored this post. Vertica provides a built-in file parser named FJSONPARSER that parses and loads a JSON file. This file can contain either repeated JSON data objects (including nested maps) or an outer list of JSON elements. For a flex table, the parser stores the JSON data in a single-value...