Messages associated with SQLSTATE 0A000
This topic lists the messages associated with the SQLSTATE 0A000.
This topic lists the messages associated with the SQLSTATE 0A000.
SQLSTATE 0A000 description
FEATURE_NOT_SUPPORTED
Messages associated with this SQLState
Error messages
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 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 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 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 2652: Column string occurred multiple times in the definition of
Projection 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 2699: Conflicting or redundant options
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 2942: CREATE ASSERTION is 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 3277: Error writing to [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 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 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 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 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 5277: Unsupported Join in From clause: UNION 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 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 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 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 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 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 6538: Unable to string: "string"
ERROR 6644: Arguments to Transform Functions in Live Aggregate
Projections cannot be constants
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 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 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 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 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 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 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 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 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 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
ERROR 9041: Cannot alter column "string" type to an inlined complex type
ERROR 9042: Cannot alter inlined complex type of column "string"
ERROR 9045: Cannot drop Inlined Complex Types
ERROR 9047: Comparison of incompatible Row Expressions
ERROR 9049: Constraint not supported for complex type column string
ERROR 9052: CREATE TYPE for Complex Type is not yet supported
ERROR 9065: Row Expressions in Group By are not supported for queries
with Multi-Level Aggregates
ERROR 9076: Add Column is not supported for unsegmented projections
when the node used as initiator is not participating to
the replica shard
ERROR 9134: Access policy cannot be created on Complex Type column
"string"
ERROR 9175: UPDATE/DELETE/MERGE a temporary table with aggregate
projections is not supported
ERROR 9192: Only optimized MERGE is supported on target table having
projection with aggregation or expression
ERROR 9215: Array slice on multiple indexes not supported yet
ERROR 9222: Default COPY parsers do not support string
ERROR 9228: PARTITION BY expression cannot return a collection
ERROR 9232: Skip is not yet supported for array types
ERROR 9237: Refreshed column cannot be referenced in any
UDT/expression projection
ERROR 9240: UPDATE/DELETE/MERGE a table with UDT projections is not
supported
ERROR 9241: A complex type can only have up to depth value
ERROR 9264: Bind DN cannot be NULL
ERROR 9265: Bind Password cannot be NULL
ERROR 9268: Filter Group cannot be NULL
ERROR 9269: Filter User cannot be NULL
ERROR 9270: Group Members cannot be NULL
ERROR 9271: Group Name cannot be NULL
ERROR 9273: LDAP Uri cannot be NULL
ERROR 9280: Scope cannot be NULL
ERROR 9281: Search Base cannot be NULL
ERROR 9285: User Name cannot be NULL
ERROR 9302: string is currently unsupported for this function
ERROR 9309: System and virtual objects and their dependents are
currently unsupported for this function
ERROR 9336: Cannot commit DMLs which trigger refreshing of Live
Aggregate Projections when any node is recovering
ERROR 9345: Dry Run Connect Failed!
ERROR 9346: LDAPLink: Could not perform bind for ldapbinddn "string" on
server "string": error code value: string
ERROR 9360: Cannot add new sort order to a Live Aggregate or
Expression projection
ERROR 9366: Projections must select data from only one table
ERROR 9384: Live-aggregate projection is not supported for ADD COLUMN
... PROJECTIONS (...) or ALTER COLUMN ... ENCODING
PROJECTIONS (...)
ERROR 9485: Constraint not supported for string type column string
ERROR 9501: Projection string has no direct reference to table column "string"
ERROR 9505: A complex type can only have up to depth value. Column string
does not satisfy this limit
ERROR 9545: Webhdfs TRUNCATE operation is not supported in this hdfs
version
ERROR 9607: Cannot create subcluster level internal resource pool "string"
ERROR 9618: Cannot analyze statistics of a collection column
ERROR 9619: Cannot apply complex alias "string" to a scalar target
ERROR 9629: CREATE TABLE AS SELECT with Complex Types in SELECT is not
supported
ERROR 9631: Incompatible column types in USING clause
ERROR 9639: Setting parameter 'string' of internal resource pool at
subcluster level is not supported
ERROR 9654: SET Operations with Row Expressions in SELECT are not
supported
ERROR 9745: Expressions with multiple SELECT statements cannot be used
in string query definitions
ERROR 9780: LIMIT in a recursive query is not implemented
ERROR 9783: Multi-value expressions are not supported in this context
ERROR 9784: Mutual recursion between WITH items is not implemented
ERROR 9785: Nested WITH RECURSIVE statements are not supported
ERROR 9786: OFFSET in a recursive query is not implemented
ERROR 9787: ORDER BY in a recursive query is not implemented
ERROR 9802: Complex types of this type are not yet implemented
ERROR 9820: Recursive WITH item "string" needs explicitly defined column
aliases
ERROR 9824: string is not supported for arguments of string types
ERROR 9848: Using complex types for filler columns is not yet
supported
ERROR 9850: WITH item "string" referencing recursive item "string" is not
supported
ERROR 9910: Complex type string output format length [value] exceeded limit
[value]
ERROR 9920: Updating elements of array column "string" is not supported
ERROR 9952: Corrupted argument mode; this should be unreachable
ERROR 9953: Corrupted stored procedure language code value; this should
be unreachable
ERROR 9954: Corrupted stored procedure language; this should be
unreachable
ERROR 9957: INOUT parameters are not supported in this language
ERROR 9961: OUT parameters are not supported in this language
ERROR 9973: There are value columns to process. This function cannot yet
process more than value columns
ERROR 9999: Partition range on Live Aggregate Projection is not
supported
ERROR 10057: Non-optimized DELETE/UPDATE/MERGE is not supported for
partition ranged projection for table partition data type
as string
ERROR 10060: PARTITION BY expression cannot include user-defined data
types
ERROR 10109: Cannot apply complex alias "string" to an array target
ERROR 10110: Incompatible Complex Type Case results
ERROR 10117: Corrupted assignment type value
ERROR 10118: Corrupted diag option value
ERROR 10119: Corrupted diag type value
ERROR 10121: Corrupted fetch direction type value
ERROR 10122: Corrupted fetch type value
ERROR 10123: Corrupted raise level value
ERROR 10124: Corrupted raise option value
ERROR 10125: Corrupted type kind value
ERROR 10139: Multi-dimension arrays are not supported
ERROR 10143: Unsupported use of SET type as a complex type field
ERROR 10157: Bare RAISE must be inside an exception block
ERROR 10163: Cannot TYPE-alias cursor variables
ERROR 10165: CONTEXT option is not yet supported
ERROR 10169: Corrupted control flow type value
ERROR 10193: Identifiers can be at most 128 characters long
ERROR 10207: ROW_COUNT option is not yet supported
ERROR 10219: validateAssignableType called on wrong type kind value
ERROR 10232: Ordering is not supported on string types
ERROR 10245: Corrupted expression type value
ERROR 10315: Cannot set string for column "string" since it is used in
projection "string"
ERROR 10318: Declaring records is not yet supported
ERROR 10319: Declaring row types is not yet supported
ERROR 10323: Executing FOREACH (ARRAY) is not yet supported
ERROR 10333: ROWTYPE is not yet supported
ERROR 10334: Stored procedures have been disabled by the superuser
ERROR 10335: The RECORD type is not yet supported
ERROR 10337: Type "string" is not yet supported for stored procedures
ERROR 10338: Unsupported complex type
ERROR 10355: OUT and INOUT arguments are not yet supported
ERROR 10375: Grouping sets are not supported for multi-argument
aggregate functions
ERROR 10384: Only NEXT/FORWARD direction is currently supported for
FETCH/MOVE
ERROR 10386: WHERE CURRENT OF (CURSOR) syntax is not supported
ERROR 10408: Cursor arguments ("string") may not themselves be cursors
ERROR 10412: FOREACH (ARRAY) is not yet supported
ERROR 10442: Feature string only supported in Eon mode with Communal
Location
ERROR 10443: GROUP BY does not support function match_columns
ERROR 10446: ORDER BY does not support function match_columns
ERROR 10464: Invalid use of SELECT match_columns() in recursive WITH
item "string", unable to identify result set columns
ERROR 10471: OR REPLACE syntax cannot be used to replace external
procedures
ERROR 10486: Feature string is removed in production builds
ERROR 10490: VFS paths cannot be specified by users: string
ERROR 10500: Cannot alter column type to a complex type
ERROR 10503: Cannot use complex expressions in topk or UDT projections
ERROR 10506: COPY LOCAL is not yet supported in internal statements
ERROR 10510: EXPORT TO VERTICA does not support exporting complex
types
ERROR 10511: Expressions cannot be used for columns of complex types
ERROR 10513: Inserting into indiviudal fields of complex types is not
supported
ERROR 10518: Native table must have at least one column whose datatype
is either a primitive type or a 1D array of a primitive
type
ERROR 10522: PARTITION BY expression cannot return a complex type
ERROR 10527: Projection must have at least one column whose datatype
is either a primitive type or a 1D array of a primitive
type
ERROR 10530: Unsupported operation on table with complex types
ERROR 10542: Tuning limited to SELECT queries
ERROR 10569: Projections whose anchor tables have complex types are
not supported for encoding design
ERROR 10572: Tables with complex types cannot be added as design
tables
ERROR 10583: Flex table with complex real columns must have at least
one real column whose datatype is either a primitive type
or a 1D array of a primitive type
ERROR 10604: Default values not supported in multi-row-insert
ERROR 10643: Cannot add a column of complex type to a table with
default columns
ERROR 10644: Cannot drop column "string" since it is the last non-complex
column
ERROR 10645: Cannot use multi-row insert: column 'string' has unsupported
type 'string'
Warning messages
WARNING 2660: Column column string is no longer at position value in table string
WARNING 2856: Could not find column string in table string
WARNING 4486: Projections are always created and persisted in the
default Vertica locale. The current locale is string
WARNING 5300: Unsupported use of query/subquery without FROM clause
WARNING 6517: Access policy is requested from unsupported object: "string"
WARNING 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
WARNING 6531: Invalid table name: 'string'. Make sure the schema/table
exists in database
WARNING 6532: Invalid value 'value' for attribute 'string' under bound
'string', column 'string'. Please use a positive value.
WARNING 6533: Invalid value 'value' for attribute 'string' under column
'string'. Please use a positive value.
WARNING 6862: MARS operation not supported for this client type.
Parameter not changed
WARNING 7288: Transaction isolation level not supported. Parameter not
changed
WARNING 8496: Historical queries are not supported on temporary tables
or projections whose underlying tables are temporary
WARNING 8525: Regularization type [string] does not use provided parameter
[string], it only affects [string]
WARNING 8679: Projection string not used in the plan because the
projection is deprecated for node down plans
WARNING 9165: Live Aggregate Projection "string" will be created for
temporary table "string". Data in "string" will be neither
updated nor deleted
WARNING 9239: UDT Projection "string" will be created for "string". Data in
"string" will be neither updated nor deleted
WARNING 9656: Specifying segmentation on specific nodes is deprecated
WARNING 10466: match_columns() function ignores column alias "string"
WARNING 10564: Did not add tables string
WARNING 10570: Skipped projections string