Skip to Content
0

Issue while creating series table in HANA VORA

Oct 25, 2016 at 03:25 PM

80

avatar image

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

5mkii.png (14.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank Legler
Feb 28, 2017 at 12:38 AM
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")
Share
10 |10000 characters needed characters left characters exceeded