Error Messages Associated with SQLSTATE 42703
This topic lists the errors associated with the SQLSTATE 42703.
SQLSTATE 42703 Description
ERRCODE_UNDEFINED_COLUMN
Error messages associated with this SQLState
ERROR 2359: Cannot assign to field "string" of column "string" because there is no such column in data type string
ERROR 2625: Column "string" does not exist;
Vertica does not support 'SELECT <table_name> FROM <table_name>'
ERROR 2633: Column "string" named as primary key does not exist
ERROR 2634: Column "string" not found in data type string
ERROR 2635: Column "string" of relation "string" does not exist
ERROR 2636: Column "string" specified in USING clause does not exist in left table
ERROR 2637: Column "string" specified in USING clause does not exist in right table
ERROR 2643: Column string does not exist
ERROR 2644: Column string does not exist in table
ERROR 2651: Column string must be loaded or computed
ERROR 2656: Column string.string does not exist
ERROR 2870: Could not identify column "string" in record data type
ERROR 4450: Projection "string" does not contain column "string"
ERROR 6695: Column "string"."string" must have CHAR, VARCHAR, LONG VARCHAR, VARBINARY, LONG VARBINARY, or USER DEFINED type
ERROR 7009: Tokenizer must have a "string" column output for stemming
ERROR 7167: Column "string" does not exist on table "string"
ERROR 7367: After excluding columns, no input column remains
ERROR 7959: Column [string] does not exist in relation [string]
ERROR 7984: Column [string] is duplicated in parameter string
ERROR 9057: Field "string" does not exist
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.