A set of parameters for Kinetica.executeSql(string,long,long,string,IList{byte[]},IDictionary{string, string}). More...

Inheritance diagram for kinetica.ExecuteSqlRequest:

Collaboration diagram for kinetica.ExecuteSqlRequest:

Classes
struct	Encoding
	Specifies the encoding for returned records; either 'binary' or 'json'. More...

struct	Options
	Optional parameters. More...

Public Member Functions
	ExecuteSqlRequest ()
	Constructs an ExecuteSqlRequest object with default parameters. More...

	ExecuteSqlRequest (string statement, long?offset=null, long?limit=null, string request_schema_str=null, IList< byte[]> data=null, IDictionary< string, string > options=null)
	Constructs an ExecuteSqlRequest object with the specified parameters. More...

	ExecuteSqlRequest (string statement, long?offset=null, long?limit=null, string encoding=null, string request_schema_str=null, IList< byte[]> data=null, IDictionary< string, string > options=null)
	Constructs an ExecuteSqlRequest object with the specified parameters. More...

Public Member Functions inherited from kinetica.KineticaData
	KineticaData (KineticaType type)
	Constructor from Kinetica Type More...

	KineticaData (System.Type type=null)
	Default constructor, with optional System.Type More...

object	Get (int fieldPos)
	Retrieve a specific property from this object More...

void	Put (int fieldPos, object fieldValue)
	Write a specific property to this object More...

Properties
string	statement `[get, set]`
	SQL statement (query, DML, or DDL) to be executed More...

long	offset `[get, set]`
	A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). More...

long	limit = 0 `[get, set]`
	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. More...

string	encoding = -9999 `[get, set]`
	Specifies the encoding for returned records; either 'binary' or 'json'. More...

string	request_schema_str = Encoding.BINARY `[get, set]`
	Avro schema of . More...

IList< byte[]>	data = "" `[get, set]`
	An array of binary-encoded data for the records to be binded to the SQL query. More...

IDictionary< string, string >	options = new List<byte[]>() `[get, set]`
	Optional parameters. More...

Properties inherited from kinetica.KineticaData
Schema	Schema `[get]`
	Avro Schema for this class More...

Additional Inherited Members
Static Public Member Functions inherited from kinetica.KineticaData
static RecordSchema	SchemaFromType (System.Type t, KineticaType ktype=null)
	Create an Avro Schema from a System.Type and a KineticaType. More...

Detailed Description

A set of parameters for Kinetica.executeSql(string,long,long,string,IList{byte[]},IDictionary{string, string}).

SQL Request

Definition at line 19 of file ExecuteSql.cs.

Constructor & Destructor Documentation

kinetica.ExecuteSqlRequest.ExecuteSqlRequest ( )

inline

Constructs an ExecuteSqlRequest object with default parameters.

Definition at line 964 of file ExecuteSql.cs.

kinetica.ExecuteSqlRequest.ExecuteSqlRequest	(	string	statement,
		long?	offset = `null`,
		long?	limit = `null`,
		string	request_schema_str = `null`,
		IList< byte[]>	data = `null`,
		IDictionary< string, string >	options = `null`
	)

inline

Constructs an ExecuteSqlRequest object with the specified parameters.

Parameters

statement	SQL statement (query, DML, or DDL) to be executed
offset	A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0.The minimum allowed value is 0. The maximum allowed value is MAX_INT.
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 <member name="has_more_records"> to see if more records exist in the result to be fetched, and & to request subsequent pages of results. The default value is -9999.
request_schema_str	Avro schema of . The default value is ''.
data	An array of binary-encoded data for the records to be binded to the SQL query. The default value is an empty List.
options	Optional parameters. PARALLEL_EXECUTION: If false, disables the parallel step execution of the given query. Supported values: TRUE FALSE The default value is TRUE. COST_BASED_OPTIMIZATION: If false, disables the cost-based optimization of the given query. Supported values: TRUE FALSE The default value is FALSE. PLAN_CACHE: If false, disables plan caching for the given query. Supported values: TRUE FALSE The default value is TRUE. RULE_BASED_OPTIMIZATION: If false, disables rule-based rewrite optimizations for the given query Supported values: TRUE FALSE The default value is TRUE. RESULTS_CACHING: If false, disables caching of the results of the given query Supported values: TRUE FALSE The default value is TRUE. 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. PAGING_TABLE_TTL: Sets the TTL of the paging table. 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. Supported values: TRUE FALSE The default value is FALSE. 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. Supported values: TRUE FALSE The default value is FALSE. SSQ_OPTIMIZATION: If false, scalar subqueries will be translated into joins Supported values: TRUE FALSE The default value is TRUE. LATE_MATERIALIZATION: If true, Joins/Filters results will always be materialized ( saved to result tables format) Supported values: TRUE FALSE The default value is FALSE. TTL: Sets the TTL of the intermediate result tables used in query execution. UPDATE_ON_EXISTING_PK: Can be used to customize behavior when the updated primary key value already exists as described in /insert/records. Supported values: TRUE FALSE The default value is FALSE. PRESERVE_DICT_ENCODING: If true, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values: TRUE FALSE The default value is TRUE. 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. Supported values: TRUE: true FALSE: false The default value is TRUE. 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 Supported values: TRUE FALSE The default value is FALSE. VIEW_ID: <DEVELOPER> The default value is ''. NO_COUNT: <DEVELOPER> The default value is 'false'. The default value is an empty Dictionary.

Definition at line 1292 of file ExecuteSql.cs.

kinetica.ExecuteSqlRequest.ExecuteSqlRequest	(	string	statement,
		long?	offset = `null`,
		long?	limit = `null`,
		string	encoding = `null`,
		string	request_schema_str = `null`,
		IList< byte[]>	data = `null`,
		IDictionary< string, string >	options = `null`
	)

inline

Constructs an ExecuteSqlRequest object with the specified parameters.

Parameters

statement	SQL statement (query, DML, or DDL) to be executed
offset	A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0.The minimum allowed value is 0. The maximum allowed value is MAX_INT.
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 <member name="has_more_records"> to see if more records exist in the result to be fetched, and & to request subsequent pages of results. The default value is -9999.
encoding	Specifies the encoding for returned records; either 'binary' or 'json'. Supported values: BINARY JSON The default value is BINARY.
request_schema_str	Avro schema of . The default value is ''.
data	An array of binary-encoded data for the records to be binded to the SQL query. The default value is an empty List.
options	Optional parameters. PARALLEL_EXECUTION: If false, disables the parallel step execution of the given query. Supported values: TRUE FALSE The default value is TRUE. COST_BASED_OPTIMIZATION: If false, disables the cost-based optimization of the given query. Supported values: TRUE FALSE The default value is FALSE. PLAN_CACHE: If false, disables plan caching for the given query. Supported values: TRUE FALSE The default value is TRUE. RULE_BASED_OPTIMIZATION: If false, disables rule-based rewrite optimizations for the given query Supported values: TRUE FALSE The default value is TRUE. RESULTS_CACHING: If false, disables caching of the results of the given query Supported values: TRUE FALSE The default value is TRUE. 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. PAGING_TABLE_TTL: Sets the TTL of the paging table. 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. Supported values: TRUE FALSE The default value is FALSE. 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. Supported values: TRUE FALSE The default value is FALSE. SSQ_OPTIMIZATION: If false, scalar subqueries will be translated into joins Supported values: TRUE FALSE The default value is TRUE. LATE_MATERIALIZATION: If true, Joins/Filters results will always be materialized ( saved to result tables format) Supported values: TRUE FALSE The default value is FALSE. TTL: Sets the TTL of the intermediate result tables used in query execution. UPDATE_ON_EXISTING_PK: Can be used to customize behavior when the updated primary key value already exists as described in /insert/records. Supported values: TRUE FALSE The default value is FALSE. PRESERVE_DICT_ENCODING: If true, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values: TRUE FALSE The default value is TRUE. 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. Supported values: TRUE: true FALSE: false The default value is TRUE. 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 Supported values: TRUE FALSE The default value is FALSE. VIEW_ID: <DEVELOPER> The default value is ''. NO_COUNT: <DEVELOPER> The default value is 'false'. The default value is an empty Dictionary.

Definition at line 1650 of file ExecuteSql.cs.

Property Documentation

IList<byte[]> kinetica.ExecuteSqlRequest.data = ""

getset

An array of binary-encoded data for the records to be binded to the SQL query.

The default value is an empty List.

Definition at line 658 of file ExecuteSql.cs.

string kinetica.ExecuteSqlRequest.encoding = -9999

getset

Specifies the encoding for returned records; either 'binary' or 'json'.

Supported values:

BINARY
JSON

The default value is BINARY.

Definition at line 649 of file ExecuteSql.cs.

long kinetica.ExecuteSqlRequest.limit = 0

getset

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 <member name="has_more_records"> to see if more records exist in the result to be fetched, and & to request subsequent pages of results. The default value is -9999.

Definition at line 632 of file ExecuteSql.cs.

long kinetica.ExecuteSqlRequest.offset

getset

A positive integer indicating the number of initial results to skip (this can be useful for paging through the results).

The default value is 0.The minimum allowed value is 0. The maximum allowed value is MAX_INT.

Definition at line 619 of file ExecuteSql.cs.

IDictionary<string, string> kinetica.ExecuteSqlRequest.options = new List<byte[]>()

getset

Optional parameters.

PARALLEL_EXECUTION: If false, disables the parallel step execution of the given query. Supported values:
- TRUE
- FALSE
The default value is TRUE.
COST_BASED_OPTIMIZATION: If false, disables the cost-based optimization of the given query. Supported values:
- TRUE
- FALSE
The default value is FALSE.
PLAN_CACHE: If false, disables plan caching for the given query. Supported values:
- TRUE
- FALSE
The default value is TRUE.
RULE_BASED_OPTIMIZATION: If false, disables rule-based rewrite optimizations for the given query Supported values:
- TRUE
- FALSE
The default value is TRUE.
RESULTS_CACHING: If false, disables caching of the results of the given query Supported values:
- TRUE
- FALSE
The default value is TRUE.
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.
PAGING_TABLE_TTL: Sets the TTL of the paging table.
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. Supported values:
- TRUE
- FALSE
The default value is FALSE.
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. Supported values:
- TRUE
- FALSE
The default value is FALSE.
SSQ_OPTIMIZATION: If false, scalar subqueries will be translated into joins Supported values:
- TRUE
- FALSE
The default value is TRUE.
LATE_MATERIALIZATION: If true, Joins/Filters results will always be materialized ( saved to result tables format) Supported values:
- TRUE
- FALSE
The default value is FALSE.
TTL: Sets the TTL of the intermediate result tables used in query execution.
UPDATE_ON_EXISTING_PK: Can be used to customize behavior when the updated primary key value already exists as described in /insert/records. Supported values:
- TRUE
- FALSE
The default value is FALSE.
PRESERVE_DICT_ENCODING: If true, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:
- TRUE
- FALSE
The default value is TRUE.
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. Supported values:
- TRUE: true
- FALSE: false
The default value is TRUE.
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 Supported values:
- TRUE
- FALSE
The default value is FALSE.
VIEW_ID: <DEVELOPER> The default value is ''.
NO_COUNT: <DEVELOPER> The default value is 'false'.

The default value is an empty Dictionary.

Definition at line 959 of file ExecuteSql.cs.

string kinetica.ExecuteSqlRequest.request_schema_str = Encoding.BINARY

getset

Avro schema of .

The default value is ''.

Definition at line 653 of file ExecuteSql.cs.

string kinetica.ExecuteSqlRequest.statement

getset

SQL statement (query, DML, or DDL) to be executed

Definition at line 613 of file ExecuteSql.cs.

The documentation for this class was generated from the following file:

Kinetica/Protocol/ExecuteSql.cs

Classes

Public Member Functions

Properties

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

Property Documentation