com.google.cloud.bigquery

Class Routine.Builder

java.lang.Object

com.google.cloud.bigquery.RoutineInfo.Builder

com.google.cloud.bigquery.Routine.Builder

Enclosing class:

Routine

public static class Routine.Builder
extends RoutineInfo.Builder

Method Summary

Modifier and Type	Method and Description
Routine	build() Creates a RoutineInfo object.
Routine.Builder	setArguments(List<RoutineArgument> arguments) Specifies the list of input/output arguments for the routine.
Routine.Builder	setBody(String body) Required.
Routine.Builder	setImportedLibraries(List<String> libraries) Optional.
Routine.Builder	setLanguage(String language) Sets the language for the routine (e.g.
Routine.Builder	setReturnType(StandardSQLDataType returnType) Sets the return type of the routine.
Routine.Builder	setRoutineType(String routineType) Sets the routine type for the Builder (e.g.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

setRoutineType

public Routine.Builder setRoutineType(String routineType)

Description copied from class: RoutineInfo.Builder

Sets the routine type for the Builder (e.g. SCALAR_FUNCTION).

See https://cloud.google.com/bigquery/docs/reference/rest/v2/routines

Specified by:

setRoutineType in class RoutineInfo.Builder

setLanguage

public Routine.Builder setLanguage(String language)

Description copied from class: RoutineInfo.Builder

Sets the language for the routine (e.g. SQL or JAVASCRIPT)

Specified by:

setLanguage in class RoutineInfo.Builder

setArguments

public Routine.Builder setArguments(List<RoutineArgument> arguments)

Description copied from class: RoutineInfo.Builder

Specifies the list of input/output arguments for the routine.

Specified by:

setArguments in class RoutineInfo.Builder

setReturnType

public Routine.Builder setReturnType(StandardSQLDataType returnType)

Description copied from class: RoutineInfo.Builder

Sets the return type of the routine.

Optional if language = "SQL"; required otherwise.

If absent, the return type is inferred from definitionBody at query time in each query that references this routine. If present, then the evaluated result will be cast to the specified returned type at query time.

Specified by:

setReturnType in class RoutineInfo.Builder

setImportedLibraries

public Routine.Builder setImportedLibraries(List<String> libraries)

Description copied from class: RoutineInfo.Builder

Optional. If language = "JAVASCRIPT", this field stores the path of the imported JAVASCRIPT libraries as a list of gs:// URLs.

Specified by:

setImportedLibraries in class RoutineInfo.Builder

setBody

public Routine.Builder setBody(String body)

Description copied from class: RoutineInfo.Builder

Required. The body of the routine.

For functions, this is the expression in the AS clause.

If language=SQL, it is the substring inside (but excluding) the parentheses. For example, for the function created with the following statement:

CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y))

The definitionBody is concat(x, "\n", y) (\n is not replaced with linebreak).

If language=JAVASCRIPT, it is the evaluated string in the AS clause. For example, for the function created with the following statement:

CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n'

The definitionBody is

return "\n";\n

Note that both \n are replaced with linebreaks.

Specified by:

setBody in class RoutineInfo.Builder

build

public Routine build()

Description copied from class: RoutineInfo.Builder

Creates a RoutineInfo object.

Specified by:

build in class RoutineInfo.Builder