Installing the MapR Sandbox with Drill on VirtualBox

About this task

The MapR Sandbox for Drill on VirtualBox comes with NAT port forwarding enabled, which allows you to access the sandbox using localhost as hostname.

Complete the following steps to install the MapR Sandbox with Drill on VirtualBox:

Procedure

Download the MapR Sandbox with Drill file to a directory on your machine: https://www.mapr.com/products/mapr-sandbox-hadoop/download-sandbox-drill
Open the virtual machine player.
Select File > Import Appliance. The Import Virtual Appliance dialog appears.
Navigate to the directory where you downloaded the MapR Sandbox with Drill and click Next. The Appliance Settings window appears.
Select the check box at the bottom of the screen: Reinitialize the MAC address of all network cards, then click Import. The Import Appliance imports the sandbox.
When the import completes, Click General. The VirtualBox - Settings dialog appears.
Select Network. The correct setting depends on your network connectivity when you run the Sandbox. In general, if you are going to use a wired Ethernet connection, select NAT Network. If you use ODBC or JDBC on a remote host, select Bridged Adapter. If you are going to use a wireless network, select Host-only Networks and the Host-Only Ethernet Adapter.
Click OK to continue.
Click Start. It takes a few minutes for the MapR services to start. After the MapR services start and installation completes, a screen that displays the following message appears: Note: The URL provided corresponds to the Web UI in Drill.
```
MapR-Sandbox-For-Apache-Drill-<version> installation finished successfully. 
Please go to http://127.0.0.1:8047 to begin your experience. 
Open a browser on your host machine and enter the URL in the browser's address field. 
You can access the host via SSH by ssh mapr@localhost -p 2222
Log in to this virtual machine: Linux/Windows <Alt+F2>, Mac OS X <Options+F5>
```
NOTE: The URL provided corresponds to the Web Console in Drill. If you used a bridged adapter, the network generates and assigns an IP to the sandbox that you use in place of 127.0.0.1. To get the IP address, log in to the sandbox, using Alt+F2 on Windows or Option+F5 on Mac or Linux. Enter root as the username and mapr as the password. Enter ifconfig to get the sandbox IP address. The IP address is located in the inet address field. You can log in to Drill using the IP address and port 8047.
Example:
```
http://10.250.56.216:8047
```
The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s).If a DNS entry does not exist, create the entry for the Drill node(s).
- For Windows, create the entry in the %WINDIR%\system32\drivers\etc\hosts file.
- For Linux and Mac, create the entry in /etc/hosts.<drill-machine-IP> <drill-machine-hostname>Example: 127.0.1.1 maprdemo

Results

Navigate to http://localhost:8047 to experience the Drill Web UI, or log into the sandbox through the command line. Login using ssh as described in Getting to Know the Drill Sandbox on the Apache Drill web site. When prompted, enter mapr as the login name and password. Alternatively, access the command line on the VM: Press Alt+F2 on Windows or Option+F5 on Mac.