[SAP HANA Academy] Discover How to Upgrade SAP HANA Vora

The SAP HANA Academy’s Tahir Hussain Babar (Bob) walks through how to upgrade a SAP HANA Vora system in a series of three videos.

All of the scripts Bob uses through out this tutorial series are available here on GitHub.

Testing the Existing System and Deleting the Zookeeper Cache

During the first video Bob shows how to test the existing SAP HANA Vora system. Bob then goes on to detail how to delete the Zookeeper client cache to ensure that any tables that were previously created are deleted.

Bob has built a SAP HANA Vora installation on top of Hadoop which he created with Ambari. To test his SAP HANA Vora installation Bob opens PuTTY for his Vora instance and logs in as the HDFS user and confirms that a file called test.cvs he previously loaded in the single node SAP HANA Vora install series is still there. Bob then logs in as the Vora user and notes the files that will need to be replaced during the upgrade.

Bob then starts Spark Shell to test the Vora add-ons to Apache Spark. First, Bob imports the SapSQLContext and then runs a script to create a table in SAP HANA Vora that points to the path of the test.csv file in HDFS. If you’re able to run a select * statement to show the table’s data then your SAP HANA Vora system is working.

When you create a table in SAP HANA Vora using the Spark Shell the tables don’t exist. Going back into a restarted Spark Shell Bob doesn’t see the table he just created. Spark Shell only creates temporary tables but the metadata of the process is kept in Zookeeper. Therefore, before upgrading SAP HANA Vora you should empty your Zookeeper client.

To accomplish this import another context called .com.sap.spark.velocity.client. This context’s name may change depending on which version of Vora you’re upgrading from. Then Bob runs the command pictured below and includes the IP address for each of the servers that are running Zookeeper. This command clears out the Zookeeper cache so the next time you run it you will have a false message returned.

How to Remove the SAP HANA Vora Service from Ambari and How to Delete the SAP HANA Vora Folder

In the second video of the series Bob shows how to de-install the SAP HANA Vora service from the Hadoop cluster in Ambari. After, Bob details how to de-install the SAP HANA Vora extensions from the Hadoop Linux server.

First, in Ambari Bob stops the SAP HANA Vora service. Bob then navigates to the webpage pictured below where a list of the services that are installed on his Hadoop cluster is displayed.

Back in PuTTY as the Vora user Bob runs the curl command pictured below to delete the SAP HANA Vora service.

After de-installing the service, Bob restarts Ambari using the EC2 user in PuTTY. Next back in PuTTY as the Vora user, Bob navigates to the Vora folder to view the Vora extensions and then deletes the folder with a rm -r command. This removes the extensions from the Linux server.

To conclude the video, Bob as the EC2 user, uploads the upgraded Vora installation files from his dropbox.

Re-installing and Testing SAP HANA Vora

In the final video of the series Bob details how to re-install SAP HANA Vora. The installation process is covered more thoroughly in this video from the single node SAP HANA Vora installation series.

In PuTTY as the EC2 user, Bob runs the script pictured below to execute a package with the upgraded Ambari service.

Then after restarting Ambari, Bob chooses to add the new version of SAP HANA Vora as a service.

Bob keeps the default settings when following the simple steps of the add service wizard before he deploys the new SAP HANA Vora service. After, Bob starts and stops all of the Hadoop services in Ambari.

Now back in PuTTY, Bob logs in as the Vora user and installs in a newly created folder a package that contains all of the new SAP HANA Vora scripts and services.

Finally Bob tests the upgraded version of SAP HANA Vora using Spark Shell. After importing the SapSQLContext and assigning it to the variable with the new version, Bob creates a table using the same script he used in the first video of this series. The table’s path points to the text.csv file from HDFS. Bob again confirms the table’s creation by viewing its data with a select * statement.

In these three videos Bob has shown how to upgrade a SAP HANA Vora system on a single node. First, Bob cleared the Zookeeper cache. Then Bob de-installed the SAP HANA Vora service from Ambari and removed the scripts that contained the Vora extensions from the Linux server. Lastly, Bob installed the upgraded version of SAP HANA Vora and tested it’s connection by creating a SAP HANA Vora table in Spark Shell.

For more SAP HANA Vora tutorial videos please check out this playlist

SAP HANA Academy – Over 1,200 free tutorial videos on SAP HANA, SAP Analytics and the SAP HANA Cloud Platform.

Follow us on Twitter @saphanaacademy and connect with us on LinkedIn.