LegacySQLTypeName (BigQuery Parent 2.29.0 API)

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 and 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

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and 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.

Class LegacySQLTypeName

Field Summary

Method Summary

Methods inherited from class com.google.cloud.StringEnumValue

Methods inherited from class java.lang.Object

Field Detail

BYTES

STRING

INTEGER

FLOAT

NUMERIC

BIGNUMERIC

BOOLEAN

TIMESTAMP

DATE

GEOGRAPHY

TIME

DATETIME

RECORD

JSON

INTERVAL

Method Detail

getStandardType

legacySQLTypeName

valueOfStrict

valueOf

values