Can anyone tell me why my syntax is wrong and a fix? Obviously it's the PERIODICITY_HINT, but I'm doing what the BOL says...
ALTERMININGSTRUCTURE [zzz]
ADDMININGMODEL [xxx]
(
...
)
UsingMicrosoft_Time_Series (
PERIODICITY_HINT = {12},
AUTO_DETECT_PERIODICITY=0.1
)
I get this error:
Query (9, 24) Parser: The syntax for '{' is incorrect.
The parameter type of PERIODICITY_HINT is string, therefore it needs to be quoted, e.g.
ALTERMININGSTRUCTURE [zzz]
ADDMININGMODEL [xxx]
(
...
)
UsingMicrosoft_Time_Series (
PERIODICITY_HINT = '{12}',
AUTO_DETECT_PERIODICITY=0.1
)
No comments:
Post a Comment