During the last month, I’ve been testing the connectivity of SAP Lumira to Cloudera, and thought of documenting the steps to show how easy it is and no scripting is required:

SAP Lumira allows you to connect to Cloudera Distribution for Hadoop (CDH). Once connected, you can do ad-hoc visualization of the data so you can see patterns and outliers. You can’t get value from your data unless you can see what’s inside of it.

Two Ways to connect: Using Cloudera Impala OR  Using Apache Hadoop Hive

In this blog, Cloudera Impala is used. For Apache Hadoop Hive, Please click here

1. Launch SAP Lumira:

  /wp-content/uploads/2015/03/1_668204.png

2. Acquire Data Or File>>New>>Query with SQL

  /wp-content/uploads/2015/03/2_668205.png

3. Select Cloudera Impala 1.0 Simba ….etc >> Next

/wp-content/uploads/2015/03/3_668206.png

4. Enter security credentials, server and port for your and hit Connect

/wp-content/uploads/2015/03/4_668207.png

5. Initial screen

/wp-content/uploads/2015/03/5_668208.png

6. Click and expand the nodes in the catalog to view to the tables you have in your CDH

/wp-content/uploads/2015/03/6_668209.png

  • You can also search for a table name form the text box

  /wp-content/uploads/2015/03/7_668210.png

7. To select all the data in a certain table, click on the table and the impala scrip will be generated automatically

/wp-content/uploads/2015/03/8_668211.png

  • To filter / Join / Union / Group the data / tables, you can modify / write impala statements

  /wp-content/uploads/2015/03/9_668213.png

8.  Click on Create

  /wp-content/uploads/2015/03/10_668214.png

  • Data set is now is SAP Lumira and data can be prepared visualized …..etc.

  /wp-content/uploads/2015/03/11_668215.png

enjoy  🙂

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply