Kinetica   C#   API  Version 7.2.3.1
ExportRecordsToTable.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 using System.Collections.Generic;
8 
9 namespace kinetica;
10 
17 {
21  public struct Options
22  {
26  public const string BATCH_SIZE = "batch_size";
27 
30  public const string DATASINK_NAME = "datasink_name";
31 
35  public const string JDBC_SESSION_INIT_STATEMENT = "jdbc_session_init_statement";
36 
40  public const string JDBC_CONNECTION_INIT_STATEMENT = "jdbc_connection_init_statement";
41 
46  public const string REMOTE_TABLE = "remote_table";
47 
61  public const string USE_ST_GEOMFROM_CASTS = "use_st_geomfrom_casts";
62 
63  public const string TRUE = "true";
64  public const string FALSE = "false";
65 
79  public const string USE_INDEXED_PARAMETERS = "use_indexed_parameters";
80  } // end struct Options
81 
86  public string table_name { get; set; }
87 
91  public string remote_query { get; set; } = "";
92 
168  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
169 
173 
259  string remote_query = null,
260  IDictionary<string, string> options = null)
261  {
262  this.table_name = table_name ?? "";
263  this.remote_query = remote_query ?? "";
264  this.options = options ?? new Dictionary<string, string>();
265  } // end constructor
266 } // end class ExportRecordsToTableRequest
267 
272 {
276  public string table_name { get; set; }
277 
279  public long count_inserted { get; set; }
280 
282  public long count_skipped { get; set; }
283 
286  public long count_updated { get; set; }
287 
289  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
290 } // end class ExportRecordsToTableResponse
const string USE_INDEXED_PARAMETERS
Uses $n style syntax when generating insert query for remote_table option.
long count_inserted
Number of records inserted into the target table.
string table_name
Name of the table from which the data will be exported to remote database, in [schema_name.
const string REMOTE_TABLE
Name of the target table to which source table is exported.
IDictionary< string, string > options
Optional parameters.
const string JDBC_CONNECTION_INIT_STATEMENT
Executes the statement once before doing actual load.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string USE_ST_GEOMFROM_CASTS
Wraps parameterized variables with st_geomfromtext or st_geomfromwkb based on source column type.
const string JDBC_SESSION_INIT_STATEMENT
Executes the statement per each JDBC session before doing actual load.
IDictionary< string, string > info
Additional information.
long count_updated
[Not yet implemented] Number of records updated within the target table.
const string BATCH_SIZE
Batch size, which determines how many rows to export per round trip.
A set of string constants for the parameter options.
A set of results returned by Kinetica.exportRecordsToTable.
string table_name
Value of table_name.
ExportRecordsToTableRequest(string table_name, string remote_query=null, IDictionary< string, string > options=null)
Constructs an ExportRecordsToTableRequest object with the specified parameters.
A set of parameters for Kinetica.exportRecordsToTable.
string remote_query
Parameterized insert query to export gpudb table data into remote database.
long count_skipped
Number of records skipped.
const string DATASINK_NAME
Name of an existing external data sink to which table name specified in table_name will be exported.
ExportRecordsToTableRequest()
Constructs an ExportRecordsToTableRequest object with default parameters.