Hadoop – Hive – What is the Version # of Hive Service and Clients that you are running?

Introduction Hadoop is a speeding bullet.  You look online, Google for things, try it out, and sometimes you hit, but often you miss. What do I mean by that? Well this evening I was trying to play with Hive; specifically using Sqoop to import a table from MS SQL Server into Hive. A bit of … Continue reading Hadoop – Hive – What is the Version # of Hive Service and Clients that you are running?

Hadoop – Sqoop – Importing Data (from Microsoft SQL Server)

Pre-requisites Hopefully, you have installed\validated that Hadoop\Sqoop is installed and running properly. If not, please read Technical: Hadoop – Sqoop on Cloudera (CDH) – Is Sqoop Set up and Configured for MS SQL Server (https://danieladeniji.wordpress.com/2013/05/03/technical-hadoop-sqoop-on-cloudera-cdh/ ) Command - import Copy data from Database Table to HDFS File System In the example below, our database & hdfs configuration … Continue reading Hadoop – Sqoop – Importing Data (from Microsoft SQL Server)

Hadoop – Sqoop – Command – Export Data (from HDFS to Microsoft SQL Server)

Introduction Having fun with Hadoop; specifically exporting data with Sqoop. Pre-requisites Hopefully, you have installed\validated that Hadoop\Sqoop is installed and running properly. If not, please read Technical: Hadoop – Sqoop on Cloudera (CDH) – Is Sqoop Set up and Configured for MS SQL Server (https://danieladeniji.wordpress.com/2013/05/03/technical-hadoop-sqoop-on-cloudera-cdh/ ) Generate Sample Data Data, data everywhere but none to share without … Continue reading Hadoop – Sqoop – Command – Export Data (from HDFS to Microsoft SQL Server)

Hadoop – Sqoop on Cloudera (CDH) – Is Sqoop Set up and Configured for MS SQL Server

Introduction As part of my roadmap towards Hadoop understanding, I am looking to how to use Sqoop. What is Sqoop? The name Sqoop is an acronym for "SQL to Hadoop". http://sqoop.apache.org/ Apache Sqoop(TM) is a tool designed for efficiently transferring bulk data between Apache Hadoop and structured datastores such as relational databases. Document Current Configuration … Continue reading Hadoop – Sqoop on Cloudera (CDH) – Is Sqoop Set up and Configured for MS SQL Server