Kinetica   C#   API  Version 7.2.3.0
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 
31  public const string DATASINK_NAME = "datasink_name";
32 
36  public const string JDBC_SESSION_INIT_STATEMENT = "jdbc_session_init_statement";
37 
41  public const string JDBC_CONNECTION_INIT_STATEMENT = "jdbc_connection_init_statement";
42 
47  public const string REMOTE_TABLE = "remote_table";
48 
62  public const string USE_ST_GEOMFROM_CASTS = "use_st_geomfrom_casts";
63 
64  public const string TRUE = "true";
65  public const string FALSE = "false";
66 
80  public const string USE_INDEXED_PARAMETERS = "use_indexed_parameters";
81  } // end struct Options
82 
87  public string table_name { get; set; }
88 
92  public string remote_query { get; set; } = "";
93 
171  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
172 
176 
266  string remote_query = null,
267  IDictionary<string, string> options = null)
268  {
269  this.table_name = table_name ?? "";
270  this.remote_query = remote_query ?? "";
271  this.options = options ?? new Dictionary<string, string>();
272  } // end constructor
273  } // end class ExportRecordsToTableRequest
274 
279  {
283  public string table_name { get; set; }
284 
287  public long count_inserted { get; set; }
288 
290  public long count_skipped { get; set; }
291 
294  public long count_updated { get; set; }
295 
297  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
298  } // end class ExportRecordsToTableResponse
299 } // end namespace kinetica
ExportRecordsToTableRequest(string table_name, string remote_query=null, IDictionary< string, string > options=null)
Constructs an ExportRecordsToTableRequest object with the specified parameters.
IDictionary< string, string > options
Optional parameters.
A set of results returned by Kinetica.exportRecordsToTable.
string table_name
Name of the table from which the data will be exported to remote database, in [schema_name.
const string USE_INDEXED_PARAMETERS
Uses $n style syntax when generating insert query for remote_table option.
A set of parameters for Kinetica.exportRecordsToTable.
const string JDBC_SESSION_INIT_STATEMENT
Executes the statement per each jdbc session before doing actual load.
const string DATASINK_NAME
Name of an existing external data sink to which table name specified in table_name will be exported
const string JDBC_CONNECTION_INIT_STATEMENT
Executes the statement once before doing actual load.
IDictionary< string, string > info
Additional information.
string remote_query
Parameterized insert query to export gpudb table data into remote database.
const string BATCH_SIZE
Batch size, which determines how many rows to export per round trip.
const string USE_ST_GEOMFROM_CASTS
Wraps parametrized variables with st_geomfromtext or st_geomfromwkb based on source column type.
long count_inserted
Number of records inserted into the target table.
long count_updated
[Not yet implemented] Number of records updated within the target table.
long count_skipped
Number of records skipped.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
ExportRecordsToTableRequest()
Constructs an ExportRecordsToTableRequest object with default parameters.
const string REMOTE_TABLE
Name of the target table to which source table is exported.
A set of string constants for the parameter options.