Impala 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&
obiee ETL Offload with Spark and Amazon EMR - Part 1 - Introduction We recently undertook a two-week Proof of Concept exercise for a client, evaluating whether their existing ETL processing could be done faster and more cheaply using Spark. They were also interested in whether something like Redshift [http://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html] would provide a suitable
Big Data Using HBase and Impala to Add Update and Delete Capability to Hive DW Tables, and Improve Query Response Times One of our customers is looking to offload part of their data warehouse platform to Hadoop, extracting data out of a source system and loading it into Apache Hive tables for subsequent querying using OBIEE11g. One of the challenges that the project faces though is how to handle updates to
Big Data OBIEE 11.1.1.9 Now Supports HiveServer2 and Cloudera Impala As you all probably know I’m a big fan of Oracle’s BI and Big Data products [http://www.rittmanmead.com/biforum2015/optional-masterclass-delivering-the-oracle-information-management-big-data-reference-architecture/] , but something I’ve been critical of [https://www.rittmanmead.com/blog/2014/12/connecting-obiee11g-on-windows-to-a-kerberos-secured-cdh5-hadoop-cluster-using-cloudera-hiveserver2-odbc-drivers/] is OBIEE11g’s lack of support for HiveServer2 connections to Hadoop
