Class LegacySQLTypeName (2.23.2)

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

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
TypeDescription
LegacySQLTypeName

BOOLEAN

public static final LegacySQLTypeName BOOLEAN

A Boolean value (true or false).

Field Value
TypeDescription
LegacySQLTypeName

BYTES

public static final LegacySQLTypeName BYTES

Variable-length binary data.

Field Value
TypeDescription
LegacySQLTypeName

DATE

public static final LegacySQLTypeName DATE

Represents a logical calendar date. Note, support for this type is limited in legacy SQL.

Field Value
TypeDescription
LegacySQLTypeName

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
TypeDescription
LegacySQLTypeName

FLOAT

public static final LegacySQLTypeName FLOAT

A 64-bit IEEE binary floating-point value.

Field Value
TypeDescription
LegacySQLTypeName

GEOGRAPHY

public static final LegacySQLTypeName GEOGRAPHY

Represents a set of geographic points, represented as a Well Known Text (WKT) string.

Field Value
TypeDescription
LegacySQLTypeName

INTEGER

public static final LegacySQLTypeName INTEGER

A 64-bit signed integer value.

Field Value
TypeDescription
LegacySQLTypeName

INTERVAL

public static final LegacySQLTypeName INTERVAL

Represents duration or amount of time.

Field Value
TypeDescription
LegacySQLTypeName

JSON

public static final LegacySQLTypeName JSON

Represents JSON data

Field Value
TypeDescription
LegacySQLTypeName

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
TypeDescription
LegacySQLTypeName

RECORD

public static final LegacySQLTypeName RECORD

A record type with a nested schema.

Field Value
TypeDescription
LegacySQLTypeName

STRING

public static final LegacySQLTypeName STRING

Variable-length character (Unicode) data.

Field Value
TypeDescription
LegacySQLTypeName

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
TypeDescription
LegacySQLTypeName

TIMESTAMP

public static final LegacySQLTypeName TIMESTAMP

Represents an absolute point in time, with microsecond precision.

Field Value
TypeDescription
LegacySQLTypeName

Static Methods

legacySQLTypeName(StandardSQLTypeName type)

public static LegacySQLTypeName legacySQLTypeName(StandardSQLTypeName type)

Converts StandardSQLTypeName to LegacySQLTypeName

Parameter
NameDescription
typeStandardSQLTypeName
Returns
TypeDescription
LegacySQLTypeName

valueOf(String constant)

public static LegacySQLTypeName valueOf(String constant)

Get the LegacySQLTypeName for the given String constant, and allow unrecognized values.

Parameter
NameDescription
constantString
Returns
TypeDescription
LegacySQLTypeName

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
NameDescription
constantString
Returns
TypeDescription
LegacySQLTypeName

values()

public static LegacySQLTypeName[] values()

Return the known values for LegacySQLTypeName.

Returns
TypeDescription
LegacySQLTypeName[]

Methods

getStandardType()

public StandardSQLTypeName getStandardType()

Provides the standard SQL type name equivalent to this type name.

Returns
TypeDescription
StandardSQLTypeName