Error Messages Associated with SQLSTATE 42701

This topic lists the errors associated with the SQLSTATE 42701.

SQLSTATE 42701 Description

ERRCODE_DUPLICATE_COLUMN

Error messages associated with this SQLState

ERROR 2629: Column "string" is already of type "string"
ERROR 2638: Column "string" specified more than once
ERROR 2654: Column string specified more than once
ERROR 2655: Column string specified more than once in options list
ERROR 2662: Column name "string" already exists
ERROR 2663: Column name "string" appears more than once in USING clause
ERROR 2664: Column name "string" does not exist
ERROR 3144: Duplicate column string in ORDER BY list
ERROR 3145: Duplicate column name
ERROR 3150: Duplicate projection column name (projection: string)
ERROR 3154: Duplicated parameter "string" in parameter list
ERROR 5450: View definition can not contain duplicate column names "string"
ERROR 5878: Failed to create table string: duplicate column name string

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.