Using Time Series Tables and Operations
Teradata Vantage™ - Time Series Tables and Operations provides information on creating and manipulating Primary Time Index (PTI) tables for storing time series data. It describes a suite of aggregate functions that you can use to perform time-aware aggregate operations on time series data.
Why Would I Use this Content?
Time series data is unstructured machine-generated sensor data that is continuously produced and collected by a wide range of applications and devices that make up the Internet of Things. This guide helps you to understand and use time-series functions, and how Teradata Vantage™ uses the time information to organize the data across the system.
How Do I Use this Content?
Time series tables are similar to standard, non-PTI Vantage tables, but include a primary time index (PTI) rather than a primary index (PI). Use this guide to learn about the differences of PTI tables and as a reference for time-series functions.
How Do I Get Started?
Learn about the difference between PTI and non-PTI tables, and the restrictions for PTI tables, then use the document as a reference for the PTI functions.