Big Data, Hortonworks, SQLServerPedia Syndication

Eating the elephant, one bite at a time: Loading data using Hive

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

Big Data, Hortonworks, SQLServerPedia Syndication

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

Big Data, Business Analytics, Business Intelligence, SQLServerPedia Syndication

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

Big Data, Hortonworks, SQLServerPedia Syndication

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

Big Data, Hortonworks, SQLServerPedia Syndication

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

Big Data, Hortonworks, SQLServerPedia Syndication

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

Business Intelligence, Mobile Business Intelligence, Office365, PowerBI, SQLServerPedia Syndication

Power Business Intelligence for Office365 – resolving the Scylla and Charbdis dilemma.

People have often complained about the fragmented methodology that seemed to accompany Microsoft technology releases. I see this as a manifestation of the Syclla and Charybdis problem - people complain if they don't release everything as a unified whole, or complain that things take a long time to deliver. In other words, Microsoft never seem… Continue reading Power Business Intelligence for Office365 – resolving the Scylla and Charbdis dilemma.

Business Intelligence

Notes to self: PrerequisiteInstaller.exe app crash when you try to install SharePoint 2013

I'm installing SharePoint 2013 onto a Virtual Machine, and I keep getting a crash at the point at which I try to install the Prerequisites.Essentially, I just click on the link to install prerequisites, and I just get 'no longer working' message and PrerequisiteInstaller.exe crashes.How can you resolve this?1. make sure you are running with… Continue reading Notes to self: PrerequisiteInstaller.exe app crash when you try to install SharePoint 2013