/// <summary>
/// Example with a record type with nullable columns, primary keys and shard keys.
/// </summary>
/// <param name="server_url">The URL for the Kinetica server.</param>
private static void run_example(string server_url)
{
// Establish a connection with Kinetica
Kinetica kdb = new Kinetica(server_url);
Console.WriteLine("Example with a Record Type with Nullable Columns, Primary Keys and Shard Keys");
Console.WriteLine("=============================================================================");
Console.WriteLine();
string table_name = "csharp_example_table";
// Create a type for our record_type_1 class
Console.WriteLine("Creating the type in kinetica...");
// Add some interesting properties for some of the data types
IDictionary <string, IList <string> > column_properties = new Dictionary <string, IList <string> >();
// Make a string char4 (and nullable)
List <string> D_props = new List <string>();
D_props.Add(ColumnProperty.CHAR4);
D_props.Add(ColumnProperty.NULLABLE);
column_properties.Add("D", D_props);
// Let's try another nullable column
List <string> E_props = new List <string>();
E_props.Add(ColumnProperty.NULLABLE);
column_properties.Add("E", E_props);
// And two primary keys (one nullable)
List <string> A_props = new List <string>();
A_props.Add(ColumnProperty.PRIMARY_KEY);
column_properties.Add("A", A_props);
List <string> B_props = new List <string>();
B_props.Add(ColumnProperty.PRIMARY_KEY);
column_properties.Add("B", B_props);
// And a shard key (must be one of the primary keys, if specified--which we have)
B_props.Add(ColumnProperty.SHARD_KEY);
// Create the KineticaType object which facilitates creating types in the database
KineticaType type1 = KineticaType.fromClass(typeof(record_type_1), column_properties);
// Create the type in the database
string type_id = type1.create(kdb);
Console.WriteLine("ID of the created type: " + type_id);
Console.WriteLine();
// Show the type information (fetched from Kinetica)
Console.WriteLine("Fetching the newly created type information...");
ShowTypesResponse rsp = kdb.showTypes(type_id, "");
Console.WriteLine("Type properties: ");
foreach (var x in rsp.properties[0])
{
Console.WriteLine(x.Key + ": " + String.Join(",", x.Value));
}
Console.WriteLine();
// Clear any previously made table with the same name
Console.WriteLine("Clearing any existing table named '{0}'", table_name);
try { kdb.clearTable(table_name, null); } catch (Exception ex) { /* I don't care if the table doesn't already exists! */ }
Console.WriteLine();
// Create a table of the given type
Console.WriteLine("Creating table named '{0}'", table_name);
kdb.createTable(table_name, type_id);
Console.WriteLine();
// Call /show/table on the table just created
Dictionary <string, string> show_table_options = new Dictionary <string, string>();
show_table_options.Add(ShowTableRequest.Options.GET_SIZES, ShowTableRequest.Options.TRUE);
Console.WriteLine("Calling ShowTable on '{0}'", table_name);
var response2 = kdb.showTable(table_name, show_table_options);
Console.WriteLine("Total size: {0}", response2.total_size);
Console.WriteLine("sizes: {0}", string.Join(", ", response2.sizes));
Console.WriteLine();
// Create some data to be added to the table
List <record_type_1> newData = new List <record_type_1>()
{
new record_type_1()
{
A = 99, B = 11, C = "T0_lksdjfokdj92", D = "D01", E = 2.34F, F = null, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_1()
{
A = 2, B = 3, C = "T1_asdfghjkl", D = null, E = 5.67F, F = null, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_1()
{
A = 99, B = 999, C = "T2_oierlwk", D = "D244", E = -45.1F, F = 9899.1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
}
};
// Insert the data into the table
Console.WriteLine("Inserting some data in '{0}'", table_name);
var insertResponse = kdb.insertRecords(table_name, newData);
Console.WriteLine("Inserted {0} records", insertResponse.count_inserted + insertResponse.count_updated);
Console.WriteLine();
// Call /show/table on the table after adding data
Console.WriteLine("Calling ShowTable on '{0}' after adding data", table_name);
var rsp2 = kdb.showTable(table_name, show_table_options);
Console.WriteLine("Total size: {0}", rsp2.total_size);
Console.WriteLine("sizes: {0}", string.Join(", ", rsp2.sizes));
Console.WriteLine();
// Fetch the data back out of the DB using /get/records
Console.WriteLine("Getting records out");
var getRecordsResponse = kdb.getRecords <record_type_1>(table_name, 0, 100);
Console.WriteLine("GetRecords got {0} records", getRecordsResponse.data.Count);
foreach (var r in getRecordsResponse.data)
{
Console.WriteLine("\t" + r.ToString());
}
Console.WriteLine();
// Do a filter operation
Console.WriteLine("Filtering data");
string view_name_1 = "csharp_view_01";
string filter_expression = "E > 0";
var filterResponse = kdb.filter(table_name, view_name_1, filter_expression);
Console.WriteLine("Filtered {0} records", filterResponse.count);
Console.WriteLine();
// Fetch the data from the filtered view using /get/records/fromcollection
Console.WriteLine("Getting records out (using /get/records/fromcollection) from view {0}", view_name_1);
IDictionary <string, string> getrecords_fc_options = new Dictionary <string, string>();
getrecords_fc_options.Add("return_record_ids", "true");
var request = new GetRecordsFromCollectionRequest(view_name_1, 0, 100, GetRecordsFromCollectionRequest.Encoding.BINARY, getrecords_fc_options);
var getRecordsFromCollectionResponse = kdb.getRecordsFromCollection <record_type_1>(request);
Console.WriteLine("GetRecordsFromCollection got {0} records", getRecordsFromCollectionResponse.data.Count);
foreach (var r in getRecordsFromCollectionResponse.data)
{
Console.WriteLine("\t" + r.ToString());
}
Console.WriteLine();
// Do an /aggregate/groupby operation on the data
Console.WriteLine("Performing a group-by aggregate operation");
IList <string> column_names = new List <string>();
column_names.Add("A");
column_names.Add("D");
var agbResponse = kdb.aggregateGroupBy(table_name, column_names, 0, 100);
Console.WriteLine("Group by got {0} records", agbResponse.total_number_of_records);
// Print the decoded data out to the console
((List <KineticaRecord>)(agbResponse.data)).ForEach(r => Console.WriteLine(r.ContentsToString()));
Console.WriteLine();
// Do an /aggregate/unique operation on column F
string col_name = "F";
Console.WriteLine($"Performing a unique aggregate operation on column {col_name}");
var uniqueResponse = kdb.aggregateUnique(table_name, col_name, 0, 100);
// Print the decoded data out to the console
((List <KineticaRecord>)(uniqueResponse.data)).ForEach(r => Console.WriteLine(r.ContentsToString()));
Console.WriteLine();
// Fetch the data back out of the DB using /get/records/bycolumn
Console.WriteLine("Getting records out (using /get/records/bycolumn)");
IList <string> col_names = new List <string>();
col_names.Add("B");
col_names.Add("C");
col_names.Add("E");
var getRecordsByColumnResponse = kdb.getRecordsByColumn(table_name, col_names, 0, 100);
Console.WriteLine("GetRecordsByColumn got {0} records", getRecordsByColumnResponse.data.Count);
foreach (var r in getRecordsByColumnResponse.data)
{
Console.WriteLine("\t" + r.ContentsToString());
}
Console.WriteLine();
Console.WriteLine();
} // end run_example
} // end run_example
/// <summary>
/// Example showcasing a record with a series type column.
/// </summary>
/// <param name="server_url">The URL for the Kinetica server.</param>
private static void run_series_example(string server_url)
{
// Establish a connection with Kinetica
Kinetica kdb = new Kinetica(server_url);
Console.WriteLine("Example showcasing a record with a series type column");
Console.WriteLine("======================================================");
Console.WriteLine();
// Create the series type record in Kinetica
KineticaType type_series = KineticaType.fromClass(typeof(record_type_series));
string series_type_id = type_series.create(kdb);
Console.WriteLine("ID of the created series type: " + series_type_id);
Console.WriteLine();
// Clear any previously made table with the same name
string table_name_series = "csharp_example_series_table";
Console.WriteLine("Clearing any existing table named '{0}'", table_name_series);
try { kdb.clearTable(table_name_series, null); } catch (Exception ex) { /* I don't care if the table doesn't already exists! */ }
Console.WriteLine();
// Create a table of the given type
Console.WriteLine("Creating table named '{0}'", table_name_series);
kdb.createTable(table_name_series, series_type_id);
Console.WriteLine();
// Create some data to be added to the table
string series_1 = "series_1";
string series_2 = "series_2";
List <record_type_series> series_data = new List <record_type_series>()
{
// Five series points moving horizontally
new record_type_series()
{
x = 30, y = 40, TRACKID = series_1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = 35, y = 40, TRACKID = series_1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = 40, y = 40, TRACKID = series_1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = 45, y = 40, TRACKID = series_1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = 50, y = 40, TRACKID = series_1, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
// Five series points moving vertically
new record_type_series()
{
x = -30, y = -40, TRACKID = series_2, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = -30, y = -45, TRACKID = series_2, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = -30, y = -50, TRACKID = series_2, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = -30, y = -55, TRACKID = series_2, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
new record_type_series()
{
x = -30, y = -60, TRACKID = series_2, TIMESTAMP = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalMilliseconds
},
};
// Insert the data into the table
Console.WriteLine("Inserting some data in '{0}'", table_name_series);
var insertResponse2 = kdb.insertRecords(table_name_series, series_data);
Console.WriteLine("Inserted {0} records", insertResponse2.count_inserted + insertResponse2.count_updated);
Console.WriteLine();
// Fetch the data back out of the DB using /get/records
Console.WriteLine("Getting records out from {0}", table_name_series);
var getRecordsResponse2 = kdb.getRecords <record_type_series>(table_name_series);
Console.WriteLine("GetRecords got {0} records", getRecordsResponse2.data.Count);
foreach (var r in getRecordsResponse2.data)
{
Console.WriteLine("\t" + r.ToString());
}
Console.WriteLine();
// Filter the series data such that only a few series point from only one of the series
// are in the view
Console.WriteLine("Filtering data from {0} so that only some points from {1} to make it", table_name_series, series_1);
string view_name_2 = "csharp_view_02";
// Only the first, second, and third records from the first series should survive this filter
// (for track/series type records, we're filtering the "line segments", so records just outside the
// filtered box will also be captured)
var filterByBoxResp = kdb.filterByBox(table_name_series, view_name_2, "x", 33, 37, "y", 35, 45);
Console.WriteLine("Filtered {0} records", filterByBoxResp.count);
Console.WriteLine();
// Show the filtered objects
var getRecordsResponse3 = kdb.getRecords <record_type_series>(view_name_2);
Console.WriteLine("GetRecords got {0} records from {1}", getRecordsResponse3.data.Count, view_name_2);
foreach (var r in getRecordsResponse3.data)
{
Console.WriteLine("\t" + r.ToString());
}
Console.WriteLine();
// Extract the entire series from the source table (based on which ones are in the view)
Console.WriteLine("Getting records belonging to one series out from table '{0}' using the partial series in view '{1}'", table_name_series, view_name_2);
var getRecordsBySeriesResp = kdb.getRecordsBySeries <record_type_series>(view_name_2, table_name_series);
Console.WriteLine("GetRecordsBySeries got {0} list of records (should get one list of five records in it)", getRecordsBySeriesResp.data.Count);
foreach (var r_list in getRecordsBySeriesResp.data)
{
foreach (var r in r_list)
{
Console.WriteLine("\t" + r.ToString());
}
}
Console.WriteLine();
Console.WriteLine();
} // end run_series_example()
} // end run_series_example()
/// <summary>
/// Shows an example of how to use the multi-head ingestion feature
/// of Kinetica.
/// </summary>
/// <param name="server_url">The URL for the Kinetica server.</param>
private static void run_multihead_ingest_example(string server_url)
{
// Establish a connection with Kinetica
Kinetica kdb = new Kinetica(server_url);
Console.WriteLine("\n\n");
Console.WriteLine("Example showcasing multihead ingestion(one shard key, two primary keys)");
Console.WriteLine("=======================================================================");
Console.WriteLine();
// Create a type for our record_type_1 class
// Add some interesting properties for some of the data types
IDictionary <string, IList <string> > column_properties = new Dictionary <string, IList <string> >();
// Add a primary key
List <string> A_props = new List <string>();
A_props.Add(ColumnProperty.PRIMARY_KEY);
column_properties.Add("A", A_props);
// And a shard key (must be part of the primary keys, if specified--which we have)
List <string> ts_props = new List <string>();
ts_props.Add(ColumnProperty.PRIMARY_KEY);
ts_props.Add(ColumnProperty.SHARD_KEY);
ts_props.Add(ColumnProperty.TIMESTAMP);
column_properties.Add("TIMESTAMP", ts_props);
// Create the KineticaType object which facilitates creating types in the database
KineticaType type1 = KineticaType.fromClass(typeof(record_type_1), column_properties);
// Create the type in the database
string type_id = type1.create(kdb);
string table_name = "csharp_example_table_01";
// Clear any previously made table with the same name
Console.WriteLine("Clearing any existing table named '{0}'", table_name);
try { kdb.clearTable(table_name, null); } catch (Exception ex) { /* I don't care if the table doesn't already exists! */ }
Console.WriteLine();
// Create a table of the given type
Console.WriteLine($"Creating table named '{table_name}'");
kdb.createTable(table_name, type_id);
Console.WriteLine();
// Create the ingestor (we're not giving any worker IP addresses; the ingestor class will figure it
// out by itself)
int batch_size = 100;
KineticaIngestor <record_type_1> ingestor = new KineticaIngestor <record_type_1>(kdb, table_name, batch_size, type1);
// Generate data to be inserted
int num_records = batch_size * 5;
List <record_type_1> records = new List <record_type_1>();
Random rng = new Random();
double null_probability = 0.2;
for (int i = 0; i < num_records; ++i)
{
// Restricting string length to 256
int max_str_len = rng.Next(0, 256);
record_type_1 record = new record_type_1()
{
A = rng.Next(),
B = rng.Next(),
C = System.IO.Path.GetRandomFileName().Truncate(max_str_len),
D = System.IO.Path.GetRandomFileName().Truncate(max_str_len),
E = (float)(rng.NextDouble() * rng.Next()),
F = (rng.NextDouble() < null_probability) ? null : ( double? )(rng.NextDouble() * rng.Next()),
TIMESTAMP = (long)rng.Next(-306102240, 293795424) * rng.Next(100000)
};
records.Add(record);
} // end for loop
Console.WriteLine($"Generated {num_records} records.");
// Insert the records into the ingestor
Console.WriteLine($"Inserting {num_records} records...");
ingestor.insert(records);
// Flush the ingestor (which actually inserts the records)
Console.WriteLine("\nFlushing any remaining records.");
ingestor.flush();
Console.WriteLine();
Console.WriteLine();
} // end run_multihead_ingest_example()
public RecordKeyBuilder(bool is_primary_key, KineticaType ktype)
{
this.ktype = ktype;
this.buffer_size = 0;
routing_column_indices = new List <int>();
column_types = new List <ColumnType>();
// We need to check if the type has all of the following: x, y, timestamp, track ID
// (this will tell us if it's a track type table, and if so, the track ID
// column would be a routing column)
bool has_timestamp = false;
bool has_x = false;
bool has_y = false;
int track_id_column_idx = -1; // not found yet
// Add indices of any primary or shard key (based on is_primary_key)
// to the list of routing columns
IList <KineticaType.Column> columns = ktype.getColumns();
for (int i = 0; i < columns.Count; ++i)
{
// Get the column
KineticaType.Column column = columns[i];
// Check if it is one of: x, y, timestamp, track ID
switch (column.getName())
{
case "TRACKID":
track_id_column_idx = i;
break;
case "TIMESTAMP":
has_timestamp = true;
break;
case "x":
has_x = true;
break;
case "y":
has_y = true;
break;
} // end switch on column name
// Check if this column has been declared as a primary/shard key
// And if so, and if appropriate, add it to the routing key column list
if (is_primary_key && column.getProperties().Contains(ColumnProperty.PRIMARY_KEY))
{
routing_column_indices.Add(i);
}
else if (!is_primary_key && column.getProperties().Contains(ColumnProperty.SHARD_KEY))
{
routing_column_indices.Add(i);
}
} // end for loop
// Check if this is a track-type table; if so, add the track ID column's index to the list
if (!is_primary_key &&
has_timestamp && has_x && has_y && (track_id_column_idx != -1))
{
if (routing_column_indices.Count == 0)
{
routing_column_indices.Add(track_id_column_idx);
}
else if ((routing_column_indices.Count != 1) ||
(routing_column_indices[0] != track_id_column_idx))
{
// Track type tables can't have any other routing key
throw new KineticaException("Cannot have a shard key other than 'TRACKID' for track tables.");
}
} // end if a track type table
// For each index of routing columns, save the column type, and increase
// the buffer size appropriately
foreach (int i in routing_column_indices)
{
// Get the column information
KineticaType.Column column = columns[i];
switch (column.getType())
{
// Float and double are the simplest
case KineticaType.Column.ColumnType.FLOAT:
{
column_types.Add(ColumnType.FLOAT);
this.buffer_size += 4;
break;
}
case KineticaType.Column.ColumnType.DOUBLE:
{
column_types.Add(ColumnType.DOUBLE);
this.buffer_size += 8;
break;
}
case KineticaType.Column.ColumnType.INT:
{
// Integer has byte, short and int
if (column.getProperties().Contains(ColumnProperty.INT8))
{ // byte
column_types.Add(ColumnType.INT8);
this.buffer_size += 1;
}
else if (column.getProperties().Contains(ColumnProperty.INT16))
{ // short
column_types.Add(ColumnType.INT16);
this.buffer_size += 2;
}
else // regular 4-byte integer
{
column_types.Add(ColumnType.INT);
this.buffer_size += 4;
}
break;
} // end case integer
case KineticaType.Column.ColumnType.LONG:
{
// Long has the regular long and timestamp
if (column.getProperties().Contains(ColumnProperty.TIMESTAMP))
{ // it's a timestamp
column_types.Add(ColumnType.TIMESTAMP);
}
else // regular long
{
column_types.Add(ColumnType.LONG);
}
this.buffer_size += 8;
break;
} // end case long
case KineticaType.Column.ColumnType.STRING:
{
if (column.getProperties().Contains(ColumnProperty.CHAR1))
{
column_types.Add(ColumnType.CHAR1);
this.buffer_size += 1;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR2))
{
column_types.Add(ColumnType.CHAR2);
this.buffer_size += 2;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR4))
{
column_types.Add(ColumnType.CHAR4);
this.buffer_size += 4;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR8))
{
column_types.Add(ColumnType.CHAR8);
this.buffer_size += 8;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR16))
{
column_types.Add(ColumnType.CHAR16);
this.buffer_size += 16;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR32))
{
column_types.Add(ColumnType.CHAR32);
this.buffer_size += 32;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR64))
{
column_types.Add(ColumnType.CHAR64);
this.buffer_size += 64;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR128))
{
column_types.Add(ColumnType.CHAR128);
this.buffer_size += 128;
}
else if (column.getProperties().Contains(ColumnProperty.CHAR256))
{
column_types.Add(ColumnType.CHAR256);
this.buffer_size += 256;
}
else if (column.getProperties().Contains(ColumnProperty.DATE))
{
column_types.Add(ColumnType.DATE);
this.buffer_size += 4;
}
else if (column.getProperties().Contains(ColumnProperty.DATETIME))
{
column_types.Add(ColumnType.DATETIME);
this.buffer_size += 8;
}
else if (column.getProperties().Contains(ColumnProperty.DECIMAL))
{
column_types.Add(ColumnType.DECIMAL);
this.buffer_size += 8;
}
else if (column.getProperties().Contains(ColumnProperty.IPV4))
{
column_types.Add(ColumnType.IPV4);
this.buffer_size += 4;
}
else if (column.getProperties().Contains(ColumnProperty.TIME))
{
column_types.Add(ColumnType.TIME);
this.buffer_size += 4;
}
else // regular string
{
column_types.Add(ColumnType.STRING);
this.buffer_size += 8;
}
break;
} // end case string
// Other types are not allowed for routing columns
case KineticaType.Column.ColumnType.BYTES:
case KineticaType.Column.ColumnType.DEFAULT:
throw new KineticaException($"Cannot use column '{column.getName()}' as a key.");
} // end switch on the column's primitive data type
} // end foreach
} // end constructor RecordKeyBuilder
