Rittman Mead Blog - Apache Drill

SQL-on-Hadoop: Impala vs Drill

I recently wrote a blog post about Oracle's Analytic Views [https://www.rittmanmead.com/blog/2017/04/metadata-modeling-in-the-database-with-analytic-views/] and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I&

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.

odbc

How To Poke Around OBIEE on Linux with strace (Working with Unsupported ODBC Sources in OBIEE 12c)

OBIEE 12c (and 11g and 10g before it) supports three primary ways [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1465] of connecting to data sources: 1. Native Gateway [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1179] , such as OCI for Oracle. This

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,

hdfs

An Introduction to Apache Drill

Apache Drill [https://drill.apache.org/] is an engine that can connect to many different data sources, and provide a SQL interface to them. It's not just a wanna-be SQL interface that trips over at anything complex - it's a hugely functional one [https://drill.apache.