Reference documentation and code samples for the Cloud Bigtable V2 Client class ExecuteQueryRequest.
Request message for Bigtable.ExecuteQuery
Generated from protobuf message google.bigtable.v2.ExecuteQueryRequest
Namespace
Google \ Cloud \ Bigtable \ V2Methods
__construct
Constructor.
data
array
Optional. Data for populating the Message object.
↳ instance_name
string
Required. The unique name of the instance against which the query should be executed. Values are of the form projects/<project>/instances/<instance>
↳ app_profile_id
string
Optional. This value specifies routing for replication. If not specified, the default
application profile will be used.
↳ query
string
Required. The query string. Exactly one of query
and prepared_query
is required. Setting both or neither is an INVALID_ARGUMENT
.
↳ prepared_query
string
A prepared query that was returned from PrepareQueryResponse
. Exactly one of query
and prepared_query
is required. Setting both or neither is an INVALID_ARGUMENT
. Setting this field also places restrictions on several other fields: - data_format
must be empty. - validate_only
must be false. - params
must match the param_types
set in the PrepareQueryRequest
.
↳ proto_format
↳ resume_token
string
Optional. If this request is resuming a previously interrupted query execution, resume_token
should be copied from the last PartialResultSet yielded before the interruption. Doing this enables the query execution to resume where the last one left off. The rest of the request parameters must exactly match the request that yielded this token. Otherwise the request will fail.
↳ params
array| Google\Protobuf\Internal\MapField
Required. params contains string type keys and Bigtable type values that bind to placeholders in the query string. In query string, a parameter placeholder consists of the @
character followed by the parameter name (for example, @firstName
) in the query string. For example, if params["firstName"] = bytes_value: "foo" type {bytes_type }}
then @firstName
will be replaced with googlesql bytes value "foo" in the query string during query evaluation. If Value.kind
is not set, the value is treated as a NULL value of the given type. For example, if params["firstName"] = type {string_type }}
then @firstName
will be replaced with googlesql null string. If query
is set, any empty Value.type
in the map will be rejected with INVALID_ARGUMENT
. If prepared_query
is set, any empty Value.type
in the map will be inferred from the param_types
in the PrepareQueryRequest
. Any non-empty Value.type
must match the corresponding param_types
entry, or be rejected with INVALID_ARGUMENT
.
getInstanceName
Required. The unique name of the instance against which the query should be executed.
Values are of the form projects/<project>/instances/<instance>
string
setInstanceName
Required. The unique name of the instance against which the query should be executed.
Values are of the form projects/<project>/instances/<instance>
var
string
$this
getAppProfileId
Optional. This value specifies routing for replication. If not specified,
the default
application profile will be used.
string
setAppProfileId
Optional. This value specifies routing for replication. If not specified,
the default
application profile will be used.
var
string
$this
getQuery
Required. The query string.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
string
setQuery
Required. The query string.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
var
string
$this
getPreparedQuery
A prepared query that was returned from PrepareQueryResponse
.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
Setting this field also places restrictions on several other fields:
-
data_format
must be empty. -
validate_only
must be false. -
params
must match theparam_types
set in thePrepareQueryRequest
.
string
setPreparedQuery
A prepared query that was returned from PrepareQueryResponse
.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
Setting this field also places restrictions on several other fields:
-
data_format
must be empty. -
validate_only
must be false. -
params
must match theparam_types
set in thePrepareQueryRequest
.
var
string
$this
getProtoFormat
Protocol buffer format as described by ProtoSchema and ProtoRows messages.
hasProtoFormat
setProtoFormat
Protocol buffer format as described by ProtoSchema and ProtoRows messages.
$this
getResumeToken
Optional. If this request is resuming a previously interrupted query
execution, resume_token
should be copied from the last
PartialResultSet yielded before the interruption. Doing this
enables the query execution to resume where the last one left
off.
The rest of the request parameters must exactly match the request that yielded this token. Otherwise the request will fail.
string
setResumeToken
Optional. If this request is resuming a previously interrupted query
execution, resume_token
should be copied from the last
PartialResultSet yielded before the interruption. Doing this
enables the query execution to resume where the last one left
off.
The rest of the request parameters must exactly match the request that yielded this token. Otherwise the request will fail.
var
string
$this
getParams
Required. params contains string type keys and Bigtable type values that
bind to placeholders in the query string. In query string, a parameter
placeholder consists of the @
character followed by the parameter name (for example, @firstName
) in
the query string.
For example, if params["firstName"] = bytes_value: "foo" type {bytes_type }}
then @firstName
will be replaced with googlesql bytes value "foo" in the
query string during query evaluation.
If Value.kind
is not set, the value is treated as a NULL value of the
given type. For example, if params["firstName"] = type {string_type }}
then @firstName
will be replaced with googlesql null string.
If query
is set, any empty Value.type
in the map will be rejected with INVALID_ARGUMENT
.
If prepared_query
is set, any empty Value.type
in the map will be
inferred from the param_types
in the PrepareQueryRequest
. Any non-empty Value.type
must match the corresponding param_types
entry, or be
rejected with INVALID_ARGUMENT
.
setParams
Required. params contains string type keys and Bigtable type values that
bind to placeholders in the query string. In query string, a parameter
placeholder consists of the @
character followed by the parameter name (for example, @firstName
) in
the query string.
For example, if params["firstName"] = bytes_value: "foo" type {bytes_type }}
then @firstName
will be replaced with googlesql bytes value "foo" in the
query string during query evaluation.
If Value.kind
is not set, the value is treated as a NULL value of the
given type. For example, if params["firstName"] = type {string_type }}
then @firstName
will be replaced with googlesql null string.
If query
is set, any empty Value.type
in the map will be rejected with INVALID_ARGUMENT
.
If prepared_query
is set, any empty Value.type
in the map will be
inferred from the param_types
in the PrepareQueryRequest
. Any non-empty Value.type
must match the corresponding param_types
entry, or be
rejected with INVALID_ARGUMENT
.
$this
getDataFormat
string
static::build
instanceName
string
Required. The unique name of the instance against which the query should be
executed.
Values are of the form projects/<project>/instances/<instance>
Please see BigtableClient::instanceName()
for help formatting this field.
query
string
Required. The query string.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
static::buildFromInstanceNameQueryAppProfileId
instanceName
string
Required. The unique name of the instance against which the query should be
executed.
Values are of the form projects/<project>/instances/<instance>
Please see BigtableClient::instanceName()
for help formatting this field.
query
string
Required. The query string.
Exactly one of query
and prepared_query
is required. Setting both
or neither is an INVALID_ARGUMENT
.
appProfileId
string
Optional. This value specifies routing for replication. If not specified,
the default
application profile will be used.