16.20 - Examples: Invalid Examples with GROUP BY TIME and No Timecode Specification - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
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.