duplicate merge

Ahmed

Data Source: Google Analytics

Grain: Weekly

Error message: "[Vertica][VJDBC](3147) ERROR: Duplicate MERGE key detected in join [(cust_foxsports_au.TD10A18E74DD9CA82 x cust_foxsports_au.TD10A18E74DD9CA82_NEW10x20x23x252) using TD10A18E74DD9CA82_NEW10x20x22x231_super and subquery (PATH ID: 1)]; value [1 Mainstream,Fox Sports Australia,All Mobile App Data,100824860,false"

 

Any suggestions?

 

Thanks,

 

Ahmed.

kshah008

Spoiler

 

Hi all,

 

Can anybody help @Ahmed with their question?

Thanks!