This article explains Vertica error 3149, which occurs when a query encounters multiple rows for a key expected to be unique during join operations. The error does not necessarily indicate duplicate rows in the base table.
Environment
- Vertica Database
- SQL queries involving joins
- Tables with primary or unique key constraints
Situation
A query failed with the following error:
ERROR 3149: Duplicate primary/unique key detected in join …; value [8564233]
Find complete article on support portal
