Class LegacySQLTypeName (2.43.0)

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
Type Description
LegacySQLTypeName

BOOLEAN

public static final LegacySQLTypeName BOOLEAN

A Boolean value (true or false).

Field Value
Type Description
LegacySQLTypeName

BYTES

public static final LegacySQLTypeName BYTES

Variable-length binary data.

Field Value
Type Description
LegacySQLTypeName

DATE

public static final LegacySQLTypeName DATE

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

Field Value
Type Description
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
Type Description
LegacySQLTypeName

FLOAT

public static final LegacySQLTypeName FLOAT

A 64-bit IEEE binary floating-point value.

Field Value
Type Description
LegacySQLTypeName

GEOGRAPHY

public static final LegacySQLTypeName GEOGRAPHY

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

Field Value
Type Description
LegacySQLTypeName

INTEGER

public static final LegacySQLTypeName INTEGER

A 64-bit signed integer value.

Field Value
Type Description
LegacySQLTypeName

INTERVAL

public static final LegacySQLTypeName INTERVAL

Represents duration or amount of time.

Field Value
Type Description
LegacySQLTypeName

JSON

public static final LegacySQLTypeName JSON

Represents JSON data

Field Value
Type Description
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
Type Description
LegacySQLTypeName

RANGE

public static final LegacySQLTypeName RANGE

Represents a contiguous range of values.

Field Value
Type Description
LegacySQLTypeName

RECORD

public static final LegacySQLTypeName RECORD

A record type with a nested schema.

Field Value
Type Description
LegacySQLTypeName

STRING

public static final LegacySQLTypeName STRING

Variable-length character (Unicode) data.

Field Value
Type Description
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
Type Description
LegacySQLTypeName

TIMESTAMP

public static final LegacySQLTypeName TIMESTAMP

Represents an absolute point in time, with microsecond precision.

Field Value
Type Description
LegacySQLTypeName

Static Methods

legacySQLTypeName(StandardSQLTypeName type)

public static LegacySQLTypeName legacySQLTypeName(StandardSQLTypeName type)

Converts StandardSQLTypeName to LegacySQLTypeName

Parameter
Name Description
type StandardSQLTypeName
Returns
Type Description
LegacySQLTypeName

valueOf(String constant)

public static LegacySQLTypeName valueOf(String constant)

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

Parameter
Name Description
constant String
Returns
Type Description
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
Name Description
constant String
Returns
Type Description
LegacySQLTypeName

values()

public static LegacySQLTypeName[] values()

Return the known values for LegacySQLTypeName.

Returns
Type Description
LegacySQLTypeName[]

Methods

getStandardType()

public StandardSQLTypeName getStandardType()

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

Returns
Type Description
StandardSQLTypeName