Error Messages Associated with SQLSTATE 42P20

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

SQLSTATE 42P20 Description

ERRCODE_WINDOWING_ERROR

Error messages associated with this SQLState

ERROR 2011: string cannot use the WITHIN GROUP clause

ERROR 2041: string may only have one sort expression in the WITHIN GROUP clause

ERROR 2043: string must contain an ORDER BY clause within its analytic clause

ERROR 2044: string must NOT contain an ORDER BY clause or WINDOWING clause within its analytic clause

ERROR 2045: string must NOT contain WINDOWING clause within its analytic clause

ERROR 2047: string only supports the Integer, Float, Interval and Numeric data types

ERROR 2182: Analytic functions are allowed only in a SELECT list and/or ORDER BY clause

ERROR 2185: Analytic functions are not supported in the PARTITION BY of an OVER clause

ERROR 2188: Analytic functions must have a FROM clause

ERROR 2189: Analytic functions not allowed in string

ERROR 2305: Can't cast the window bound into Int

ERROR 2306: Can't cast the window bound into the same data type of the ORDER BY column

ERROR 2465: Cannot override ORDER BY clause of window "string"

ERROR 2466: Cannot override PARTITION BY clause of window "string"

ERROR 2524: Cannot specify frame clause of window "string"

ERROR 3435: For range moving window, OrderBy expression must be one of Int, Float, Time, Timestamp, Interval, Date or Numeric

ERROR 3446: Frame clause not allowed without windowing order by

ERROR 3839: Keyword "ALL" is invalid in analytic functions

ERROR 4362: PERCENTILE_CONT/PERCENTILE_DISC must have the WITHIN GROUP clause

ERROR 4363: PERCENTILE_CONT/PERCENTILE_DISC must NOT contain an ORDER BY clause or WINDOWING clause within its analytic clause

ERROR 4811: Subqueries are not supported in the PARTITION BY of a timeseries OVER clause

ERROR 5006: Time Series Aggregate Functions are not supported in the PARTITION BY of a timeseries OVER clause

ERROR 5010: Time Series timestamp alias/Time Series Aggregate Functions not allowed in string

ERROR 5460: Window "string" is already defined

ERROR 5461: Window frame cannot end with PRECEDING if start is CURRENT ROW

ERROR 5462: Window frame cannot end with PRECEDING or CURRENT ROW if start is FOLLOWING

ERROR 5463: Window frame cannot end with UNBOUNDED PRECEDING

ERROR 5464: Window frame cannot start with UNBOUNDED FOLLOWING

ERROR 5466: Window frame logical offset must be a non-negative number to be consistent with the sort column type

ERROR 5467: Window frame logical offset must be an Interval (Day to Second or Year to Month) to be consistent with the sort column type

ERROR 5468: Window frame logical offset must be an Interval (Day to Second) to be consistent with the sort column type

ERROR 5469: Window frame logical offset must be an interval to be consistent with the sort column type

ERROR 5470: Window frame logical offset must be Int when the sort column type is Int

ERROR 5471: Window frame logical offset must be the same type as the sort column type (Interval Day to Second)

ERROR 5472: Window frame logical offset must be the same type as the sort column type (Interval Year to Month)

ERROR 5473: Window frame logical or physical offset must be a constant

ERROR 5474: Window frame logical or physical offset must be non-negative number or interval

ERROR 5475: Window frame physical offset must be non-negative number

ERROR 5477: Window ordering clause can only contain a single sort key if RANGE is used

ERROR 5478: Windowing not supported for User Defined Analytic functions

ERROR 6276: Grouping functions cannot appear within Analytic functions

ERROR 6900: Partition Prepass/Batch may only be used with Live Aggregate Projection

ERROR 7838: Windowing not supported for analytic usage of BOOL_XOR