Class InsertAllRequest.RowToInsert (2.44.0) 

public static class InsertAllRequest.RowToInsert implements Serializable

A Google Big Query row to be inserted into a table. Each RowToInsert has an associated id used by BigQuery to detect duplicate insertion requests on a best-effort basis.

To ensure proper serialization of numeric data, it is recommended to supply values using a string-typed representation. Additionally, data for fields of LegacySQLTypeName#BYTES must be provided as a base64 encoded string.

Example usage of creating a row to insert:


 List<Long> repeatedFieldValue = Arrays.asList(1L, 2L);
 Map<String, Object> recordContent = new HashMap<String, Object>();
 recordContent.put("subfieldName1", "value");
 recordContent.put("subfieldName2", repeatedFieldValue);
 Map<String, Object> rowContent = new HashMap<String, Object>();
 rowContent.put("booleanFieldName", true);
 rowContent.put("bytesFieldName", "DQ4KDQ==");
 rowContent.put("recordFieldName", recordContent);
 rowContent.put("numericFieldName", "1298930929292.129593272");
 RowToInsert row = new RowToInsert("rowId", rowContent);

See Also: Data Consistency

Inheritance

Object > InsertAllRequest.RowToInsert

Implements

Serializable

Static Methods

of(String id, Map<String,?> content)

public static InsertAllRequest.RowToInsert of(String id, Map<String,?> content)

Creates a row to be inserted with associated id.

To ensure proper serialization of numeric data, supply values using a string-typed representation. Additionally, data for fields of LegacySQLTypeName#BYTES must be provided as a base64 encoded string.

Parameters
Name Description
id String

id of the row, used to identify duplicates
content Map<String,?>

the actual content of the row
Returns
Type Description
InsertAllRequest.RowToInsert

of(Map<String,?> content)

public static InsertAllRequest.RowToInsert of(Map<String,?> content)

Creates a row to be inserted without associated id.

To ensure proper serialization of numeric data, supply values using a string-typed representation. Additionally, data for fields of type LegacySQLTypeName#BYTES must be provided as a base64 encoded string.

Parameter
Name Description
content Map<String,?>

the actual content of the row
Returns
Type Description
InsertAllRequest.RowToInsert

Methods

equals(Object obj)

public boolean equals(Object obj)
Parameter
Name Description
obj Object
Returns
Type Description
boolean
Overrides

getContent()

public Map<String,Object> getContent()

Returns the actual content of the row, as a map.

The returned map is always immutable. Its iteration order is unspecified.

Returns
Type Description
Map<String,Object>

getId()

public String getId()

Returns the id associated with the row. Returns null if not set.

Returns
Type Description
String

hashCode()

public int hashCode()
Returns
Type Description
int
Overrides

toString()

public String toString()
Returns
Type Description
String
Overrides