SAP HANA series data

[Former Member]

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)

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

[pfefferf]

What HANA version you are using?

[Former Member]

The version in of HDB is 1.00.80.00.391861

[pfefferf · Accepted solution]

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