Skip to Content
Author's profile photo Balaji Krishna

SAP HANA Vora 1.3 – What’s New overview

SAP HANA Vora 1.3 was made Generally Available on Dec16th 2016, With this release we extend the capabilities of Vora to deliver features beyond SQL modeling by proving three new engines to enable multi modal capabilities with Vora.

By continuing to leverage the Apache Hadoop and Apache Spark technologies, Vora1.3 natively delivers the following engines to extend data processing in the BigData landscape,

Time Series – A distributed in-memory engine that enables time series data to be efficiently stored and analyzed in distributed environments. It supports highly compressed time series storage and time series analysis algorithms that work directly on top of the compressed data, providing features such as standard aggregation, granularization, and advanced analysis.

Graph engine – A distributed in-memory engine that supports graph processing and allows you to execute commonly used graph operations on data stored in SAP HANA Vora.

Document Store (JSON) – A distributed in-memory JSON document store that supports rich query processing over JSON data. The document store uses a special binary JSON format and supports schema-less tables. By combining JSON with most of the regular SQL features, it allows you to use SQL for JSON as well

Vora 1.3 also introduces the concept of memory-to-disk “spill over”by using a disk engine which enables storage and processing of petabytes of data

Apart from the above features Vora1.3 also enhanced the OLAP features by providing new functionality like Unit Of Measure (UoM) conversions. In this release we deliver the Currency Conversion feature which can be used from Vora modeler when building SQL models on top of HDFS/S3/Swift data stored on HDFS or on the cloud.

Vora1.3 also simplifies the install and configuration process by continuing to integrate the installer thru Hadoop Admin tools like Cloudera Manager, Ambari, MapR CS and in this version we deliver a new Vora Manager UI for easier administration and monitoring of the different Vora service

One of the key challenges and opportunities in the BigData landscape is on how to effectively secure the cluster and all communications around it. In this release SAP HANA Vora extends the Kerberos configuration to allow secure connections between the various Vora components and Hadoop/HDFS components

SAP HANA Vora Modeler has been enhanced to deliver several new features like interacting with Time Series data, extend hierarchies to create parent-child hierarchies and level-based hierarchies and enhancing the expression editor.

Learn more about these different features in additional blogs by Jason and Puntis on the new engine features and also listen to the recording of the 1.3 (beta) webinars. Stay tuned for more webinars in early 2017 on more Vora webinars.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi, nice blog! It contains a link to SAP JAM it seems, although it's published externally. Thanks & regards Antoine

      Author's profile photo Balaji Krishna
      Balaji Krishna
      Blog Post Author

      that is correct Antoine, the webinars were hosted by HANA International Focus Group and they have an external JAM group where you can register and listen to live or recorded webinars

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Thanks Balaji. Can I kindly suggest you to indicate to the readers how to register to this external JAM group? Currently if I click the link, this is what I get and I don't know what to do next.

      Author's profile photo Former Member
      Former Member

      Hi Antoine,

      it has probably nothing to do with Vora, but I had a very mixed luck with Jam. I once had access to certain content there, but it had been withdrawn and i never got it back, so not sure how it helps communicating with the external community.

      thx, greg
       

      Author's profile photo Sainath Kumar
      Sainath Kumar

      Nice Blog!!

      Author's profile photo Sainath Kumar
      Sainath Kumar

      Hi Balaji

      Do we have any SAP documentation on Vora modeling and architecture. I have gone thought HA500, it covers basic aspects of Vora usage and capabilities  .

      It will be great if we can have additional documentation around Vora modeling and integration with HANA and SAP PA 3.1.

      Thank you

      Author's profile photo Former Member
      Former Member

      Hi Balaji,

      I have problem with vora server start below erroe can you give solutation asap

       

      Error occurred while starting all services: vora-dlog refused to start. Cannot continue Start All Jobs. Error: There are no health checks registered for service vora-dlog.

      Author's profile photo Jason Hinsperger
      Jason Hinsperger

      Check the nodes running DLog and your DLog configuration to make sure there is enough disk space to create the required log files.

      You should post this as a question on https://answers.sap.com and be sure to tag it "SAP Vora"

       

      --Jason

       

      Author's profile photo Former Member
      Former Member

      Author's profile photo Nazim Valiyev
      Nazim Valiyev

      Hi Balaji,

      Thanks for your blog!

      I tried to install Vora 1.3 with CDH 5.7 and CentOS 6.7, but many of the services just wouldnt start.

      Then I installed Vora 1.4 with CDH 5.11 and CentOS 6.8. The installation completed smoothly without any warning or errors.

      From /var/log/vora/vora-thriftserver/vora-thriftserver.log I get following error:

      17/06/21 12:11:41 INFO ql.Driver: Compiling command(queryId=vora_20170621121111_95ce0e5a-667c-4b97-8615-c443bca0c925): SELECT KEY, VALUE FROM SYS_SESSION_CONTEXT WHERE SECTION = 'SparkContext' AND  KEY IN ('spark.hana.host', 'spark.hana.instance', 'spark.hana.user')
      ...
      ...
      Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:23 Table not found 'SYS_SESSION_CONTEXT'

      I don't know anymore what else I can do.
      Thank in advance
      Nazim