Hue is an interface for interacting with web applications that access the MapR Distributed File and Object Store (MapR XD). Use the applications in Hue to access MapR-FS, work with tables, run Hive queries, MapReduce jobs, and Oozie workflows.
The MapR Sandbox for Hadoop includes brief overviews and tutorials for the following Hue applications:
The tutorials are designed to help get you acquainted with HUE and MapR-FS. Use the tutorials to perform the following operations:
Before You Begin
Download the following files for use in the tutorials:
Login to Hue
File Browser is an application that you can use to access files and directories in the MapR Distributed File and Object Store (MapR XD). Use File Browser in HUE to perform the following directory tasks:
In this tutorial, create a new directory, and upload the customers.csv file.
Create a new directory:
Upload a file:
Next: Use Metastore Manager to create a table from the customers.csv file that you just uploaded.
Metastore Manager is an application that you can use to manage databases, tables, and partitions stored in a relational database that applications, like HIVE, access through the metastore service API.
Use Metastore Manager to perform the following table operations:
Use Metastore Manager to perform the following database operations:
In this tutorial, import the customer.csv file, and create a table from the file.
Import the customer.csv file:
In the Input file field, browse to the CustomerDirectory, and upload the customer.csv file
Select the Import data from file checkbox.
Choose a delimiter:
Define your columns:
Next: Use Beeswax to run a Hive query on the table.
Beeswax is an application for querying data in Hive. Hive is a data warehouse system for Hadoop that uses an SQL-like language to query structured data in the MapR Distributed File and Object Store (MapR XD). You can access Beeswax from the HUE interface to run Hive queries with Hive's Query Language (HQL) and then save the queries.
In this tutorial, use Beeswax to run a basic Hive query against the customer_table you created.
Create and run a query: