SQL restrictions for time series data

Some SQL statements cannot operate on time series data.

You cannot use the following SQL statements or keywords on TimeSeries columns:
  • Boolean operators (<, <=, <>, >=, or >)
  • SELECT UNIQUE statement
  • GROUP BY clause
  • GROUP BY or ORDER BY clauses
  • FRAGMENT BY clause
  • PRIMARY KEY clause

You cannot use the MERGE statement on a table with time series data.

You cannot use the ALTER TYPE statement on the TimeSeries data type.