StructType

StructType defines the fields of aSTRUCT type.

JSON representation
{"fields":[{object (Field)}]}
Fields
fields[]

object (Field)

The list of fields that make up this struct. Order is significant, because values of this struct type are represented as lists, where the order of field values matches the order of fields in theStructType. In turn, the order of fields matches the order of columns in a read request, or the order of fields in theSELECT clause of a query.

Field

Message representing a single field of a struct.

JSON representation
{"name":string,"type":{object (Type)}}
Fields
name

string

The name of the field. For reads, this is the column name. For SQL queries, it is the column alias (e.g.,"Word" in the query"SELECT 'hello' AS Word"), or the column name (e.g.,"ColName" in the query"SELECT ColName FROM Table"). Some columns might have an empty name (e.g.,"SELECT UPPER(ColName)"). Note that a query result can contain multiple fields with the same name.

type

object (Type)

The type of the field.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-05-30 UTC.