Search found 1 match
- Sat Feb 28, 2015 8:17 pm
- Forum: Vertica Migration
- Topic: Teradata to Vertica Migration: problem with RESET WHEN
- Replies: 1
- Views: 17027
Teradata to Vertica Migration: problem with RESET WHEN
Hi! Can anybody help me? I'm trying migrate views from Teradata to Vertica 7.1: In Teradata: Select PER_ID, CONTACT_ID, START_DT, PREV_CONTACT_ID, ROW_NUMBER() Over (Partition By PER_ID Order By START_DT RESET WHEN PREV_CONTACT_ID Is Null) As CONTACT_SERIES FROM .... Where .... But in Vertica does n...