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:
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
Login as root
, or su
to root
.
Navigate to the directory that contains the driver *.rpm
file.
Enter the following command:
yum localinstall --nogpgcheck MapRDrillODBC-1.2.1.x86_64.rpm
Edit the following files to setup the ODBC data source for Apache Drill:
/opt/mapr/drillodbc/Setup/
odic.ini
odbcinst.ini
mapr.drillodbc.ini
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 ,
Select the Configuration tab.
In the Configuration menu, select Arcadia
Visualization Server .
Find Arcadia Visualization Server Environment Advanced Configuration
Snippet , and add the environment variables.
On the bottom of the interface, enter the reason for the change, such as 'Enabling
Apache Drill Connections", and click Save Changes .
Click the Actions menu at the top right corner, and select
Restart .
Confirm the restart action.
Cloudera Manager: Adding Environment Variables
In Ambari Stacks ,
Select the Dashboards tab.
In the menu on the left, select Arcadia Enterprise .
In the main part of the interface, click the Configs tab.
Scroll in the listed to Advanced arcadia-visualization-server ,
and expand it to show detail.
In ArcViz Environment , add the environment variables.
Click Save .
Confirm the change in the Save Configuration window modal by
clicking Save .
Click OK in the Save Configuration
Changes window modal.
Notice the appearance of the Restart Required notification in
the interface. Click Restart , and select Restart All
Affected .
Ambari Stacks: Adding Environment Variables
You can now create new Apache Drill data connections.