Class LegacySQLTypeName (2.33.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

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()

Object.clone()

Object.finalize()

Object.getClass()

Object.notify()

Object.notifyAll()

Object.wait()

Object.wait(long)

Object.wait(long,int)

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`

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`