Error Messages Associated with SQLSTATE 42V13

This topic lists the errors associated with the SQLSTATE 42V13.

SQLSTATE 42V13 Description

ERRCODE_INVALID_FUNCTION_DEFINITION

Error messages associated with this SQLState

ERROR 2038: string is not a supported Time Series Aggregate Function
ERROR 2139: Aggregates may not return sets
ERROR 2173: An error occurred on node [string] when setting up the function [string]: [string]
ERROR 2177: An error occurred when setting up function "string"
ERROR 2397: Cannot determine result data type
ERROR 2451: Cannot load data from 0 sources; please specify 1 or more (on node [string])
ERROR 2494: Cannot RETURNREJECTED with multiple files or data sources
ERROR 3113: DISTINCT is supported only for single-argument aggregates
ERROR 3476: Functions in language string can be created only in fenced mode
ERROR 3604: Interpolation scheme string for Time Series Aggregate Function string is not supported
ERROR 3708: Invalid null argument for TSA function string
ERROR 3843: Language(string) does not match the language associated with the library(string)
ERROR 3854: Length of a string in a return type must be greater than zero
ERROR 3860: Library file is not loaded
ERROR 3861: Library not found: string
ERROR 3929: Meta functions cannot be used in UDx definitions
ERROR 4086: No language specified
ERROR 4095: No procedure source specified
ERROR 4096: No procedure user specified
ERROR 4251: Only one expression is allowed
ERROR 4257: Only simple "RETURN expression" is allowed
ERROR 4409: Precision of a numeric in a return type must be greater than zero
ERROR 4608: Return type string is not supported for SQL functions
ERROR 4609: Return type mismatch in a function declared to return string
ERROR 4610: Return type mismatch in function declared to return string
ERROR 4746: Setting up function "string" failed
ERROR 4858: Syntax error in syntax definition at offset value
ERROR 4949: The interpolation argument for Time Series Aggregate Function string must be a constant string
ERROR 5476: Window functions cannot return sets
ERROR 5777: Cannot set up function [string] on node: string
ERROR 6072: UDFileSystem only supports C++ unfenced mode
ERROR 6536: The getPrototype(value) and getReturnType(value) method must have matching number of returnTypes
ERROR 6537: The return types declared by getPrototype() and getReturnType() do not match
ERROR 6850: Library [string] built with incompatible SDK version [string]. Please rebuild with SDK version [string] and recreate the library
ERROR 6999: The library [string] for the function [string] was compiled with an incompatible SDK Version [string]
ERROR 7270: Invalid schema.table.column, table.column, or column specification
ERROR 8976: Only MIN/MAX and BOOL_AND/BOOL_OR are allowed to use DISTINCT

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