Skip to Content
0

SAP HANA series data

Mar 01, 2017 at 11:23 AM

59

avatar image

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)

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

10 |10000 characters needed characters left characters exceeded

What HANA version you are using?

0

The version in of HDB is 1.00.80.00.391861

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Mar 16, 2017 at 05:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded