Parsing Badly Formatted JSON in Oracle DB with APEX_JSON
Using APEX_JSON to parse malformed JSON documents allowing the extraction of all the information contained. »
Getting Smarter in Renting with Tableau 10
Preface Not a long time ago a friend of mine spent a significant amount of time trying to find a flat to rent. And according to »
Getting Started with Spark Streaming, Python, and Kafka
Last month I wrote a series of articles in which I looked at the use of Spark for performing data transformation and manipulation. This was in »
Using SQL to Query JSON Files with Apache Drill
I wrote recently about what Apache Drill is, and how to use it with OBIEE. In this post I wanted to demonstrate its great power in »
Using Apache Drill with OBIEE 12c
Apache Drill enables querying with SQL against a multitude of datasources including things like JSON files, Parquet and Avro, Hive tables, RDBMS and more. MapR have »
Using SparkSQL and Pandas to Import Data into Hive and Big Data Discovery
Big Data Discovery (BDD) is a great tool for exploring, transforming, and visualising data stored in your organisation’s Data Reservoir. I presented a workshop on »