Data Otaku

A seemingly random collection of data- and database-related posts

Load Azure Storage Data into Cloudera HDFS

How do I get data from an Azure Storage account into an Azure-deployed Cloudera cluster running...

Author: Bryan C Smith Date: 10/30/2017

Working with the HBase Import and Export Utility

As mentioned in a couple other posts, I am working with a customer to move data between two Hadoop...

Author: Bryan C Smith Date: 12/21/2016

Exploring the Hive IMPORT and EXPORT Commands

In a recent post, I mentioned I am working with a customer to migrate from a native Hortonworks...

Author: Bryan C Smith Date: 12/20/2016

Pushing Data from a Hortonworks Cluster to an Azure HDInsight Cluster

I have a scenario where a customer wishes to explore a move from an existing Hortonworks (HDP)...

Author: Bryan C Smith Date: 12/09/2016

Goofing around with the Cognitive Services Translator API

Recently, I was asked to get familiar with the Translator API in Azure Cognitive Services.  Not...

Author: Bryan C Smith Date: 11/05/2016

A Fixed-Width Extractor for Azure Data Lake Analytics

I have a fixed-width text file I'd like to use with Azure Data Lake Analytics (ADLA). ADLA reads...

Author: Bryan C Smith Date: 10/27/2016

Data Sources for Business Analysts

I commonly get asked where to find data.  For most Business Analysts, your best data sources are...

Author: Bryan C Smith Date: 07/04/2016

Split a Large Row-Formatted Text File using PowerShell

I move a lot of large, row-formatted text files into Azure Storage for work I do with HDInsight and...

Author: Bryan C Smith Date: 06/24/2016

Configuration of HBase on Azure HDInsight as a Drill Data Source

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. In a previous...

Author: Bryan C Smith Date: 06/20/2016

Configuration of Hive on Azure HDInsight as a Drill Data Source

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. With my Drill...

Author: Bryan C Smith Date: 06/13/2016

Enabling SSL Encryption on the Drill Web Console

NOTE This is a continuation of my series on the deployment of Apache Drill on Azure. That said,...

Author: Bryan C Smith Date: 06/10/2016

Setting up Basic User Authentication in Drill

NOTE This is a continuation of my series on the deployment of Apache Drill on Azure. That said,...

Author: Bryan C Smith Date: 06/10/2016

A Script for Replicating Database Backup Files to the Azure Cloud

Let's say we have a backup process that creates backup files on a file server.  For disaster...

Author: Bryan C Smith Date: 06/07/2016

Connecting to the Drill Cluster from a Client App

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. Drill...

Author: Bryan C Smith Date: 06/01/2016

Connect Drill to an Azure SQL Database

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. The intent of...

Author: Bryan C Smith Date: 05/31/2016

Configuration of Azure Blob Storage (aka WASB) as a Drill Data Source

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. Azure Storage...

Author: Bryan C Smith Date: 05/30/2016

Configuration of the Drill Cluster

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. With our...

Author: Bryan C Smith Date: 05/29/2016

Configuration of the ZooKeeper Ensemble

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. With the VMs...

Author: Bryan C Smith Date: 05/28/2016

The Deployment Mechanics for the Drill Infrastructure

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. In my last...

Author: Bryan C Smith Date: 05/28/2016

An Overview of an Apache Drill Topology in Azure

NOTE This post is part of a series on a deployment of Apache Drill on the Azure cloud. Apache Drill...

Author: Bryan C Smith Date: 05/27/2016

Deploying Apache Drill on Azure

I have a customer interested in leveraging Apache Drill for interactive queries on data resident in...

Author: Bryan C Smith Date: 05/27/2016

Provision an HDInsight Cluster with Tez as Default Hive Execution Engine

There is a lot you can do with Hadoop but I primarily use it to store data I want to loosely...

Author: Bryan C Smith Date: 12/04/2014

Creating a Demo Power BI Data Gateway using an Azure Virtual Machine

PLEASE READ CAREFULLYBefore getting into the topic of this post, I want to clarify that what I am...

Author: Bryan C Smith Date: 03/05/2014

Hadoop for .NET Developers: Working with HDInsight on Azure GA

This last week, HDInsight on Azure became generally available. This is great but with the roll out...

Author: Bryan C Smith Date: 11/02/2013

Hadoop for the .NET Developer: Troubleshooting with the MapReduce Job Logs

NOTE This post is one in a series on Hadoop for .NET Developers.Despite your best efforts, you will...

Author: Bryan C Smith Date: 09/14/2013

Hadoop for .NET Developers: Unit-Testing with the .NET SDK

NOTE This post is one in a series on Hadoop for .NET Developers.Data are problematic and code...

Author: Bryan C Smith Date: 09/13/2013

Hadoop for .NET Developers: Implementing a (Slightly) More Complex MapReduce Job

NOTE This post is one in a series on Hadoop for .NET Developers.In our first MapReduce exercise, we...

Author: Bryan C Smith Date: 09/12/2013

Hadoop for .NET Developers: Understanding Hadoop Streaming

NOTE This post is one in a series on Hadoop for .NET Developers.In the last post, we built a simple...

Author: Bryan C Smith Date: 09/09/2013

Hadoop for .NET Developers: Implementing a Simple MapReduce Job

NOTE This post is one in a series on Hadoop for .NET Developers.In this exercise, we will write and...

Author: Bryan C Smith Date: 09/07/2013

Hadoop for .NET Developers: Understanding MapReduce

NOTE This post is one in a series on Hadoop for .NET Developers.In Hadoop, data processing is...

Author: Bryan C Smith Date: 09/04/2013

Hadoop for .NET Developers: Programmatically Loading Data to AVS

NOTE This post is one in a series on Hadoop for .NET Developers.As mentioned in an earlier post, the...

Author: Bryan C Smith Date: 08/27/2013

Hadoop for .NET Developers: Understanding Azure Vault Storage

NOTE This post is one in a series on Hadoop for .NET Developers.My explanation of Hadoop storage in...

Author: Bryan C Smith Date: 08/27/2013

Hadoop for .NET Developers: Programmatically Loading Data to HDFS

NOTE This post is one in a series on Hadoop for .NET Developers.In the last blog post in this...

Author: Bryan C Smith Date: 08/26/2013

Hadoop for .NET Developers: Manually Loading Data to Hadoop

NOTE This post is one in a series on Hadoop for .NET Developers.To manually load a file to Hadoop,...

Author: Bryan C Smith Date: 08/26/2013

Hadoop for .NET Developers: Understanding HDFS

NOTE This post is one in a series on Hadoop for .NET Developers.From a data storage perspective, you...

Author: Bryan C Smith Date: 08/26/2013

Hadoop for .NET Developers: Obtaining the Sample Data Sets

NOTE This post is one in a series on Hadoop for .NET Developers.In the exercises that follow, we...

Author: Bryan C Smith Date: 08/15/2013

Hadoop for .NET Developers: Setting Up an Azure Cluster

NOTE This post is one in a series on Hadoop for .NET Developers.For rapid provisioning and lack of...

Author: Bryan C Smith Date: 08/14/2013

Hadoop for .NET Developers: Setting Up a Desktop Development Environment

NOTE This post is one in a series on Hadoop for .NET Developers.If you are a .NET developer, you...

Author: Bryan C Smith Date: 08/14/2013

Hadoop for .NET Developers: Basic Architecture

NOTE This post is one in a series on Hadoop for .NET Developers.Hadoop is implemented as a set of...

Author: Bryan C Smith Date: 08/14/2013

Hadoop for .NET Developers: Understanding Hadoop

NOTE This post is one in a series on Hadoop for .NET Developers.Big Data has been a source of...

Author: Bryan C Smith Date: 08/14/2013

Hadoop for .NET Developers

Well, it’s Summer again and time for some new blog entries. This Summer, I’ve had some...

Author: Bryan C Smith Date: 08/14/2013

Presenting Actuals and Forecast Concurrently in a Write-Enabled Cube

I have written a series of entries on writeback applications and wanted to add this last entry...

Author: Bryan C Smith Date: 01/26/2013

UPDATED: Getting the Timeline Filter (Slicer) in Excel 2013 to Work with an Analysis Services OLAP Cube

In Excel 2013, there is a new Timeline filter (slicer) that allows you to easily select a range of...

Author: Bryan C Smith Date: 11/30/2012

Writeback Application Code Samples

In order to help folks get started with writeback applications, I'm posting here an Analysis...

Author: Bryan C Smith Date: 07/20/2012

Managing Writeback Cubes

NOTE This is part of a series of entries on the topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 07/20/2012

Writeback to a Regular Dimension

NOTE This is part of a series of entries on the topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 07/20/2012

Writeback to a Parent-Child Dimension

NOTE This is part of a series of entries on the topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 07/19/2012

Introducing Dimension Writeback

NOTE This is part of a series of entries on the topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 06/20/2012

Allocation across a Parent-Child Hierarchy

NOTE This is part of a series of entries onthe topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 06/19/2012

Understanding Allocations

NOTE This is part of a series of entries on the topic of Building Writeback Applications with...

Author: Bryan C Smith Date: 06/16/2012

Next>