Enabling Apache Drill Data Connections

Availability Notes:
  • The packages for enabling Apache Drill Connections are for RHEL 6.x / CentOS 6.x

To use Apache Drill data connections, use the MapR Drill ODBC driver, and add the necessary environment variables. For more informtion, you can reference Installing the Apache Drill ODBC Driver on Linux.

Follow these steps:

  1. Download the MapR Drill ODBC driver, 64-bit. We used the the following driver:

    wget http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC-1.2.1.x86_64.rpm
  2. Login as root, or su to root.
  3. Navigate to the directory that contains the driver *.rpm file.
  4. Enter the following command:

    yum localinstall --nogpgcheck MapRDrillODBC-1.2.1.x86_64.rpm
  5. Edit the following files to setup the ODBC data source for Apache Drill:

    /opt/mapr/drillodbc/Setup/
    odic.ini
    odbcinst.ini
    mapr.drillodbc.ini
  6. Set up the following environment variables for Apache Drill:

    ODBCINI=/opt/mapr/drillodbc/Setup/odbc.ini
    MAPRDRILLINI=/opt/mapr/drillodbc/Setup/mapr.drillodbc.ini
    LD_LIBRARY_PATH=/usr/local/lib:/opt/mapr/drillodbc/lib/64

    In Cloudera Manager,

    1. Select the Configuration tab.
    2. In the Configuration menu, select Arcadia Visualization Server.
    3. Find Arcadia Visualization Server Environment Advanced Configuration Snippet, and add the environment variables.
    4. On the bottom of the interface, enter the reason for the change, such as 'Enabling Apache Drill Connections", and click Save Changes.
    5. Click the Actions menu at the top right corner, and select Restart.
    6. Confirm the restart action.
    Cloudera Manager: Adding environment variables for Apache Drill MapR
    Cloudera Manager: Adding Environment Variables

    In Ambari Stacks,

    1. Select the Dashboards tab.
    2. In the menu on the left, select Arcadia Enterprise.
    3. In the main part of the interface, click the Configs tab.
    4. Scroll in the listed to Advanced arcadia-visualization-server, and expand it to show detail.
    5. In ArcViz Environment, add the environment variables.
    6. Click Save.
    7. Confirm the change in the Save Configuration window modal by clicking Save.
    8. Click OK in the Save Configuration Changes window modal.
    9. Notice the appearance of the Restart Required notification in the interface. Click Restart, and select Restart All Affected.
    Ambari Stacks: Adding environment variables for Apache Drill MapR
    Ambari Stacks: Adding Environment Variables

You can now create new Apache Drill data connections.