A set of input parameters for const.
More...
#include <gpudb/protocol/execute_sql.h>
|
| ExecuteSqlRequest () |
| Constructs an ExecuteSqlRequest object with default parameter values. More...
|
|
| ExecuteSqlRequest (const std::string &statement_, const int64_t offset_, const int64_t limit_, const std::string &requestSchemaStr_, const std::vector< std::vector< uint8_t > > &data_, const std::map< std::string, std::string > &options_) |
| Constructs an ExecuteSqlRequest object with the specified parameters. More...
|
|
| ExecuteSqlRequest (const std::string &statement_, const int64_t offset_, const int64_t limit_, const std::string &encoding_, const std::string &requestSchemaStr_, const std::vector< std::vector< uint8_t > > &data_, const std::map< std::string, std::string > &options_) |
| Constructs an ExecuteSqlRequest object with the specified parameters. More...
|
|
A set of input parameters for const.
SQL Request
Definition at line 20 of file execute_sql.h.
gpudb::ExecuteSqlRequest::ExecuteSqlRequest |
( |
| ) |
|
|
inline |
gpudb::ExecuteSqlRequest::ExecuteSqlRequest |
( |
const std::string & |
statement_, |
|
|
const int64_t |
offset_, |
|
|
const int64_t |
limit_, |
|
|
const std::string & |
requestSchemaStr_, |
|
|
const std::vector< std::vector< uint8_t > > & |
data_, |
|
|
const std::map< std::string, std::string > & |
options_ |
|
) |
| |
|
inline |
Constructs an ExecuteSqlRequest object with the specified parameters.
- Parameters
-
[in] | statement_ | SQL statement (query, DML, or DDL) to be executed |
[in] | offset_ | A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The minimum allowed value is 0. The maximum allowed value is MAX_INT. |
[in] | limit_ | A positive integer indicating the maximum number of results to be returned, or END_OF_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the max_get_records_size parameter in the server configuration. Use hasMoreRecords to see if more records exist in the result to be fetched, and offset & limit to request subsequent pages of results. |
[in] | requestSchemaStr_ | Avro schema of data. |
[in] | data_ | An array of binary-encoded data for the records to be binded to the SQL query. |
[in] | options_ | Optional parameters.
-
gpudb::execute_sql_parallel_execution: If false, disables the parallel step execution of the given query.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_cost_based_optimization: If false, disables the cost-based optimization of the given query.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_plan_cache: If false, disables plan caching for the given query.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_rule_based_optimization: If false, disables rule-based rewrite optimizations for the given query
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_results_caching: If false, disables caching of the results of the given query
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_paging_table: When empty or the specified paging table not exists, the system will create a paging table and return when query output has more records than the user asked. If the paging table exists in the system, the records from the paging table are returned without evaluating the query.
-
gpudb::execute_sql_paging_table_ttl: Sets the TTL of the paging table.
-
gpudb::execute_sql_distributed_joins: If true, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_distributed_operations: If true, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_ssq_optimization: If false, scalar subqueries will be translated into joins
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_late_materialization: If true, Joins/Filters results will always be materialized ( saved to result tables format)
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_ttl: Sets the TTL of the intermediate result tables used in query execution.
-
gpudb::execute_sql_update_on_existing_pk: Can be used to customize behavior when the updated primary key value already exists as described in /insert/records.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_preserve_dict_encoding: If true, then columns that were dict encoded in the source table will be dict encoded in the projection table.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_validate_change_column: When changing a column using alter table, validate the change before applying it. If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_prepare_mode: If true, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_view_id: <DEVELOPER> The default value is ''.
-
gpudb::execute_sql_no_count: <DEVELOPER> The default value is 'false'.
|
Definition at line 220 of file execute_sql.h.
gpudb::ExecuteSqlRequest::ExecuteSqlRequest |
( |
const std::string & |
statement_, |
|
|
const int64_t |
offset_, |
|
|
const int64_t |
limit_, |
|
|
const std::string & |
encoding_, |
|
|
const std::string & |
requestSchemaStr_, |
|
|
const std::vector< std::vector< uint8_t > > & |
data_, |
|
|
const std::map< std::string, std::string > & |
options_ |
|
) |
| |
|
inline |
Constructs an ExecuteSqlRequest object with the specified parameters.
- Parameters
-
[in] | statement_ | SQL statement (query, DML, or DDL) to be executed |
[in] | offset_ | A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The minimum allowed value is 0. The maximum allowed value is MAX_INT. |
[in] | limit_ | A positive integer indicating the maximum number of results to be returned, or END_OF_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the max_get_records_size parameter in the server configuration. Use hasMoreRecords to see if more records exist in the result to be fetched, and offset & limit to request subsequent pages of results. |
[in] | encoding_ | Specifies the encoding for returned records; either 'binary' or 'json'.
The default value is gpudb::execute_sql_binary. |
[in] | requestSchemaStr_ | Avro schema of data. |
[in] | data_ | An array of binary-encoded data for the records to be binded to the SQL query. |
[in] | options_ | Optional parameters.
-
gpudb::execute_sql_parallel_execution: If false, disables the parallel step execution of the given query.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_cost_based_optimization: If false, disables the cost-based optimization of the given query.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_plan_cache: If false, disables plan caching for the given query.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_rule_based_optimization: If false, disables rule-based rewrite optimizations for the given query
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_results_caching: If false, disables caching of the results of the given query
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_paging_table: When empty or the specified paging table not exists, the system will create a paging table and return when query output has more records than the user asked. If the paging table exists in the system, the records from the paging table are returned without evaluating the query.
-
gpudb::execute_sql_paging_table_ttl: Sets the TTL of the paging table.
-
gpudb::execute_sql_distributed_joins: If true, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_distributed_operations: If true, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_ssq_optimization: If false, scalar subqueries will be translated into joins
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_late_materialization: If true, Joins/Filters results will always be materialized ( saved to result tables format)
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_ttl: Sets the TTL of the intermediate result tables used in query execution.
-
gpudb::execute_sql_update_on_existing_pk: Can be used to customize behavior when the updated primary key value already exists as described in /insert/records.
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_preserve_dict_encoding: If true, then columns that were dict encoded in the source table will be dict encoded in the projection table.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_validate_change_column: When changing a column using alter table, validate the change before applying it. If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated.
The default value is gpudb::execute_sql_true.
-
gpudb::execute_sql_prepare_mode: If true, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user
The default value is gpudb::execute_sql_false.
-
gpudb::execute_sql_view_id: <DEVELOPER> The default value is ''.
-
gpudb::execute_sql_no_count: <DEVELOPER> The default value is 'false'.
|
Definition at line 421 of file execute_sql.h.
std::vector<std::vector<uint8_t> > gpudb::ExecuteSqlRequest::data |
std::string gpudb::ExecuteSqlRequest::encoding |
int64_t gpudb::ExecuteSqlRequest::limit |
int64_t gpudb::ExecuteSqlRequest::offset |
std::map<std::string, std::string> gpudb::ExecuteSqlRequest::options |
std::string gpudb::ExecuteSqlRequest::requestSchemaStr |
std::string gpudb::ExecuteSqlRequest::statement |
The documentation for this struct was generated from the following file: