Search found 1 match

by heikikr
Sat Feb 28, 2015 8:17 pm
Forum: Vertica Migration
Topic: Teradata to Vertica Migration: problem with RESET WHEN
Replies: 1
Views: 16888

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...

Go to advanced search