17.10 - Examples: Invalid Examples with GROUP BY TIME and No Timecode Specification - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)

If there are no PTI tables from which to infer the timecode an error is returned.

In the following examples, the USING TIMECODE clause is required because none of the source tables are PTI tables.

sel avg(a.temperature), mode(b.temperature)
from non_pti_tbl_seq a inner join ocean_buoys_nonpti b
on a.buoyid = b.buoyid
group by time(minutes(10));

*** *** Failure 4359 Time Series: GROUP BY TIME clause may not be used without a TIMECODE specification.
sel avg(a.temperature), mode(b.temperature)
from non_pti_tbl_seq a, ocean_buoys_nonpti b
group by time(minutes(10));
 
 *** Failure 4359 Time Series: GROUP BY TIME clause may not be used without a TIMECODE specification.
sel avg(a.temperature), mode(a.temperature)
from non_pti_tbl_seq a
group by time(minutes(10));

 *** Failure 4359 Time Series: GROUP BY TIME clause may not be used without a TIMECODE specification.