Use SAP Lumira to tap into the power of big data and see patterns emerge in front of your eyes. Lumira allows you to visualize data with an intuitive drag-and-drop interface and uncovers outliers and trends with engaging visualizations and stories. Organizations can maximize business knowledge with big-picture insights and granular details. Lumira lets you quickly process large volumes of data and reduce time to insight.
This demo shows the power of business insights gained from SAP Lumira and Apache Drill on Hadoop by combining data from multiple sources without complex or time-consuming ETL. In this example, sensor data (JSON) is being gathered from a variety of sensors along with packet data. You can see how SAP Lumira in combination with Drill queries helps you easily identify failed sensors and the root cause of the problem.
Creating a Lumira and Drill Sandbox with Example Data
How about a test drive of Lumira with Apache Drill in your own environment, giving you the ability to query JSON files directly with SQL and do more, faster? With just a few steps you can connect Lumira to your Drill cluster and run example queries on our sandbox data shown in the below demo video.
These steps assume the following:
- You have deployed at least one Drill node in distributed mode, according to the instructions here. Consult this page for an overview of Drill and the requirements for getting started.
- You know the hostname and quorum name to connect to ZooKeeper. For more information, consult this page for Drill in a ZooKeeper/clustered environment.
Complete these steps to connect Lumira to your Drill cluster:
- Download SAP Lumira Desktop and follow the instructions for installation on your laptop/workstation.
- Download the sample data from MapR into your Drill installation. To get started quickly you can extract them into ‘/tmp’, then decide on a permanent location later.
- Perform the following steps in Lumira to setup the JDBC connection. You may need to press the '30 Days Trial' button to begin using the software.
- Create a new data connection by selecting, Select File -> New, then 'Query with SQL'.
- In the 'New Dataset' window, select 'Show All', then select the 'Generic JDBC Datasource' option and click the 'Install' button in the lower right of the screen.
- Obtain the file $DRILL_HOME/jars/jdbc-driver/*.jar file from your Drill installation and copy it to the machine running Lumira.
- Select the 'Generic JDBC Datasource' option and click 'Install Drivers' at the top right of the screen. Browse to the .jar file you copied earlier.
- Select 'Done' and restart the application if prompted.
- Return to the same screen (File -> New, etc.) and select the Generic JDBC Datasource which should now be shown with a green icon.
- Enter anything for the username/password (i.e. none/none).
- For JDBC URL, type: jdbc:drill:zk=[host][port]/drill/[quorumname], where [host] is the hostname and port for the ZooKeeper connection.
- For JDBC Class, enter org.apache.drill.jdbc.Driver.
You should now be able to run example queries by browsing to the sample data (that you extacted in a previous step) and running SQL queries. For a few examples, consult the video above. Happy Drilling!