Introduction As a data-warehouse project, Hive does not support the traditional singleton database insert record statements. Data inserts has to be through bulk-record modes. One of those avenues is through a built-in load statement. Data Model Data Model - Logical Looked online for sample data models that are representative of familiar data entities. And, the … Continue reading Hadoop – Hive – Loading Data
Technical: Hadoop - Hive - Review Settings (Using the set command) Background Fresh off another install Hadoop \ Hive, I googled on some items and found Apache's own Hive documentation. As per the install, I have found Cloudera's install to be a bit clearer; as I can just install via RPMs. For Apache's install, I … Continue reading Technical: Hadoop – Hive – Review Settings (Using the set command)
Pre-requisites There are quite a few pre-requisites that should be met prior to installing and running Hive. They include: Have in a place a base Hadoop install (HDFS, Map Reduce v1 or v2). A working demo is available @https://danieladeniji.wordpress.com/2013/05/12/hadoopcloudera-v4-2-1-installation-on-centos/ Having one of supported databases installed. This database is needed by the metastore. A mySQL implementation is … Continue reading Hadoop/Cloudera [CDH]/Hive v2 – Installation
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?