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

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