In the previous 'Eating the elephant' blogs, we've talked about tables and their implementation. Now, we will look at one of the ways to get data into a table. There are different ways to do this, but here we will look only at getting data into an external Hive table using HiveQL, which is the … Continue reading Eating the elephant, one bite at a time: Loading data using Hive
Eating the elephant, one bite at a time: Partitioning in SQL Server 2012 and in Hive
Hive and SQL Server offer you the facility to partition your tables, but their features differ slightly. This blog will highlight some of the main differences for you to look out for.What problems does partitioning solve? The problem arises due to the size of the tables. Therefore, the simplest solution is to divide the table … Continue reading Eating the elephant, one bite at a time: Partitioning in SQL Server 2012 and in Hive
Eating the elephant one bite at a time: knowing your tables
In this segment, we will look at the most basic unit of the database: tables. We will look at their implementation in SQL Server and also in Hive.Tables, in SQL Server, contain the data in a database. SQL Server has a number of different types of database as well as the tables that are defined … Continue reading Eating the elephant one bite at a time: knowing your tables
Eating the elephant one bite at a time: dropping databases
In the last post, you learned how simple it is to create a database using Hive. The command is very similar to the way that we do this in SQL Server. As discussed, the underlying technology works differently, but ultimately they achieve the same end; database created.Now that you've created your database, how do you … Continue reading Eating the elephant one bite at a time: dropping databases
Eating the elephant one bite at a time: creating a database using Hive
Following on from the first part in my Hadoop series for the Microsoft Business Intelligence professional, we move to the next stage where we look at the simplicity of creating a database.Before we move forward, ensure that the Hortonworks Sandbox is up and running. Our objective today is to create a new database called 'IncomeInequality'. … Continue reading Eating the elephant one bite at a time: creating a database using Hive
Eating the elephant one bite at a time: Some tips in setting up the Hortonworks Sandbox VM
In this blog post series, we will look at how the Business Intelligence professional can learn to use Big Data as a source. This series is mainly aimed at Microsoft and Tableau professionals, but everyone is welcome. Creighton Abrams once said "When eating an elephant, take one time at a time" and this is how … Continue reading Eating the elephant one bite at a time: Some tips in setting up the Hortonworks Sandbox VM
Big Data overview of the Microsoft distro of Hadoop
Here are my Big Data slides from SQLSaturday Dublin and SQLSaturday Edinburgh.This is part of the preview work that I'm doing for our SQLPass Precon which I'm jointly conducting with Allan Mitchell MVP this October, in Charlotte, NC. Here is the link to register, and I hope to see you there! Big Data Visualisation with … Continue reading Big Data overview of the Microsoft distro of Hadoop
Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day
I'm delighted to announce that Allan Mitchell (blog ¦ twitter) and I are giving a Big Data for the Business Intelligence Professional preconference session at SQLPass Summit 2013 in Charlotte, NC.What will we be covering? What does Big Data mean for business intelligence professionals? Come see the “whats,” “hows,” and “whys” as this full-day pre-conference … Continue reading Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day
SQL Server 2012 Virtual Launch Event and Download Info
The SQL Server 2012 Virtual Launch Event is starting on 7th March! As part of a global team on March 7th, I'm answering questions on the SQL Server 2012 Virtual Launch Event, which is being held online. Register here: http://www.sqlserverlaunch.com/ If you're not sure what the fuss is about, take a look at the video here:In the … Continue reading SQL Server 2012 Virtual Launch Event and Download Info