cancel
Showing results for 
Search instead for 
Did you mean: 

Issue while creating series table in HANA VORA

Former Member
0 Kudos

Hi All,

I am trying to create one time series table in VORA but i am getting below error. Any input on this would be a great help. Thanks

Please find the below error message.

Pankaj

Accepted Solutions (0)

Answers (1)

Answers (1)

Please check the Vora Developer Guide at https://help.sap.com/viewer/product/SAP_HANA_VORA/1.3/en-US -> chapter '7 Accessing the Engine Data Sources' -> Parsed DDL Syntax -> <DDL_statement> using com.sap.spark.engines OPTIONS (<comma-separated-pairs-list>)

In your example the SQL should be:

  CREATE TABLE SERIES_TAB (TIME_1 TIMESTAMP) SERIES (PERIOD FOR SERIES TIME_1) using com.sap.spark.engines 

If you want to load some data it could look e.g. like this:

  CREATE TABLE SERIES_TAB2 (TIME_1 TIMESTAMP) SERIES (PERIOD FOR SERIES TIME_1) using com.sap.spark.engines OPTIONS (files "/user/vora/ts_test.csv")