Package com.google.cloud.bigquery

Class LegacySQLTypeName

java.lang.Object

com.google.cloud.StringEnumValue

com.google.cloud.bigquery.LegacySQLTypeName

All Implemented Interfaces:

Serializable

public final class LegacySQLTypeName
extends com.google.cloud.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, Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static LegacySQLTypeName	BIGNUMERIC	A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale
static LegacySQLTypeName	BOOLEAN	A Boolean value (true or false).
static LegacySQLTypeName	BYTES	Variable-length binary data.
static LegacySQLTypeName	DATE	Represents a logical calendar date.
static LegacySQLTypeName	DATETIME	Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).
static LegacySQLTypeName	FLOAT	A 64-bit IEEE binary floating-point value.
static LegacySQLTypeName	GEOGRAPHY	Represents a set of geographic points, represented as a Well Known Text (WKT) string.
static LegacySQLTypeName	INTEGER	A 64-bit signed integer value.
static LegacySQLTypeName	INTERVAL	Represents duration or amount of time.
static LegacySQLTypeName	JSON	Represents JSON data
static LegacySQLTypeName	NUMERIC	A decimal value with 38 digits of precision and 9 digits of scale.
static LegacySQLTypeName	RECORD	A record type with a nested schema.
static LegacySQLTypeName	STRING	Variable-length character (Unicode) data.
static LegacySQLTypeName	TIME	Represents a time, independent of a specific date, to microsecond precision.
static LegacySQLTypeName	TIMESTAMP	Represents an absolute point in time, with microsecond precision.

Method Summary

Modifier and Type	Method	Description
StandardSQLTypeName	getStandardType()	Provides the standard SQL type name equivalent to this type name.
static LegacySQLTypeName	legacySQLTypeName(StandardSQLTypeName type)	Converts StandardSQLTypeName to LegacySQLTypeName
static LegacySQLTypeName	valueOf(String constant)	Get the LegacySQLTypeName for the given String constant, and allow unrecognized values.
static LegacySQLTypeName	valueOfStrict(String constant)	Get the LegacySQLTypeName for the given String constant, and throw an exception if the constant is not recognized.
static LegacySQLTypeName[]	values()	Return the known values for LegacySQLTypeName.

Methods inherited from class com.google.cloud.StringEnumValue

equals, hashCode, name, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

BYTES

public static final LegacySQLTypeName BYTES

Variable-length binary data.

STRING

public static final LegacySQLTypeName STRING

Variable-length character (Unicode) data.

INTEGER

public static final LegacySQLTypeName INTEGER

A 64-bit signed integer value.

FLOAT

public static final LegacySQLTypeName FLOAT

A 64-bit IEEE binary floating-point 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.

BIGNUMERIC

public static final LegacySQLTypeName BIGNUMERIC

A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale

BOOLEAN

public static final LegacySQLTypeName BOOLEAN

A Boolean value (true or false).

TIMESTAMP

public static final LegacySQLTypeName TIMESTAMP

Represents an absolute point in time, with microsecond precision.

DATE

public static final LegacySQLTypeName DATE

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

GEOGRAPHY

public static final LegacySQLTypeName GEOGRAPHY

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

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.

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.

RECORD

public static final LegacySQLTypeName RECORD

A record type with a nested schema.

JSON

public static final LegacySQLTypeName JSON

Represents JSON data

INTERVAL

public static final LegacySQLTypeName INTERVAL

Represents duration or amount of time.

Method Detail

getStandardType

public StandardSQLTypeName getStandardType()

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

legacySQLTypeName

public static LegacySQLTypeName legacySQLTypeName(StandardSQLTypeName type)

Converts StandardSQLTypeName to LegacySQLTypeName

valueOfStrict

public static LegacySQLTypeName valueOfStrict(String constant)

Get the LegacySQLTypeName for the given String constant, and throw an exception if the constant is not recognized.

valueOf

public static LegacySQLTypeName valueOf(String constant)

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

values

public static LegacySQLTypeName[] values()

Return the known values for LegacySQLTypeName.