Rittman Mead Blog

Analysing Social Media Activity with ADW and OAC

Analysing Twitter Activity using the Oracle Text features within the Oracle Database, Oracle Analytics Cloud and SQL Developer Web!

json

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.

Tableau

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 what he said it wasn't an easy task. It took him a decent time and efforts to find something that is big

spark

Getting Started with Spark Streaming, Python, and Kafka

Last month I wrote a series of articles [https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-5/] in which I looked at the use of Spark for performing data transformation and manipulation. This was in the context of replatforming an existing Oracle-based ETL and datawarehouse solution onto cheaper and more elastic

jq

Using SQL to Query JSON Files with Apache Drill

I wrote recently about what Apache Drill is [https://www.rittmanmead.com/blog/2016/08/an-introduction-to-apache-drill/], and how to use it with OBIEE [https://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/]. In this post I wanted to demonstrate its great power in action for a requirement that came up recently.

apache drill

Using Apache Drill with OBIEE 12c

Apache Drill [https://drill.apache.org/] enables querying with SQL against a multitude of datasources [https://drill.apache.org/docs/connect-a-data-source/] including things like JSON files, Parquet and Avro, Hive tables, RDBMS and more. MapR have released an ODBC driver [https://drill.apache.org/docs/installing-the-driver-on-linux/#step-1:-download-the-mapr-drill-odbc-driver] for it,

Big Data

Using SparkSQL and Pandas to Import Data into Hive and Big Data Discovery

Big Data Discovery [https://www.oracle.com/big-data/big-data-discovery/index.html] (BDD) is a great tool for exploring, transforming, and visualising data stored in your organisation’s Data Reservoir. I presented a workshop on it at a recent conference [https://speakerdeck.com/rmoff/unlock-the-value-in-your-big-data-reservoir-using-oracle-big-data-discovery-and-oracle-big-data-spatial-and-graph] , and got an interesting question from