More Big Data in SAP Cloud Appliance Library with SAP HANA Vora 1.2

Hello Folks,

Earlier today we published the SAP HANA Vora 1.2 appliance in our repository. As this is the first Vora in CAL I decided to write this short blog to give you quick start with the appliance.

To create new instance in Amazon WS follow this link and provide details for your cloud provider account and master password for the instance. This password will be set to the ‘vora’ operating system user and to Ambari ‘admin’. More details on users and credentials as well as on the installed components can be found in the appliance Getting started guide.

By default Zeppelin and Web Tools ports are not open. You need to open them first in order to use these tools. It is highly recommended to limit the IP addresses which have access to these ports:

To open Zeppelin interface which comes with the appliance you need to follow the ‘Connect’ button of the created Vora instance and then choose the respective link in CAL:

You will see the following screen. There you’ll find some example queries in the ‘DemoData’ note:

In it you can see number of Vora queries like for example the following which creates Vora table:

%vora CREATE TABLE SALES

  (CUSTOMER_ID string, YEAR string, REVENUE long)

USING com.sap.spark.vora

OPTIONS

  (tableName “SALES”, paths “/user/vora/sales_data.csv”)

Finally you can enjoy the nice charts of Zeppelin by selecting data via Vora queries.

As part of this appliance we also deliver the new Vora Modeling tool. You can find further details on it in this article.

Enjoy!

Ventsislav