Examples: Distinguish between Multiple Candidate Columns - Analytics Database - Teradata Vantage

Example: USING TIMECODE Clause with Multiple Candidate Columns

The example shows explicitly specifying the USING TIMECODE clause in a join:

select avg(b.temperature)
from ocean_buoys_seq a , ocean_buoys_seq b
group by time(minutes(100))
using timecode(a.td_timecode); 

Example: Invalid Example with Ambiguous Multiple Candidate Columns

The example shows that the timecode is ambiguous without specifying the USING TIMECODE clause in this join:

select avg(a.temperature)
from ocean_buoys_seq a, ocean_buoys b
group by time(minutes(100));

Result:

 *** Failure 4359 Time Series: Timecode specification is ambiguous.