Vertica Blog

Vertica Blog

JSON

Hand writing the text: Helpful Tips

Analyzing JSON Already Loaded into Vertica Regular Tables

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
July 22, 2019

Vertica flex tables allow you to query data in JSON format. But what if you've imported JSON objects into VARCHAR already? Here's how you can extract the JSON into flex tables without exporting and importing. Let's create a sample table with a JSON column to convert: Now let's create a flex table: Flex tables use...

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...