Package com.google.cloud.bigquery

Enum StandardSQLTypeName

java.lang.Object
java.lang.Enum<StandardSQLTypeName>
com.google.cloud.bigquery.StandardSQLTypeName
All Implemented Interfaces:
Serializable, Comparable<StandardSQLTypeName>
public enum StandardSQLTypeName extends Enum<StandardSQLTypeName>
A type used in standard SQL contexts. For example, these types are used in queries with query parameters, which requires usage of standard SQL.
See Also:

  • Enum Constant Summary

    Enum Constants
    Enum Constant
    Description
    ARRAY
    Ordered list of zero or more elements of any non-array type.
    BIGNUMERIC
    A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale
    BOOL
    A Boolean value (true or false).
    BYTES
    Variable-length binary data.
    DATE
    Represents a logical calendar date.
    DATETIME
    Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).
    FLOAT64
    A 64-bit IEEE binary floating-point value.
    GEOGRAPHY
    Represents a set of geographic points, represented as a Well Known Text (WKT) string.
    INT64
    A 64-bit signed integer value.
    INTERVAL
    Represents duration or amount of time.
    JSON
    Represents JSON data.
    NUMERIC
    A decimal value with 38 digits of precision and 9 digits of scale.
    STRING
    Variable-length character (Unicode) data.
    STRUCT
    Container of ordered fields each with a type (required) and field name (optional).
    TIME
    Represents a time, independent of a specific date, to microsecond precision.
    TIMESTAMP
    Represents an absolute point in time, with microsecond precision.

  • Method Summary

    Modifier and Type
    Method
    Description
    static StandardSQLTypeName
    valueOf(String name)
    Returns the enum constant of this type with the specified name.
    static StandardSQLTypeName[]
    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 Details

    • BOOL

      public static final StandardSQLTypeName BOOL
      A Boolean value (true or false).

    • INT64

      public static final StandardSQLTypeName INT64
      A 64-bit signed integer value.

    • FLOAT64

      public static final StandardSQLTypeName FLOAT64
      A 64-bit IEEE binary floating-point value.

    • NUMERIC

      public static final StandardSQLTypeName NUMERIC
      A decimal value with 38 digits of precision and 9 digits of scale.

    • BIGNUMERIC

      public static final StandardSQLTypeName BIGNUMERIC
      A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale

    • STRING

      public static final StandardSQLTypeName STRING
      Variable-length character (Unicode) data.

    • BYTES

      public static final StandardSQLTypeName BYTES
      Variable-length binary data.

    • STRUCT

      public static final StandardSQLTypeName STRUCT
      Container of ordered fields each with a type (required) and field name (optional).

    • ARRAY

      public static final StandardSQLTypeName ARRAY
      Ordered list of zero or more elements of any non-array type.

    • TIMESTAMP

      public static final StandardSQLTypeName TIMESTAMP
      Represents an absolute point in time, with microsecond precision. Values range between the years 1 and 9999, inclusive.

    • DATE

      public static final StandardSQLTypeName DATE
      Represents a logical calendar date. Values range between the years 1 and 9999, inclusive.

    • TIME

      public static final StandardSQLTypeName TIME
      Represents a time, independent of a specific date, to microsecond precision.

    • DATETIME

      public static final StandardSQLTypeName DATETIME
      Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).

    • GEOGRAPHY

      public static final StandardSQLTypeName GEOGRAPHY
      Represents a set of geographic points, represented as a Well Known Text (WKT) string.

    • JSON

      public static final StandardSQLTypeName JSON
      Represents JSON data.

    • INTERVAL

      public static final StandardSQLTypeName INTERVAL
      Represents duration or amount of time.

  • Method Details

    • values

      public static StandardSQLTypeName[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      Returns:
      an array containing the constants of this enum type, in the order they are declared

    • valueOf

      public static StandardSQLTypeName valueOf(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:
      IllegalArgumentException - if this enum type has no constant with the specified name
      NullPointerException - if the argument is null