This demo shows how to run an example in BigSQL that uses Hive, Hadoop, PostgreSQL, and the Hadoop Foreign Data Wrapper to leverage the power of Hadoop from within PostgreSQL. This tutorial uses BigSQL 9.3 Release 2 – Beta2, which includes Hadoop-2.2 and Hive-0.12. You can download the newest release, or the Quick start VM for VMware, at BigSQL.org.
In fewer than four minutes this tutorial will show you how to:
- Create a Hive tables
- Load a CSV file into a Hive table
- Set up the Hadoop Foreign Data Wrapper in PostgreSQL
- Access data in Hadoop from PostgreSQL