Package com.google.cloud.bigquery

Class LegacySQLTypeName

java.lang.Object
com.google.cloud.StringEnumValue
com.google.cloud.bigquery.LegacySQLTypeName
All Implemented Interfaces:
Serializable
public final class LegacySQLTypeName extends com.google.cloud.StringEnumValue
A type used in legacy SQL contexts. NOTE: some contexts use a mix of types; for example, for queries that use standard SQL, the return types are the legacy SQL types.
See Also:

  • Field Details

    • BYTES

      public static final LegacySQLTypeName BYTES
      Variable-length binary data.

    • STRING

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

    • INTEGER

      public static final LegacySQLTypeName INTEGER
      A 64-bit signed integer value.

    • FLOAT

      public static final LegacySQLTypeName FLOAT
      A 64-bit IEEE binary floating-point value.

    • NUMERIC

      public static final LegacySQLTypeName NUMERIC
      A decimal value with 38 digits of precision and 9 digits of scale. Note, support for this type is limited in legacy SQL.

    • BIGNUMERIC

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

    • BOOLEAN

      public static final LegacySQLTypeName BOOLEAN
      A Boolean value (true or false).

    • TIMESTAMP

      public static final LegacySQLTypeName TIMESTAMP
      Represents an absolute point in time, with microsecond precision.

    • DATE

      public static final LegacySQLTypeName DATE
      Represents a logical calendar date. Note, support for this type is limited in legacy SQL.

    • GEOGRAPHY

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

    • TIME

      public static final LegacySQLTypeName TIME
      Represents a time, independent of a specific date, to microsecond precision. Note, support for this type is limited in legacy SQL.

    • DATETIME

      public static final LegacySQLTypeName DATETIME
      Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision). Note, support for this type is limited in legacy SQL.

    • RECORD

      public static final LegacySQLTypeName RECORD
      A record type with a nested schema.

    • JSON

      public static final LegacySQLTypeName JSON
      Represents JSON data

    • INTERVAL

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

  • Method Details

    • getStandardType

      public StandardSQLTypeName getStandardType()
      Provides the standard SQL type name equivalent to this type name.

    • legacySQLTypeName

      public static LegacySQLTypeName legacySQLTypeName(StandardSQLTypeName type)
      Converts StandardSQLTypeName to LegacySQLTypeName

    • valueOfStrict

      public static LegacySQLTypeName valueOfStrict(String constant)
      Get the LegacySQLTypeName for the given String constant, and throw an exception if the constant is not recognized.

    • valueOf

      public static LegacySQLTypeName valueOf(String constant)
      Get the LegacySQLTypeName for the given String constant, and allow unrecognized values.

    • values

      public static LegacySQLTypeName[] values()
      Return the known values for LegacySQLTypeName.