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 »
Replicating Hive Data Into Oracle BI Cloud Service for Visual Analyzer using BICS Data Sync
In yesterday’s post on using Oracle Big Data Discovery with Oracle Visual Analyzer in Oracle BI Cloud Service, I said mid-way through the article that »
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 »
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, but something I’ve been critical of is »
Oracle Data Integrator Enterprise Edition Advanced Big Data Option Part 1- Overview and 12.1.3.0.1 install
Oracle recently announced Oracle Data Integrator Enterprise Edition Advanced Big Data Options as part of the new 12.1.3.0.1 release of ODI. It »
OBIEE and ODI on Hadoop : Next-Generation Initiatives To Improve Hive Performance
The other week I posted a three-part series (part 1, part 2 and part 3) on going beyond MapReduce for Hadoop-based ETL, where I looked at »
Analytics with Kibana and Elasticsearch through Hadoop - part 3 - Visualising the data in Kibana
In this post we will see how Kibana can be used to create visualisations over various sets of data that we have combined together. Kibana is »
Analytics with Kibana and Elasticsearch through Hadoop - part 2 - Getting data into Elasticsearch
Introduction In the first part of this series I described how I made several sets of data relating to the Rittman Mead blog from various sources »
Analytics with Kibana and Elasticsearch through Hadoop - part 1 - Introduction
Introduction I’ve recently started learning more about the tools and technologies that fall under the loose umbrella term of Big Data, following a lot of »
Using rlwrap with Apache Hive beeline for improved readline functionality
rlwrap is a nice little wrapper in which you can invoke commandline utilities and get them to behave with full readline functionality just like you’d »