Skip to Content
avatar image
Former Member

Issue while creating series table in HANA VORA

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 28, 2017 at 12:38 AM

    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")
    Add comment
    10|10000 characters needed characters exceeded