public final class LegacySQLTypeName extends 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: https://cloud.google.com/bigquery/data-types
Inheritance
java.lang.Object >
com.google.cloud.StringEnumValue >
LegacySQLTypeName
Inherited Members
com.google.cloud.StringEnumValue.equals(java.lang.Object)
com.google.cloud.StringEnumValue.hashCode()
com.google.cloud.StringEnumValue.name()
com.google.cloud.StringEnumValue.toString()
Static Fields
BIGNUMERIC
public static final LegacySQLTypeName BIGNUMERIC
A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale
Field Value
BOOLEAN
public static final LegacySQLTypeName BOOLEAN
A Boolean value (true or false).
Field Value
BYTES
public static final LegacySQLTypeName BYTES
Variable-length binary data.
Field Value
DATE
public static final LegacySQLTypeName DATE
Represents a logical calendar date. Note, support for this type is limited in legacy SQL.
Field Value
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.
Field Value
FLOAT
public static final LegacySQLTypeName FLOAT
A 64-bit IEEE binary floating-point value.
Field Value
GEOGRAPHY
public static final LegacySQLTypeName GEOGRAPHY
Represents a set of geographic points, represented as a Well Known Text (WKT) string.
Field Value
INTEGER
public static final LegacySQLTypeName INTEGER
A 64-bit signed integer value.
Field Value
JSON
public static final LegacySQLTypeName JSON
Field 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.
Field Value
RECORD
public static final LegacySQLTypeName RECORD
A record type with a nested schema.
Field Value
STRING
public static final LegacySQLTypeName STRING
Variable-length character (Unicode) data.
Field Value
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.
Field Value
TIMESTAMP
public static final LegacySQLTypeName TIMESTAMP
Represents an absolute point in time, with microsecond precision.
Field Value
Static Methods
legacySQLTypeName(StandardSQLTypeName type)
public static LegacySQLTypeName legacySQLTypeName(StandardSQLTypeName type)
Converts StandardSQLTypeName to LegacySQLTypeName
Parameter
Returns
valueOf(String constant)
public static LegacySQLTypeName valueOf(String constant)
Get the LegacySQLTypeName for the given String constant, and allow unrecognized values.
Parameter
Returns
valueOfStrict(String constant)
public static LegacySQLTypeName valueOfStrict(String constant)
Get the LegacySQLTypeName for the given String constant, and throw an exception if the constant
is not recognized.
Parameter
Returns
values()
public static LegacySQLTypeName[] values()
Return the known values for LegacySQLTypeName.
Returns
Methods
getStandardType()
public StandardSQLTypeName getStandardType()
Provides the standard SQL type name equivalent to this type name.
Returns