Enum AggregateType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<AggregateType>

    public enum AggregateType
    extends java.lang.Enum<AggregateType>
    The type of an aggregate function.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      ANY
      The aggregate type for ANY(expression).
      ARRAY_AGG
      The aggregate type for ARRAY_AGG(expression).
      AVG
      The aggregate type for AVG(expression).
      BIT_AND_AGG
      The aggregate type for BIT_AND_AGG(expression).
      BIT_NAND_AGG
      The aggregate type for BIT_NAND_AGG(expression).
      BIT_NOR_AGG
      The aggregate type for BIT_NOR_AGG(expression).
      BIT_OR_AGG
      The aggregate type for BIT_OR_AGG(expression).
      BIT_XNOR_AGG
      The aggregate type for BIT_XNOR_AGG(expression).
      BIT_XOR_AGG
      The aggregate type for BIT_XOR_AGG(expression).
      CORR
      The aggregate type for CORR binary set function.
      COUNT
      The aggregate type for COUNT(expression).
      COUNT_ALL
      The aggregate type for COUNT(*).
      COVAR_POP
      The aggregate type for COVAR_POP binary set function.
      COVAR_SAMP
      The aggregate type for COVAR_SAMP binary set function.
      CUME_DIST
      The type for CUME_DIST() hypothetical set function.
      DENSE_RANK
      The type for DENSE_RANK() hypothetical set function.
      ENVELOPE
      The aggregate type for ENVELOPE(expression).
      EVERY
      The aggregate type for EVERY(expression).
      HISTOGRAM
      The aggregate type for HISTOGRAM(expression).
      JSON_ARRAYAGG
      The aggregate type for JSON_ARRAYAGG(expression).
      JSON_OBJECTAGG
      The aggregate type for JSON_OBJECTAGG(expression: expression).
      LISTAGG
      The aggregate type for LISTAGG(...).
      MAX
      The aggregate type for MAX(expression).
      MEDIAN
      The aggregate type for MEDIAN(expression).
      MIN
      The aggregate type for MIN(expression).
      MODE
      The aggregate type for MODE(expression).
      PERCENT_RANK
      The type for PERCENT_RANK() hypothetical set function.
      PERCENTILE_CONT
      The aggregate type for PERCENTILE_CONT(expression).
      PERCENTILE_DISC
      The aggregate type for PERCENTILE_DISC(expression).
      RANK
      The type for RANK() hypothetical set function.
      REGR_AVGX
      The aggregate type for REGR_AVGX binary set function.
      REGR_AVGY
      The aggregate type for REGR_AVGY binary set function.
      REGR_COUNT
      The aggregate type for REGR_COUNT binary set function.
      REGR_INTERCEPT
      The aggregate type for REGR_INTERCEPT binary set function.
      REGR_R2
      The aggregate type for REGR_R2 binary set function.
      REGR_SLOPE
      The aggregate type for REGR_SLOPE binary set function.
      REGR_SXX
      The aggregate type for REGR_SXX binary set function.
      REGR_SXY
      The aggregate type for REGR_SXY binary set function.
      REGR_SYY
      The aggregate type for REGR_SYY binary set function.
      STDDEV_POP
      The aggregate type for STDDEV_POP(expression).
      STDDEV_SAMP
      The aggregate type for STDDEV_SAMP(expression).
      SUM
      The aggregate type for SUM(expression).
      VAR_POP
      The aggregate type for VAR_POP(expression).
      VAR_SAMP
      The aggregate type for VAR_SAMP(expression).
    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private AggregateType()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static AggregateType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static AggregateType[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait
    • Enum Constant Detail

      • COUNT_ALL

        public static final AggregateType COUNT_ALL
        The aggregate type for COUNT(*).
      • COUNT

        public static final AggregateType COUNT
        The aggregate type for COUNT(expression).
      • SUM

        public static final AggregateType SUM
        The aggregate type for SUM(expression).
      • MIN

        public static final AggregateType MIN
        The aggregate type for MIN(expression).
      • MAX

        public static final AggregateType MAX
        The aggregate type for MAX(expression).
      • AVG

        public static final AggregateType AVG
        The aggregate type for AVG(expression).
      • STDDEV_POP

        public static final AggregateType STDDEV_POP
        The aggregate type for STDDEV_POP(expression).
      • STDDEV_SAMP

        public static final AggregateType STDDEV_SAMP
        The aggregate type for STDDEV_SAMP(expression).
      • VAR_POP

        public static final AggregateType VAR_POP
        The aggregate type for VAR_POP(expression).
      • VAR_SAMP

        public static final AggregateType VAR_SAMP
        The aggregate type for VAR_SAMP(expression).
      • ANY

        public static final AggregateType ANY
        The aggregate type for ANY(expression).
      • EVERY

        public static final AggregateType EVERY
        The aggregate type for EVERY(expression).
      • BIT_AND_AGG

        public static final AggregateType BIT_AND_AGG
        The aggregate type for BIT_AND_AGG(expression).
      • BIT_OR_AGG

        public static final AggregateType BIT_OR_AGG
        The aggregate type for BIT_OR_AGG(expression).
      • BIT_XOR_AGG

        public static final AggregateType BIT_XOR_AGG
        The aggregate type for BIT_XOR_AGG(expression).
      • BIT_NAND_AGG

        public static final AggregateType BIT_NAND_AGG
        The aggregate type for BIT_NAND_AGG(expression).
      • BIT_NOR_AGG

        public static final AggregateType BIT_NOR_AGG
        The aggregate type for BIT_NOR_AGG(expression).
      • BIT_XNOR_AGG

        public static final AggregateType BIT_XNOR_AGG
        The aggregate type for BIT_XNOR_AGG(expression).
      • HISTOGRAM

        public static final AggregateType HISTOGRAM
        The aggregate type for HISTOGRAM(expression).
      • COVAR_POP

        public static final AggregateType COVAR_POP
        The aggregate type for COVAR_POP binary set function.
      • COVAR_SAMP

        public static final AggregateType COVAR_SAMP
        The aggregate type for COVAR_SAMP binary set function.
      • CORR

        public static final AggregateType CORR
        The aggregate type for CORR binary set function.
      • REGR_SLOPE

        public static final AggregateType REGR_SLOPE
        The aggregate type for REGR_SLOPE binary set function.
      • REGR_INTERCEPT

        public static final AggregateType REGR_INTERCEPT
        The aggregate type for REGR_INTERCEPT binary set function.
      • REGR_COUNT

        public static final AggregateType REGR_COUNT
        The aggregate type for REGR_COUNT binary set function.
      • REGR_R2

        public static final AggregateType REGR_R2
        The aggregate type for REGR_R2 binary set function.
      • REGR_AVGX

        public static final AggregateType REGR_AVGX
        The aggregate type for REGR_AVGX binary set function.
      • REGR_AVGY

        public static final AggregateType REGR_AVGY
        The aggregate type for REGR_AVGY binary set function.
      • REGR_SXX

        public static final AggregateType REGR_SXX
        The aggregate type for REGR_SXX binary set function.
      • REGR_SYY

        public static final AggregateType REGR_SYY
        The aggregate type for REGR_SYY binary set function.
      • REGR_SXY

        public static final AggregateType REGR_SXY
        The aggregate type for REGR_SXY binary set function.
      • RANK

        public static final AggregateType RANK
        The type for RANK() hypothetical set function.
      • DENSE_RANK

        public static final AggregateType DENSE_RANK
        The type for DENSE_RANK() hypothetical set function.
      • PERCENT_RANK

        public static final AggregateType PERCENT_RANK
        The type for PERCENT_RANK() hypothetical set function.
      • CUME_DIST

        public static final AggregateType CUME_DIST
        The type for CUME_DIST() hypothetical set function.
      • PERCENTILE_CONT

        public static final AggregateType PERCENTILE_CONT
        The aggregate type for PERCENTILE_CONT(expression).
      • PERCENTILE_DISC

        public static final AggregateType PERCENTILE_DISC
        The aggregate type for PERCENTILE_DISC(expression).
      • MEDIAN

        public static final AggregateType MEDIAN
        The aggregate type for MEDIAN(expression).
      • LISTAGG

        public static final AggregateType LISTAGG
        The aggregate type for LISTAGG(...).
      • ARRAY_AGG

        public static final AggregateType ARRAY_AGG
        The aggregate type for ARRAY_AGG(expression).
      • MODE

        public static final AggregateType MODE
        The aggregate type for MODE(expression).
      • ENVELOPE

        public static final AggregateType ENVELOPE
        The aggregate type for ENVELOPE(expression).
      • JSON_OBJECTAGG

        public static final AggregateType JSON_OBJECTAGG
        The aggregate type for JSON_OBJECTAGG(expression: expression).
      • JSON_ARRAYAGG

        public static final AggregateType JSON_ARRAYAGG
        The aggregate type for JSON_ARRAYAGG(expression).
    • Constructor Detail

      • AggregateType

        private AggregateType()
    • Method Detail

      • values

        public static AggregateType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (AggregateType c : AggregateType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static AggregateType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null