Messages associated with SQLSTATE 42P20

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

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

SQLSTATE 42P20 description

WINDOWING_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 2187: Analytic functions cannot be nested
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