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 5159: Uncorrelated EXISTS subqueries are not supported when the query has both HAVING clause subqueries involving aggregates and when the query has either OUTER JOINS or NOT IN subqueries
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 5313: Update is disallowed on Primary/Foreign Keys columns. Use Delete followed by Insert instead
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 5530: Audit of external tables 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 6023: Setting the CPU affinity of the built-in pool "string" is not supported
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 6141: ALTER COLUMN TYPE over tables having aggregate projections is not supported
ERROR 6142: Alter partition not supported for tables with aggregate projections
ERROR 6145: Analytic functions are not allowed in projections
ERROR 6168: Cannot drop column of a table with aggregate 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 6241: DROP COLUMN over tables having aggregate projections is not supported
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 6323: LIMIT or OVER(...) clause may not be used in projection definitions
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 6400: Setting the cascade to pool of the built-in pool "string" is not supported
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 6502: Access policy cannot be created on table "string" since it has a pre-join 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 6506: Cannot create prejoin 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 7433: Invalid choice for opitmizer
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 7475: Not enough number of appropriate samples to run the algorithm (excluding samples with NULL or Inf values)
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 7496: Prejoin projection unsupported for table string that has default queries or set-using expressions/queries
ERROR 7539: Sequences are not allowed in string expressions of local temp tables
ERROR 7548: Tables with prejoin projections cannot have string expressions
ERROR 7549: Tables with prejoin projections cannot have string queries
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 7588: Valid value for sampling_ratio is a positive float number between 0 and 1
ERROR 7606: Number of clusters must not be bigger than the number of distinct rows without null or infinity values
ERROR 7631: Response column must be integer or varchar
ERROR 7634: TableSample is not supported with Aggregate projections
ERROR 7635: The selected balance method is not supported. Only support weighted_sampling at present
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 7815: The column provided in response_column must be of type integer or character
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 7852: num_clusters must be less than or equal to 1000
ERROR 7867: Live-aggregate projection is not supported for ADD COLUMN ... PROJECTIONS (...)
ERROR 7870: Prejoin 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 7928: Column list must be empty for refresh_columns on multiple tables
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 7936: Refreshed column cannot be referenced in any live-aggregate/expression projection
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 7991: Keyword "DEFAULT USING" is not supported
ERROR 8006: Qualified column is not supported
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 8029: The column provided in response_column must be of numerical types (INT, FLOAT or NUMERIC)
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
Note: For information about troubleshooting Vertica error messages, see the Vertica Knowledge Base and the Vertica Forum.