Skip to Content
0
Nov 26, 2020 at 03:11 PM

SAP HANA - Cannot create a time series table

53 Views

Hello,

I'm trying to create a time series column table (based on an example) in our SAP HANA Cloud environment.

However, when running the SQL script in the SQL Console of the SAP HANA Data Explorer I get the following error:

Could not execute 'CREATE COLUMN TABLE MyTab ( profile_id INT, ts TIMESTAMP, consumption DECIMAL(4,3)) ...'
Error: (dberror) [257]: sql syntax error: incorrect syntax near "SERIES": line 5 col 4 (at pos 101)

Do I need additional configuration, .. when trying to use SERIES or what am I missing?

Thanks.

Guy

CREATE COLUMN TABLE MyTab (
    profile_id INT,
    ts TIMESTAMP,
    consumption DECIMAL(4,3))
    SERIES(
        SERIES KEY(profile_id)
        PERIOD FOR SERIES(ts)
        EQUIDISTANT INCREMENT BY INTERVAL 1 HOUR MISSING ELEMENTS ALLOWED
        MINVALUE '2010-01-01'
        MAXVALUE '2015-01-01');