Error Messages Associated with SQLSTATE 0A000

This topic lists the errors associated with the SQLSTATE 0A000.

SQLSTATE 0A000 Description

ERRCODE_FEATURE_NOT_SUPPORTED

Error messages associated with this SQLState

ERROR 2009: string can not be used in function string
ERROR 2013: string clause is not supported for expressions
ERROR 2014: string Concatenated GZIP/BZIP is not supported with NATIVE/NATIVE VARCHAR formats
ERROR 2036: string is not a legal time unit
ERROR 2058: string VIEW is not supported
ERROR 2089: A correlated column in a subquery expression is not supported 
ERROR 2114: ADD COLUMN over temporary tables is not supported
ERROR 2130: Aggregate function string (value) is not supported
ERROR 2133: Aggregate function calls cannot contain subqueries
ERROR 2138: Aggregate functions can only be called on columns of a table
ERROR 2161: ALL subquery with a correlated expression is not supported
ERROR 2165: ALTER COLUMN TYPE over temporary tables is not supported
ERROR 2166: ALTER TABLE does not support ADD COLUMN with other clauses
ERROR 2167: ALTER TABLE does not support ALTER COLUMN TYPE with other clauses
ERROR 2168: ALTER TABLE does not support DROP COLUMN with other clauses
ERROR 2169: ALTER TABLE does not support SET SCHEMA with other clauses
ERROR 2178: An expression containing a correlated subquery with aggregate function is not supported
ERROR 2183: Analytic functions are not allowed in an ORDER BY on a UNION/INTERSECT/EXCEPT
ERROR 2184: Analytic functions are not supported in the ORDER BY of an analytic function OVER clause
ERROR 2190: Analytics query with having clause expression that involves aggregates and subquery is not supported
ERROR 2192: ANALYZE_CONSTRAINTS is currently not supported in non-default locales
ERROR 2208: Another Design/Deployment is in progress
ERROR 2210: ANTI join with segmented inner not supported
ERROR 2220: Argument string must not contain subqueries
ERROR 2226: Argument to seeded random_must be a constant
ERROR 2233: Array References are not supported
ERROR 2235: ArrayExpr is not supported
ERROR 2329: Cannot accept a value of type any
ERROR 2330: Cannot accept a value of type anyarray
ERROR 2331: Cannot accept a value of type anyelement
ERROR 2332: Cannot accept a value of type internal
ERROR 2333: Cannot accept a value of type language_handler
ERROR 2334: Cannot accept a value of type opaque
ERROR 2335: Cannot accept a value of type trigger
ERROR 2340: Cannot add IDENTITY/AUTO-INCREMENT columns
ERROR 2350: Cannot alter type of column "string" since it is referenced in the constraint "string"
ERROR 2351: Cannot alter type of column "string" since it is referenced in the default expression of column "string"
ERROR 2352: Cannot alter type of column "string" since it is referenced in the partition expression
ERROR 2353: Cannot alter type of column "string" since it is referenced in the segmentation expression of projection "string"
ERROR 2354: Cannot alter type of column with a default expression
ERROR 2360: Cannot assign to system column "string"
ERROR 2363: Cannot broadcast non-subquery outer input to a join
ERROR 2368: Cannot change owner of temporary table
ERROR 2377: Cannot convert column "string" from "string" to type "string"
ERROR 2392: Cannot delete from a view
ERROR 2399: Cannot display a value of type any
ERROR 2400: Cannot display a value of type anyelement
ERROR 2401: Cannot display a value of type internal
ERROR 2402: Cannot display a value of type language_handler
ERROR 2403: Cannot display a value of type opaque
ERROR 2404: Cannot display a value of type trigger
ERROR 2407: Cannot drop a table column when a node is down
ERROR 2411: Cannot drop column "string" since it is referenced in the partition expression
ERROR 2412: Cannot drop column "string" since it is referenced in the primary key constraint
ERROR 2425: Cannot export virtual string string
ERROR 2443: Cannot insert into a view
ERROR 2458: Cannot mergeout uncommitted data in the presence of savepoints
ERROR 2461: Cannot moveout uncommitted data in the presence of savepoints
ERROR 2503: Cannot set a subfield to DEFAULT
ERROR 2504: Cannot set an array element to DEFAULT
ERROR 2532: Cannot update a view
ERROR 2533: Cannot Update/Merge tables involved in prejoins with Limit clause on unsorted output
ERROR 2549: Cannot use DISTINCT with user-defined transform functions
ERROR 2552: Cannot use meta function or non-deterministic function in PARTITION BY expression
ERROR 2556: Cannot use SAVEPOINT with uncommitted tuple mover enabled
ERROR 2558: Cannot use subquery in EXECUTE parameter
ERROR 2559: Cannot use subquery in expressions within COPY
ERROR 2560: Cannot use subquery in PARTITION BY expression
ERROR 2561: Cannot use subquery in SEGMENTED BY expression
ERROR 2562: Cannot use Vertica's built-in file source and a UDSource in the same query
ERROR 2569: Catalog object string does not exist
ERROR 2602: Clause "NO PROJECTION" conflicts with the column list
ERROR 2603: Clause "NO PROJECTION" is supported only on temporary tables
ERROR 2618: CoerceToDomain is not supported
ERROR 2619: CoerceToDomainValue is not supported
ERROR 2628: Column "string" in PARTITION BY expression is not allowed, since it contains NULL values
ERROR 2646: Column string has the NOT NULL constraint set and has no default value defined
ERROR 2648: Column string in PARTITION BY expression is not allowed, since it is not present in some projections
ERROR 2649: Column string in PARTITION BY expression is not allowed, since it may contain NULL values
ERROR 2652: Column string occurred multiple times in the definition of Projection string
ERROR 2660: Column column string is no longer at position value in table string
ERROR 2667: Column name list is not allowed in CREATE TABLE / AS EXECUTE
ERROR 2672: Column type int2 is not supported
ERROR 2673: Column type int4 is not supported
ERROR 2676: Command string is not supported
ERROR 2679: COMMENT not supported for system objects
ERROR 2680: COMMENT not supported for this object type
ERROR 2692: Conditional UNION/INTERSECT/EXCEPT statements are not implemented
ERROR 2698: Conflicting or redundant column options
ERROR 2721: ConvertRowtypeExpr is not supported
ERROR 2725: Copy cannot return rejected rows from executor nodes
ERROR 2726: Copy cannot return rejected rows from more than one file
ERROR 2739: COPY force not null is available only in CSV mode, but CSV mode is not supported
ERROR 2740: COPY force quote is available only in CSV mode, but CSV mode is not supported
ERROR 2741: COPY FROM does not support the BINARY option
ERROR 2742: COPY FROM does not support the CSV option
ERROR 2743: COPY FROM does not support the OIDS option
ERROR 2744: COPY LOCAL does not support rejected row numbers with exceptions or rejected data options
ERROR 2751: COPY quote is available only in CSV mode, but CSV mode is not supported
ERROR 2770: Correlated EXISTS/NOT EXISTS subquery containing having clause with aggregates is not supported
ERROR 2772: Correlated EXISTS/NOT EXISTS subquery with limit 0 is not supported
ERROR 2773: Correlated EXISTS/NOT EXISTS with aggregate COUNT is not supported
ERROR 2776: Correlated EXISTS/NOT EXISTS with User Defined Aggregate is not supported
ERROR 2777: Correlated expression in ON clause is not supported
ERROR 2778: Correlated expression in set operator subquery is not supported
ERROR 2779: Correlated expressions in SELECT list of subquery are not supported
ERROR 2780: Correlated subqueries cannot have more than one level
ERROR 2781: Correlated subqueries with analytics in the select list is not supported
ERROR 2782: Correlated subqueries with no group by and a non-strict expression containing an aggregate in the select list is not supported
ERROR 2783: Correlated subquery column in select/gby/oby not supported
ERROR 2784: Correlated subquery could not be flattened as a join
ERROR 2785: Correlated subquery could not get flattened, a correlated expression could not be treated as a join
ERROR 2786: Correlated subquery expression without aggregates and with limit is not supported
ERROR 2787: Correlated subquery expressions under OR not supported
ERROR 2788: Correlated subquery in expression with operator <> is not supported
ERROR 2790: Correlated subquery with aggregate and limit 0 is not supported
ERROR 2792: Correlated subquery with aggregate function COUNT is not supported
ERROR 2793: Correlated subquery with distinct/group by is not supported
ERROR 2794: Correlated subquery with having clause expression that involves aggregates and subquery is not supported
ERROR 2795: Correlated subquery with NOT IN is not supported
ERROR 2796: Correlated subquery with outer joins and uncorrelated exists is not supported
ERROR 2797: Correlated subquery with User Defined Aggregate is not supported
ERROR 2854: Could not find array type for data type string
ERROR 2856: Could not find column string in table string
ERROR 2942: CREATE ASSERTION is not supported
ERROR 2943: CREATE FUNCTION / INOUT parameters are not supported
ERROR 2944: CREATE FUNCTION / OUT parameters are not supported
ERROR 2980: Data type not supported
ERROR 2981: Data type not supported (value)
ERROR 2983: Database "string" does not exist
ERROR 2987: Database references are not supported: "string.string.string"
ERROR 3026: Defining query must have a from clause
ERROR 3115: DistinctExpr not supported
ERROR 3116: Distrib overrides are too restrictive. Can not find completed Join Order
ERROR 3118: DML on projection/view is not supported
ERROR 3119: DML query with a predicate that could not be pushed below joins and does not refer solely to the target table is not supported
ERROR 3123: DROP ASSERTION is not supported
ERROR 3126: DROP COLUMN over temporary tables is not supported
ERROR 3132: DROP SEQUENCE does not support CASCADE
ERROR 3141: Dropping local and global objects in one statement is not supported
ERROR 3157: Dynamic load not supported
ERROR 3163: Embedded SQL involving local objects is not supported
ERROR 3174: ENCODED BY is supported in CREATE TABLE ... AS SELECT statement only
ERROR 3246: Error parsing distrib overrides (unexpected end of override); string
ERROR 3247: Error parsing distrib value; string
ERROR 3291: Event ANY_ROW is not supported
ERROR 3317: Executing when OPT:PLAN_ALL_NODES_ACTIVE option is set
ERROR 3343: Explicit JOIN clause contains a join predicate between relations previously joined
ERROR 3351: Expressions in COPY may not contain aggregate functions
ERROR 3352: Expressions in COPY may not contain analytic or Time Series Aggregate Functions
ERROR 3353: Expressions not supported in Times Series Aggregate Function
ERROR 3357: External tables only support files or a User Defined Source
ERROR 3403: FieldSelect is not supported
ERROR 3404: FieldStore is not supported
ERROR 3417: Final phase output size mismatch
ERROR 3420: First argument of date_part must be a constant string
ERROR 3434: For INSERT SELECT statement, replicated/broadcasted source data not supported
ERROR 3436: For SELECT DISTINCT, ORDER BY expressions must appear in the SELECT clause
ERROR 3451: Function string can't be used as a case expression
ERROR 3452: Function string can't be used in a boolean
ERROR 3453: Function string can't be used in a WHEN clause
ERROR 3454: Function string can't be used in as a segment expression
ERROR 3455: Function string can't be used with an operator
ERROR 3488: Group By, Order By, Aggregates, Having & limits not allowed in update/delete
ERROR 3510: IGNORE NULLS argument must be a Boolean constant
ERROR 3553: INHERITS not supported
ERROR 3566: Input of anonymous composite types is not implemented
ERROR 3600: Interpolated predicates can accept arguments of the same type only
ERROR 3601: Interpolated predicates can be part of AND expressions only
ERROR 3613: Interval units "string" not supported
ERROR 3821: Joins with an interpolated predicate can have a conjunctive expression containing equality predicates. The equality predicates cannot have expressions or column references with different modifiers
ERROR 3822: Joins with an interpolated predicate cannot have expressions or column references with different modifiers in any of the expressions
ERROR 3857: Library built with unsupported version of Vertica SDK [Version: string, Revision: string]
ERROR 3876: Locale must be a constant
ERROR 3900: MATCH PARTIAL is not supported
ERROR 3972: Multi-column subquery expressions can only be used with the =, <=> and <> operators
ERROR 3973: Multi-column subquery type ALL can only be used with the = and <=> operators
ERROR 3974: Multi-column subquery type ANY can only be used with the =, <=> and <> operators
ERROR 4106: No single-source bulk loads have been executed in this session
ERROR 4147: Node issuing the query cannot be marked as down
ERROR 4160: Non-equality correlated subquery expression is not supported
ERROR 4170: Not a Star or Snow-Flake Query block
ERROR 4171: Not a Star or Snow-Flake Query block; dimension table not a star or snowflake
ERROR 4172: Not a Star or Snow-Flake Query block; no fact table found
ERROR 4173: Not a Star or Snow-Flake Query block; there are multiple fact tables
ERROR 4197: NULL value found in a column used by a subquery
ERROR 4228: ON COMMIT DROP not supported in CREATE TABLE
ERROR 4238: Only a temporary table projection can be pinned
ERROR 4248: Only inner joins are allowed in the projection defining query
ERROR 4256: Only relations and subqueries are allowed in the FROM clause
ERROR 4258: Only super user can call export_catalog with an output file name
ERROR 4259: Only super user can get the rebalance data script
ERROR 4263: Only superuser can drop system schema
ERROR 4264: Only superuser can rebalance data
ERROR 4265: Only superuser can rebalance data for replicated projections
ERROR 4266: Only superuser can rebalance data for segmented projections
ERROR 4280: Operator string (value) is not supported
ERROR 4281: Operator string is not supported for row expressions
ERROR 4298: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns
ERROR 4299: ORDER mode not supported
ERROR 4306: OUTER join with broadcasted outer data not supported
ERROR 4307: OUTER or SEMI join - done through CROSS join and FILTER - with replicated outer and segmented inner not supported
ERROR 4308: OUTER relation in OUTER join is not the fact table nor a snowflake dimension table
ERROR 4309: Outer replicated/segmented input to a join cannot be resegmented
ERROR 4310: LEFTOUTER/SEMI/ANTI join with replicated/broadcasted outer data not supported
ERROR 4328: PARTITION AUTO can only be used with single-phase user defined transform functions
ERROR 4329: PARTITION AUTO cannot be used with pattern matching
ERROR 4331: PARTITION BY expression cannot return a tuple
ERROR 4332: PARTITION BY expression has an unknown type
ERROR 4333: PARTITION BY expression may not contain aggregate functions
ERROR 4335: Partitioning expression not supported for temporary tables
ERROR 4336: Partitioning not supported for temporary tables
ERROR 4352: Pattern "E" is not supported
ERROR 4375: PINNED clause conflicts with KSAFE setting
ERROR 4376: PINNED clause is not supported in CREATE TABLE statement
ERROR 4412: Prepared statements are currently unsupported
ERROR 4465: Projection string of local temporary table cannot be created under user schema string
ERROR 4471: Projection choices are too restrictive - cannot create correct join between tables
ERROR 4486: Projections are always created and persisted in the default Vertica locale. The current locale is string
ERROR 4584: RENAME COLUMN over temporary tables is not supported
ERROR 4586: replicate_catalog has been shut off
ERROR 4628: Row Expressions are not supported in this context
ERROR 4631: ROW syntax is not supported
ERROR 4644: Scalar array expression cannot contain column references or subqueries
ERROR 4645: Scalar array op string (value) is not supported
ERROR 4664: Segmentation clause can not have offset in CREATE TABLE statement
ERROR 4665: Segmentation clause with offset conflicts with KSAFE setting
ERROR 4666: Segmentation expression must have integer type
ERROR 4671: SELECT FOR UPDATE cannot be applied to a function
ERROR 4672: SELECT FOR UPDATE cannot be applied to a join
ERROR 4673: SELECT FOR UPDATE cannot be applied to NEW or OLD
ERROR 4674: SELECT FOR UPDATE is not allowed with EXTERNAL TABLES
ERROR 4675: SELECT FOR UPDATE is not allowed with libraries
ERROR 4676: SELECT FOR UPDATE is not allowed with sequences
ERROR 4677: SELECT FOR UPDATE is not allowed with UNION/INTERSECT/EXCEPT
ERROR 4678: SELECT FOR UPDATE is not allowed with views
ERROR 4680: Self joins in UPDATE statements are not allowed
ERROR 4703: Sequence cannot be moved between system schema and user schema
ERROR 4711: Sequence or IDENTITY/AUTO_INCREMENT column in merge query is not supported
ERROR 4714: Sequences are not allowed in default expressions of local temp tables
ERROR 4715: Sequences cannot be called in views
ERROR 4716: Sequences cannot be created under system schemas
ERROR 4728: Set Operator string ALL not supported
ERROR 4730: Set Operator queries without a FROM clause are not supported
ERROR 4733: SET SCHEMA over temporary tables is not supported
ERROR 4735: Set-valued function called in context that cannot accept a set
ERROR 4747: SetToDefault is not supported
ERROR 4786: Statement string is not supported
ERROR 4808: Subqueries are not supported as the left hand argument to another subquery
ERROR 4809: Subqueries are not supported in the ORDER BY of a timeseries OVER clause
ERROR 4810: Subqueries are not supported in the ORDER BY of an analytic function OVER clause
ERROR 4812: Subqueries are not supported in the PARTITION BY of an analytic function OVER clause
ERROR 4816: Subqueries in the ON clause are not supported
ERROR 4817: Subqueries in the SELECT or ORDER BY are not supported if the query has aggregates and the subquery is not part of the GROUP BY
ERROR 4818: Subqueries in the SELECT or ORDER BY are not supported if the subquery is not part of the GROUP BY
ERROR 4820: Subqueries in UPDATE/DELETE/MERGE is not supported
ERROR 4821: Subqueries not allowed in target of insert
ERROR 4822: Subqueries referring to no outer columns in HAVING clause when query has aggregates and no GROUP BY are not supported
ERROR 4824: Subquery aggregate expression that refers a correlated column is not supported
ERROR 4839: Subquery type ARRAY is not supported
ERROR 4842: Subquery without a from clause is not supported
ERROR 4850: Support for UPDATE/DELETE/MERGE is not enabled
ERROR 4854: SyncMarkers are not supported
ERROR 4865: System table string cannot be created under user schema string
ERROR 4869: System view "string" cannot be dropped
ERROR 4870: System view string cannot be created under user schema string
ERROR 4884: Table string cannot be created under system schema string
ERROR 4897: Table cannot be moved between system schema and user schema
ERROR 4910: Table revalidation error
ERROR 4918: Temporary Sequences are not supported
ERROR 4933: The argument types in a subquery expression in the where/having clause do not match
ERROR 4938: The constant value following the LIMIT clause cannot be negative
ERROR 4939: The constant value following the OFFSET clause cannot be negative
ERROR 4948: The fourth input argument of TIME_SLICE must be START or END
ERROR 4960: The ORDER BY ... USING clause is not supported
ERROR 4966: The second parameter of export_catalog is invalid: string
ERROR 4968: The slice length parameter of TIME_SLICE must be a positive integer
ERROR 5005: Time Series Aggregate Function with interpolation scheme LINEAR may only have an INTEGER or FLOAT type as its first argument
ERROR 5016: Time units "string" not supported
ERROR 5023: Timeseries output functions are not supported in the ORDER BY of a timeseries OVER clause
ERROR 5028: Timestamp units "string" not supported
ERROR 5110: Type string (value) is not supported
ERROR 5160: Uncorrelated EXISTS subqueries in HAVING clause when query has aggregates and no GROUP BY are not supported
ERROR 5195: UNIQUE predicate is not supported
ERROR 5262: Unsafe use of string constant with Unicode escapes
ERROR 5264: Unsupported access to session-scoped (LOCAL) object
ERROR 5270: Unsupported COPY command clause
ERROR 5275: Unsupported Join in From clause
ERROR 5276: Unsupported Join in From clause: FULL OUTER JOINS not supported
ERROR 5278: Unsupported join of two non-alike segmented projections
ERROR 5280: Unsupported mix of Joins
ERROR 5284: Unsupported query syntax 
ERROR 5289: Unsupported subquery expression
ERROR 5291: Unsupported use of aggregates
ERROR 5292: Unsupported use of cursors
ERROR 5293: Unsupported use of DISTINCT clause
ERROR 5294: Unsupported use of FROM clause
ERROR 5295: Unsupported use of GROUP BY or DISTINCT clause
ERROR 5296: Unsupported use of HAVING clause
ERROR 5297: Unsupported use of LIMIT/OFFSET clause
ERROR 5298: Unsupported use of ORDER BY clause
ERROR 5299: Unsupported use of outer joins
ERROR 5300: Unsupported use of query/subquery without FROM clause
ERROR 5301: Unsupported use of sub-queries
ERROR 5302: Unsupported use of target relation
ERROR 5303: Unsupported use of UDF in WHERE clause
ERROR 5304: Unsupported use of UNION/INTERSECT/EXCEPT
ERROR 5314: UPDATE may not refer to tables in prejoin projections
ERROR 5366: User defined aggregate cannot be used in query with other distinct aggregates
ERROR 5388: User has insufficient privilege on string string
ERROR 5392: User must have the DBDUSER role to run the database designer
ERROR 5396: User projection string cannot be created under system schema string
ERROR 5402: User-defined transform functions are not supported in the ORDER BY clause
ERROR 5407: VALINDEX column must be the first column in ORDER BY list
ERROR 5426: Vertica currently allows a maximum of value physical storage containers per projection
ERROR 5427: Vertica does not support GRANT / REVOKE ON LANGUAGE
ERROR 5428: Vertica does not support GRANT / REVOKE ON TABLESPACE
ERROR 5447: View string cannot be created under system schema string
ERROR 5456: Volatile functions may not be used in fillers when other computed columns refer to them
ERROR 5465: Window frame exclusion is not supported
ERROR 5537: Cannot alter user-defined type "string" of column "string"
ERROR 5550: COPY from UDSource does not support rejected row numbers with exceptions or rejected data options
ERROR 5551: COPY LOCAL cannot process more than ONE NATIVE or NATIVE VARCHAR file at a time
ERROR 5562: Creating temp tables by LIKE clause is not supported
ERROR 5595: Invalid argument type string in function string
ERROR 5607: Language of replacement library [string] must match language of existing library [string]
ERROR 5681: Unsupported base type string for User-defined type string
ERROR 5698: Cannot export statistics for the specified object
ERROR 5725: Size specification not supported for User Defined Type string
ERROR 5731: The second parameter must be a table/projection/column name
ERROR 5758: Can not drop Filesystem proc string
ERROR 5759: Can not drop library "string": referenced by storage locations
ERROR 5763: Can't create a managed external table with non-file sources
ERROR 5764: Cannot alter the data type of a table column when a node is down
ERROR 5781: Cannot use meta function or non-deterministic function in SEGMENTED BY expression
ERROR 5859: Due to the data isolation of temp tables with an on-commit-delete-rows policy, the compute_flextable_keys() and compute_flextable_keys_and_build_view() functions cannot access this table's data
ERROR 5864: Error parsing table (invalid table): string
ERROR 5914: HCatalog schema string not permitted in search path
ERROR 5990: Projection string cannot be created under hcatalog schema string
ERROR 5992: Projection cannot be created for HCatalog table string
ERROR 6005: Remote table string.string found in design query
ERROR 6019: Sequence string cannot be created under hcatalog schema string
ERROR 6020: Sequence string cannot be moved between system schema and hcatalog schema string
ERROR 6038: Table string cannot be created under hcatalog schema string
ERROR 6039: Table string cannot be moved under hcatalog schema string
ERROR 6092: Unsupported access to flex table: No string support
ERROR 6108: View string cannot be created under hcatalog schema string
ERROR 6142: Alter partition not supported for tables with aggregate projections
ERROR 6145: Analytic functions are not allowed in projections
ERROR 6173: Cannot open file string for debugging ExprHashCode
ERROR 6174: Cannot open/write/close file "string" for debugging ExprHashCode
ERROR 6200: Command CREATE INDEX is not supported
ERROR 6233: DISTINCT Aggregates are not allowed in projections
ERROR 6244: EE option DISABLE_AUTOPARTITION may not be used in conjunction with aggregate projections, or projections with expressions
ERROR 6265: Expressions in the projection SELECT list may not be repeated
ERROR 6266: Expressions on aggregates are not allowed in aggregate projections
ERROR 6322: LIMIT may not be used in projection definitions unless the OVER clause is supplied
ERROR 6332: MERGE is not supported on any target table having projection with expression
ERROR 6380: PARTITION BEST cannot be used with pattern matching
ERROR 6382: PARTITION NODES cannot be used with pattern matching
ERROR 6401: Setting the cascade to pool to the built-in pool "string" is not supported
ERROR 6427: The LIMIT clause does not support OFFSET ... and OVER() clauses simultaneously
ERROR 6455: Unsupported access to table with projection expressions or aggregates
ERROR 6459: UPDATE/DELETE/MERGE a dim table where fact table has aggregate projections is not supported
ERROR 6460: UPDATE/DELETE/MERGE a table with aggregate projections is not supported
ERROR 6464: Use of LIMIT with the OVER(...) clause and DISTINCT is not supported within the same SELECT block
ERROR 6465: Use of LIMIT with the OVER(...) clause and ORDER BY is not supported within the same SELECT block
ERROR 6467: User defined aggregate cannot be used in query with MLAs
ERROR 6476: Cannot directly modify index table constraint
ERROR 6477: Cannot modify index table columns directly
ERROR 6501: Access policy cannot be created on table "string" since it has an aggregate projection
ERROR 6503: Access policy cannot be created on table "string" since it has a projection with expressions
ERROR 6505: Cannot create Aggregate projection on tables with access policy
ERROR 6507: Cannot create projection with expression on tables with access policy
ERROR 6517: Access policy is requested from unsupported object: "string"
ERROR 6522: Cannot alter column width on variable length columns with BLOCKDICT_COMP encoding
ERROR 6525: Direct query to projection "string" are not supported: "string"
ERROR 6530: Invalid statistics file. Total number of bounds specified: 'value' do not match the buckets value: 'value' for column 'string'. Buckets value specified should exactly be same as total number of bounds
ERROR 6531: Invalid table name: 'string'. Make sure the schema/table exists in database
ERROR 6532: Invalid value 'value' for attribute 'string' under bound 'string', column 'string'. Please use a positive value. 
ERROR 6533: Invalid value 'value' for attribute 'string' under column 'string'. Please use a positive value. 
ERROR 6538: Unable to string: "string"
ERROR 6644: Arguments to Transform Functions in Live Aggregate Projections cannot be constants
ERROR 6670: Cannot alter a table constraint when a node is down
ERROR 6685: Cannot specify anything other than expressions on table columns in the SELECT list
ERROR 6690: Cannot use multi phase UDTs with live aggregate projections
ERROR 6742: drop_location for non-retired DATA locations is not supported
ERROR 6785: For NULLAWARE ANTI JOIN, columns of left-hand-side relation must not appear on the right hand side of ON clause predicates
ERROR 6786: For NULLAWARE ANTI JOIN, columns of right-hand-side relation must appear on the right hand side of ON clause predicates
ERROR 6787: For NULLAWARE ANTI JOIN, columns of right-hand-side relation must not appear on the left hand side of ON clause predicates
ERROR 6817: Input filename cannot be NULL
ERROR 6822: Inputs to batch transform function have to be in the same order as the outputs of the prepass transform function
ERROR 6823: Inputs to batch Transform function may not be expressions
ERROR 6852: Live Aggregate Projection "string" will be created for "string". Data in "string" will be neither updated nor deleted
ERROR 6862: MARS operation not supported for this client type. Parameter not changed
ERROR 6865: Materialized WITH queries are not supported with directed queries
ERROR 6867: Meta-functions cannot be used in directed queries
ERROR 6882: Null value in ON clause is not supported for Nullaware anti join
ERROR 6888: Only equality join is supported in ON clause of Nullaware anti join
ERROR 6891: Order BY clauses are not allowed in aggregate projection definitions
ERROR 6894: Output filename cannot be NULL
ERROR 6974: System/Virtual tables, projections or views not supported for optimizer-generated annotated queries
ERROR 6983: Tables or projections with access policies not supported for optimizer-generated annotated queries
ERROR 6992: The batch and prepass transform functions must be partitioned by the same values
ERROR 6996: The DB admin has disallowed using the MARS feature
ERROR 7054: Unsupported operation in ON clause of Nullaware anti join
ERROR 7103: Java user defined functions are not supported in aggregate projections
ERROR 7113: Queries with syntactic hints are not supported with directed queries
ERROR 7123: Statement including date/time literals based on current date/time are not supported for directed queries
ERROR 7124: Statement including hints are not supported for directed queries
ERROR 7133: UNI Join with non-subquery inner not supported
ERROR 7169: Constant true/false predicate with ignore constant hint is not supported
ERROR 7188: Object type value not supported for access policies
ERROR 7201: The constant value following the LIMIT clause cannot be both zero and ignoreconst
ERROR 7239: Computing flex table keys with non-binary collation locales is not supported
ERROR 7288: Transaction isolation level not supported. Parameter not changed
ERROR 7294: string expressions must not return a set
ERROR 7307: Cannot use aggregate functions in string expressions
ERROR 7308: Cannot use analytic or time series aggregate functions in string expressions
ERROR 7318: Default expressions with subqueries are not supported in a MERGE statement
ERROR 7344: string expressions may not refer to other columns with string expressions
ERROR 7346: string queries may not refer to a temporary table
ERROR 7347: string queries must refer to tables
ERROR 7368: ALTER NOTIFIER: Unsupported parameter 'string'
ERROR 7371: Cannot alter a column's string when a node is down
ERROR 7372: Cannot assign value to "string" column
ERROR 7394: Columns in COPY may not contain virtual columns
ERROR 7403: describeProjection is not supported in fenced UDx
ERROR 7404: describeTable is not supported in fenced UDx
ERROR 7410: Epsilon must be a non-negative float number and smaller than one-million
ERROR 7421: Expressions on SELECT statements cannot be used in string query definitions
ERROR 7422: External tables cannot have string expressions
ERROR 7430: Initial centers in table 'string' are not distinct
ERROR 7439: Invalid type 'string' for column string
ERROR 7440: Invalid type 'string' for column string of initial_centers_table
ERROR 7442: listProjections is not supported in fenced UDx
ERROR 7444: listTableProjections is not supported in fenced UDx
ERROR 7446: listTables is not supported in fenced UDx
ERROR 7450: max_iterations must be a positive integer and less than one-million
ERROR 7455: MD5 can't be used in FIPS mode
ERROR 7466: Must specify either a valid initialization method or initial centers table
ERROR 7477: Notifier action is immutable. To set the new action URL you need to drop the notifier, and create a new one
ERROR 7486: num_clusters must be a positive integer
ERROR 7487: Number of clusters must not be bigger than the number of rows without null or infinity values
ERROR 7492: Only 'euclidean' is supported for distance_method
ERROR 7539: Sequences are not allowed in string expressions of local temp tables
ERROR 7550: TableSample does not work with update statements
ERROR 7551: TableSample only works on user defined tables
ERROR 7553: Temporary tables cannot have subqueries as string expressions
ERROR 7558: The response_column is included in the predictor_columns. You should exclude it to have a meaningful model
ERROR 7559: The selected normalization method is not supported. Only support MinMax, zscore, robust_zscore at present
ERROR 7560: The selected outlier detection method is not supported. Only support robust_zscore based outlier detection at present
ERROR 7606: Number of clusters must not be bigger than the number of distinct rows without null or infinity values
ERROR 7634: TableSample is not supported with Aggregate projections
ERROR 7646: Cursor [string] does not support multiple shards
ERROR 7647: Cursor [string] does not support multiple storage containers
ERROR 7648: Cursor [string] does not support this operation
ERROR 7649: Cursor [string] does not support writes
ERROR 7650: describeBlob is not supported in fenced UDx
ERROR 7652: describeFunction does not support function lookup by name / arguments yet
ERROR 7653: describeFunction is not supported in fenced UDx
ERROR 7654: describeType is not supported in fenced UDx
ERROR 7655: describeType is not supported yet
ERROR 7658: listBlobs is not supported in fenced UDx
ERROR 7659: listBlobs is not supported yet
ERROR 7660: listDerivedTables is not supported in fenced UDx
ERROR 7670: UDx cursors do not currently support deleted data
ERROR 7677: Looking up cursor by table is not yet supported
ERROR 7686: ALTER TABLE does not support ADD CONSTRAINT on text index
ERROR 7687: ALTER TABLE does not support ALTER PARTITION on text index
ERROR 7691: DROP PARTITION is not supported on text index
ERROR 7703: ALTER NOTIFIER: MAXMEMORYSIZE cannot be empty
ERROR 7739: Slices are not supported for VMaps
ERROR 7790: Order BY is not allowed within the OVER() clause of User Defined Transforms in projection definitions
ERROR 7792: Resource pool string cannot be modified
ERROR 7818: Unsupported type 'string' for column 'string'
ERROR 7840: Column [string] is duplicated in exclude_columns
ERROR 7841: Column [string] is duplicated in predictor_columns
ERROR 7846: Relation string is empty
ERROR 7848: Table 'string' contains value rows, should be value
ERROR 7867: Live-aggregate projection is not supported for ADD COLUMN ... PROJECTIONS (...) 
ERROR 7878: Too many columns in MLA grouping sets: value, while only up to value MLA columns are allowed
ERROR 7889: ALTER MODEL does not support multiple clauses
ERROR 7898: Model string cannot be moved under hcatalog schema string
ERROR 7900: Model cannot be moved to system schema
ERROR 7926: Catalog object string is not either a table or a schema
ERROR 7927: Column "string" is referenced in a column set using expression of projection "string" but is not stored in the projection
ERROR 7930: COMPLEX JOIN without a boolean marker column not supported
ERROR 7931: COMPLEX JOIN without a complex_join_marker() column at the end of the select list not supported
ERROR 7932: COMPLEX JOIN without a subquery not supported
ERROR 7934: Refresh_columns on multiple tables is only supported for "rebuild" mode
ERROR 7935: Refreshed column cannot be any projection's sort key
ERROR 7937: Refreshed column cannot be referenced in projection's segmentation expression
ERROR 7938: Refreshed column cannot be referenced in table's partition expression
ERROR 7964: The selected missing value imputation method is not supported. 
     Only support mean and mode based missing value imputation at present
ERROR 7974: string is not supported in fenced UDx
ERROR 7976: Add column with default subquery is not supported for unsegmented projections
ERROR 7980: Cannot alter model in an incomplete state
ERROR 8008: Refresh_columns with rebuild mode is not supported for unsegmented projections
ERROR 8013: The selected normalization method is not supported. Valid options are 'minmax', 'zscore', and 'robust_zscore'
ERROR 8023: Unsupported column type [string] for column [string]
ERROR 8034: Refresh_columns on enforced PK/Unique constraint columns not supported
ERROR 8038: Cannot alter type of column "string" since it is referenced in the SET USING expression of column "string"
ERROR 8039: Cannot alter type of column with a SET USING expression
ERROR 8040: Cannot refresh column containing grouped containers
ERROR 8043: Refreshed column cannot be any projection's grouped column
ERROR 8060: Cannot COPY "string" from the client using the keyword LOCAL
ERROR 8123: Not enough number of appropriate samples to run the algorithm (excluding samples with NULL, NaN, or Infinity values)
ERROR 8140: Projections on shared storage cannot use explicit node lists
ERROR 8141: Projections on shared storage cannot use explicit range segmentation
ERROR 8155: SET SCHEMA over flex keys tables is not supported
ERROR 8156: SET SCHEMA over text index tables is not supported
ERROR 8180: UDx concurrency request is not supported for empty OVER clause
ERROR 8202: Cannot run refresh_columns or add column with default subquery when any node is recovering
ERROR 8212: Block Dictionary Compression is not supported for data types longer than value bytes
ERROR 8213: Block Dictionary Compression is not supported for data types longer than 65000 bytes
ERROR 8357: Cannot use meta function in partition GROUP BY expression
ERROR 8358: Cannot use non-deterministic function in partition GROUP BY expression
ERROR 8362: PARTITION BY expression must appear at least once in partition GROUP BY expression
ERROR 8363: Partition GROUP BY expression can only reference columns by way of inclusion of the PARTITION BY expression
ERROR 8379: num_clusters must be less than or equal to 10000
ERROR 8386: Cannot use subquery in partition GROUP BY expression
ERROR 8388: PARTITION BY expression may not contain window functions
ERROR 8389: Partition GROUP BY expression cannot return a tuple
ERROR 8390: Partition GROUP BY expression has an unknown type
ERROR 8391: Partition GROUP BY expression may not contain aggregate functions
ERROR 8392: Partition GROUP BY expression may not contain window functions
ERROR 8410: HAVING clauses are not allowed in projections
ERROR 8474: Model string cannot be created under hcatalog schema string
ERROR 8475: Model cannot be created under system schemas
ERROR 8490: Temporary relation is not supported for this function
ERROR 8496: Historical queries are not supported on temporary tables or projections whose underlying tables are temporary
ERROR 8500: Add Column is not supported for unsegmented projections when the node used as initiator is not subscribed to the replica shard
ERROR 8525: Regularization type [string] does not use provided parameter [string], it only affects [string]
ERROR 8534: Cannot grant privileges on system table to PSEUDOSUPERUSER role
ERROR 8535: Cannot grant privileges on system table to SYSMONITOR role
ERROR 8546: Invalid privilege on system table. Only SELECT is supported
ERROR 8558: Feature string only supported in Eon mode
ERROR 8559: Feature string unsupported in Eon mode
ERROR 8638: Drop column not supported on multiphase UDT
ERROR 8678: Prejoin projection is deprecated
ERROR 8679: Projection string not used in the plan because the projection is deprecated for node down plans
ERROR 8681: Range segmented projection is deprecated
ERROR 8691: Explain JSON not supported on copy statements. Re-run the statement without the JSON keyword
ERROR 8739: Uncorrelated EXISTS subqueries are not supported when the query either has HAVING clause subqueries involving aggregates or Multilevel aggregation, and also when the query has either OUTER JOINS or NOT IN subqueries
ERROR 8765: analyze_correlations is not supported
ERROR 8768: dbd_add_nodes_rebalance_data is not supported
ERROR 8769: dbd_add_nodes_rebalance_data_for_replicated_projections is not supported
ERROR 8770: dbd_add_nodes_rebalance_data_for_segmented_projections is not supported
ERROR 8771: dbd_add_query_override is not supported
ERROR 8772: dbd_add_table_override is not supported
ERROR 8773: dbd_output_add_nodes_rebalance_data_script is not supported
ERROR 8774: dbd_remove_override_by_id is not supported
ERROR 8775: dbd_remove_query_override is not supported
ERROR 8776: dbd_remove_table_override is not supported
ERROR 8777: dbd_set_analyze_correlations_mode is not supported
ERROR 8791: dbd_add_deployment_catalog is not supported
ERROR 8795: drop_dbd_system_schema is not supported
ERROR 8803: Refreshed column cannot be referenced in any TopK/UDT/expression projection
ERROR 8849: Feature is unsupported on a data immutable branch
ERROR 8876: Comparisons with ANY/ALL arrays are unsupported in this context
ERROR 8890: Refresh_columns with partition range is not supported for multiple tables
ERROR 8932: Cannot alter type of column "string" since it is referenced by the string projection "string"
ERROR 8933: Cannot drop column "string" since it is referenced by the string projection "string"
ERROR 8975: Only a single outer SELECT statement is supported

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