Spring officially starts tomorrow and it’s the perfect time to do some spring cleaning on old projections. This quick tip shows how to identify unused projections.
Introduced in Vertica 7.0 as Flex Zone, the ability to load, parse and explore semi-structured and un-structured data became a possibility. The first release of Flex in 7.0 included 3 parsers (fdelimitedparser, fjsonparser, and fcefparser). Vertica 7.1 added fdelimitedpairparser and fregexparser parsers. This introduction will focus on creating Flex tables and loading JSON data. Future…