Introduction This blog post presents a basic MapR-DB connector which allows data in a MapR-DB table to be queried using ANSI SQL in Kognitio. It demonstrates how simple it can be to write a connector for a data source and demonstrates the use of standard Kognitio utilities to transform JSON data into tabular format. The…
In my last blog post, I introduced Kognitio’s ability to flatten complex JSON objects for loading into a table. Today we’ll look at another example using real-world Ordnance Survey data. We’ll also look at what you can do if the JSON files you need to load are in HDFS. We’ll use these techniques to solve…
Each wife had seven sacks… Converting simple, flat JSON data into CSV or another tabular format is a problem addressed by many freely-available JSON-to-CSV converters. However, these are usually only useful when the JSON is a series of flat objects without any nested arrays. In practice, real-world JSON files often have nested arrays containing more…