Skip to Content
avatar image
Former Member

SAP HANA series data

HI All,


I am trying to create a Time series table using CREATE TABLE statment with SERIES keyword. I am getting an errorlikewise, when trying to use SERIES related functions as well I get an error. Can someone tell if there are any pre-requisites to be done before using the SERIES related functionalities.


When I try to create a table with SERIES keyword, I get the following error:

----------------------------------------------------------------------------------------------------------------------------

Could not execute 'CREATE COLUMN TABLE SERIES_DATA.MACHINE_READINGS ( SENSOR VARCHAR(15), TIMER TIMESTAMP, READING ...'
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "SERIES": line 6 col 1 (at pos 123)


Likewise, when trying to access the function SERIES_GENERATE_TIMESTAMP, I get an error too. The error is as below:

-----------------------------------------------------------------------------------------------------------------------

Could not execute 'INSERT INTO SERIES_DATA.MACHINE_READINGS ( -- the following is manufactured / fake data SELECT ...'
SAP DBTech JDBC: [328]: invalid name of function or procedure: SERIES_GENERATE_TIMESTAMP: line 8 col 3 (at pos 182)

-----------------------------------------------------------------------------------------------------------------------

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 16, 2017 at 05:52 AM

    You have written in the comments that you are using HANA revision 1.00.80.00.391861 which is HANA 1.0 SPS08. Time series functionality was introduced with HANA 1.0 SPS09, therefore on your system that functionality is not available.

    As your used HANA version is pretty old and w/o support anymore, it is recommended to upgrade to a current version.

    Best Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded