Error Messages Associated with SQLSTATE 0A005
This topic lists the errors associated with the SQLSTATE 0A005.
SQLSTATE 0A005 Description
ERRCODE_PLAN_TO_SQL_NOT_SUPPORTED
Error messages associated with this SQLState
ERROR 6679: Cannot generate annotated query when query contains table that does not have a projection
ERROR 6700: Constant NULLs in NOT-IN clause / Nullaware Anti Join not supported for optimizer-generated annotated queries
ERROR 6739: DML not supported for optimizer-generated annotated queries
ERROR 6770: EXPORT not supported for optimizer-generated annotated queries
ERROR 6866: Meta-function not supported for optimizer-generated annotated queries
ERROR 6889: Optimizer can only generate annotated query for SELECT queries
ERROR 6973: System tables not supported for optimizer-generated annotated queries
ERROR 7114: Query with syntactic hints not supported for optimizer-generated annotated queries
ERROR 7132: Under non-default locale, Multi-level aggregates in set operator sub-queries (except UNION ALL) not supported for optimizer-generated annotated queries
ERROR 7187: Multi-level aggregate queries with more than value grouping sets not supported for optimizer-generated annotated queries
ERROR 7449: Match clause not supported for optimizer-generated annotated queries
ERROR 7666: Query with geometry type not supported for optimizer-generated annotated queries
ERROR 7696: Queries with UDX functions with user defined parameter type of string is not supported
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.