9 using System.Collections.Generic;
15 public partial class Kinetica
60 AdminAddRanksResponse actualResponse_ = SubmitRequest<AdminAddRanksResponse>(
"/admin/add/ranks", request_,
false);
62 return actualResponse_;
138 IList<IDictionary<string, string>> config_params,
139 IDictionary<string, string> options = null )
161 AdminAlterJobsResponse actualResponse_ = SubmitRequest<AdminAlterJobsResponse>(
"/admin/alter/jobs", request_,
false);
163 return actualResponse_;
193 IDictionary<string, string> options = null )
211 AdminOfflineResponse actualResponse_ = SubmitRequest<AdminOfflineResponse>(
"/admin/offline", request_,
false);
213 return actualResponse_;
258 IDictionary<string, string> options = null )
283 AdminRebalanceResponse actualResponse_ = SubmitRequest<AdminRebalanceResponse>(
"/admin/rebalance", request_,
false);
285 return actualResponse_;
470 AdminRemoveRanksResponse actualResponse_ = SubmitRequest<AdminRemoveRanksResponse>(
"/admin/remove/ranks", request_,
false);
472 return actualResponse_;
553 IDictionary<string, string> options = null )
571 AdminShowAlertsResponse actualResponse_ = SubmitRequest<AdminShowAlertsResponse>(
"/admin/show/alerts", request_,
false);
573 return actualResponse_;
593 IDictionary<string, string> options = null )
617 return actualResponse_;
639 IDictionary<string, string> options = null )
657 AdminShowJobsResponse actualResponse_ = SubmitRequest<AdminShowJobsResponse>(
"/admin/show/jobs", request_,
false);
659 return actualResponse_;
712 AdminShowShardsResponse actualResponse_ = SubmitRequest<AdminShowShardsResponse>(
"/admin/show/shards", request_,
false);
714 return actualResponse_;
745 AdminShutdownResponse actualResponse_ = SubmitRequest<AdminShutdownResponse>(
"/admin/shutdown", request_,
false);
747 return actualResponse_;
764 string authorization,
765 IDictionary<string, string> options = null )
785 AdminVerifyDbResponse actualResponse_ = SubmitRequest<AdminVerifyDbResponse>(
"/admin/verifydb", request_,
false);
787 return actualResponse_;
916 AggregateConvexHullResponse actualResponse_ = SubmitRequest<AggregateConvexHullResponse>(
"/aggregate/convexhull", request_,
false);
918 return actualResponse_;
941 string x_column_name,
942 string y_column_name,
943 IDictionary<string, string> options = null )
1040 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1041 response_.total_number_of_records = actualResponse_.total_number_of_records;
1042 response_.has_more_records = actualResponse_.has_more_records;
1043 response_.info = actualResponse_.info;
1379 IList<string> column_names,
1382 IDictionary<string, string> options = null )
1385 column_names, offset,
1415 AggregateHistogramResponse actualResponse_ = SubmitRequest<AggregateHistogramResponse>(
"/aggregate/histogram", request_,
false);
1417 return actualResponse_;
1469 IDictionary<string, string> options = null )
1500 AggregateKMeansResponse actualResponse_ = SubmitRequest<AggregateKMeansResponse>(
"/aggregate/kmeans", request_,
false);
1502 return actualResponse_;
1559 IList<string> column_names,
1562 IDictionary<string, string> options = null )
1565 k, tolerance, options ) );
1580 AggregateMinMaxResponse actualResponse_ = SubmitRequest<AggregateMinMaxResponse>(
"/aggregate/minmax", request_,
false);
1582 return actualResponse_;
1601 IDictionary<string, string> options = null )
1622 return actualResponse_;
1642 IDictionary<string, string> options = null )
1705 AggregateStatisticsResponse actualResponse_ = SubmitRequest<AggregateStatisticsResponse>(
"/aggregate/statistics", request_,
false);
1707 return actualResponse_;
1878 IDictionary<string, string> options = null )
1926 return actualResponse_;
2012 string select_expression,
2014 string value_column_name,
2019 IDictionary<string, string> options = null )
2086 RawAggregateUniqueResponse actualResponse_ = SubmitRequest<RawAggregateUniqueResponse>(
"/aggregate/unique", request_,
false);
2089 response_.table_name = actualResponse_.table_name;
2090 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
2091 response_.has_more_records = actualResponse_.has_more_records;
2092 response_.info = actualResponse_.info;
2295 IDictionary<string, string> options = null )
2298 offset, limit, options ) );
2332 response_.table_name = actualResponse_.table_name;
2333 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
2334 response_.total_number_of_records = actualResponse_.total_number_of_records;
2335 response_.has_more_records = actualResponse_.has_more_records;
2336 response_.info = actualResponse_.info;
2513 IList<string> column_names,
2514 string variable_column_name,
2515 string value_column_name,
2516 IList<string> pivoted_columns,
2517 IDictionary<string, string> options = null )
2521 variable_column_name,
2523 pivoted_columns, options ) );
2538 AlterResourceGroupResponse actualResponse_ = SubmitRequest<AlterResourceGroupResponse>(
"/alter/resourcegroup", request_,
false);
2540 return actualResponse_;
2651 IDictionary<
string, IDictionary<string, string>> tier_attributes = null,
2653 string adjoining_resource_group =
"",
2654 IDictionary<string, string> options = null )
2659 adjoining_resource_group,
2674 AlterRoleResponse actualResponse_ = SubmitRequest<AlterRoleResponse>(
"/alter/role", request_,
false);
2676 return actualResponse_;
2707 IDictionary<string, string> options = null )
2733 return actualResponse_;
2954 IDictionary<string, string> options = null )
2957 property_updates_map,
3030 AlterTableResponse actualResponse_ = SubmitRequest<AlterTableResponse>(
"/alter/table", request_,
false);
3032 return actualResponse_;
3522 IDictionary<string, string> options = null )
3557 AlterTableColumnsResponse actualResponse_ = SubmitRequest<AlterTableColumnsResponse>(
"/alter/table/columns", request_,
false);
3559 return actualResponse_;
3603 IList<IDictionary<string, string>> column_alterations,
3604 IDictionary<string, string> options )
3626 AlterTableMetadataResponse actualResponse_ = SubmitRequest<AlterTableMetadataResponse>(
"/alter/table/metadata", request_,
false);
3628 return actualResponse_;
3653 IDictionary<string, string> metadata_map,
3654 IDictionary<string, string> options = null )
3680 AlterTierResponse actualResponse_ = SubmitRequest<AlterTierResponse>(
"/alter/tier", request_,
false);
3682 return actualResponse_;
3727 IDictionary<string, string> options = null )
3743 AlterUserResponse actualResponse_ = SubmitRequest<AlterUserResponse>(
"/alter/user", request_,
false);
3745 return actualResponse_;
3782 IDictionary<string, string> options = null )
3805 AppendRecordsResponse actualResponse_ = SubmitRequest<AppendRecordsResponse>(
"/append/records", request_,
false);
3807 return actualResponse_;
3927 string source_table_name,
3928 IDictionary<string, string> field_map,
3929 IDictionary<string, string> options = null )
3932 field_map, options ) );
3947 ClearStatisticsResponse actualResponse_ = SubmitRequest<ClearStatisticsResponse>(
"/clear/statistics", request_,
false);
3949 return actualResponse_;
3970 string column_name =
"",
3971 IDictionary<string, string> options = null )
3992 ClearTableResponse actualResponse_ = SubmitRequest<ClearTableResponse>(
"/clear/table", request_,
false);
3994 return actualResponse_;
4041 string authorization =
"",
4042 IDictionary<string, string> options = null )
4060 ClearTableMonitorResponse actualResponse_ = SubmitRequest<ClearTableMonitorResponse>(
"/clear/tablemonitor", request_,
false);
4062 return actualResponse_;
4079 IDictionary<string, string> options = null )
4098 ClearTriggerResponse actualResponse_ = SubmitRequest<ClearTriggerResponse>(
"/clear/trigger", request_,
false);
4100 return actualResponse_;
4118 IDictionary<string, string> options = null )
4135 CollectStatisticsResponse actualResponse_ = SubmitRequest<CollectStatisticsResponse>(
"/collect/statistics", request_,
false);
4137 return actualResponse_;
4156 IList<string> column_names,
4157 IDictionary<string, string> options = null )
4160 column_names, options ) );
4171 public CreateExternalTableResponse createExternalTable( CreateExternalTableRequest request_ )
4173 CreateExternalTableResponse actualResponse_ = SubmitRequest<CreateExternalTableResponse>(
"/create/externaltable", request_,
false);
4175 return actualResponse_;
4408 public CreateExternalTableResponse createExternalTable(
string table_name,
4409 IList<string> filepaths,
4410 IDictionary<string, string> create_table_options = null,
4411 IDictionary<string, string> options = null )
4413 return createExternalTable(
new CreateExternalTableRequest( table_name,
4415 create_table_options,
4443 CreateGraphResponse actualResponse_ = SubmitRequest<CreateGraphResponse>(
"/create/graph", request_,
false);
4445 return actualResponse_;
4813 bool directed_graph,
4814 IList<string> nodes,
4815 IList<string> edges,
4816 IList<string> weights,
4817 IList<string> restrictions,
4818 IDictionary<string, string> options = null )
4821 edges, weights, restrictions,
4841 CreateJobResponse actualResponse_ = SubmitRequest<CreateJobResponse>(
"/create/job", request_,
false);
4843 return actualResponse_;
4899 string request_encoding,
4902 IDictionary<string, string> options = null )
4905 data_str, options ) );
4925 CreateJoinTableResponse actualResponse_ = SubmitRequest<CreateJoinTableResponse>(
"/create/jointable", request_,
false);
4927 return actualResponse_;
5029 IList<string> table_names,
5030 IList<string> column_names,
5031 IList<string> expressions = null,
5032 IDictionary<string, string> options = null )
5035 table_names, column_names,
5036 expressions, options ) );
5063 return actualResponse_;
5180 IDictionary<string, string> options = null )
5201 CreateProcResponse actualResponse_ = SubmitRequest<CreateProcResponse>(
"/create/proc", request_,
false);
5203 return actualResponse_;
5277 IDictionary<
string, byte[]> files = null,
5278 string command =
"",
5279 IList<string> args = null,
5280 IDictionary<string, string> options = null )
5283 command, args, options ) );
5329 CreateProjectionResponse actualResponse_ = SubmitRequest<CreateProjectionResponse>(
"/create/projection", request_,
false);
5331 return actualResponse_;
5565 string projection_name,
5566 IList<string> column_names,
5567 IDictionary<string, string> options = null )
5571 column_names, options ) );
5586 CreateResourceGroupResponse actualResponse_ = SubmitRequest<CreateResourceGroupResponse>(
"/create/resourcegroup", request_,
false);
5588 return actualResponse_;
5670 IDictionary<
string, IDictionary<string, string>> tier_attributes,
5672 string adjoining_resource_group =
"",
5673 IDictionary<string, string> options = null )
5678 adjoining_resource_group,
5693 CreateRoleResponse actualResponse_ = SubmitRequest<CreateRoleResponse>(
"/create/role", request_,
false);
5695 return actualResponse_;
5720 IDictionary<string, string> options = null )
5762 CreateTableResponse actualResponse_ = SubmitRequest<CreateTableResponse>(
"/create/table", request_,
false);
5764 return actualResponse_;
6057 IDictionary<string, string> options = null )
6098 CreateTableMonitorResponse actualResponse_ = SubmitRequest<CreateTableMonitorResponse>(
"/create/tablemonitor", request_,
false);
6100 return actualResponse_;
6173 IDictionary<string, string> options = null )
6207 CreateTriggerByAreaResponse actualResponse_ = SubmitRequest<CreateTriggerByAreaResponse>(
"/create/trigger/byarea", request_,
false);
6209 return actualResponse_;
6258 IList<string> table_names,
6259 string x_column_name,
6260 IList<double> x_vector,
6261 string y_column_name,
6262 IList<double> y_vector,
6263 IDictionary<string, string> options = null )
6270 y_vector, options ) );
6298 CreateTriggerByRangeResponse actualResponse_ = SubmitRequest<CreateTriggerByRangeResponse>(
"/create/trigger/byrange", request_,
false);
6300 return actualResponse_;
6338 IList<string> table_names,
6342 IDictionary<string, string> options = null )
6402 CreateTypeResponse actualResponse_ = SubmitRequest<CreateTypeResponse>(
"/create/type", request_,
false);
6404 SetDecoderIfMissing( actualResponse_.
type_id,
6405 actualResponse_.
label,
6408 return actualResponse_;
6707 IDictionary<
string, IList<string>> properties = null,
6708 IDictionary<string, string> options = null )
6757 CreateUnionResponse actualResponse_ = SubmitRequest<CreateUnionResponse>(
"/create/union", request_,
false);
6759 return actualResponse_;
6988 IList<string> table_names,
6989 IList<IList<string>> input_column_names,
6990 IList<string> output_column_names,
6991 IDictionary<string, string> options = null )
6995 output_column_names, options ) );
7010 CreateUserExternalResponse actualResponse_ = SubmitRequest<CreateUserExternalResponse>(
"/create/user/external", request_,
false);
7012 return actualResponse_;
7029 IDictionary<string, string> options = null )
7046 CreateUserInternalResponse actualResponse_ = SubmitRequest<CreateUserInternalResponse>(
"/create/user/internal", request_,
false);
7048 return actualResponse_;
7077 IDictionary<string, string> options = null )
7095 DeleteGraphResponse actualResponse_ = SubmitRequest<DeleteGraphResponse>(
"/delete/graph", request_,
false);
7097 return actualResponse_;
7136 IDictionary<string, string> options = null )
7153 DeleteProcResponse actualResponse_ = SubmitRequest<DeleteProcResponse>(
"/delete/proc", request_,
false);
7155 return actualResponse_;
7171 IDictionary<string, string> options = null )
7196 DeleteRecordsResponse actualResponse_ = SubmitRequest<DeleteRecordsResponse>(
"/delete/records", request_,
false);
7198 return actualResponse_;
7270 IList<string> expressions,
7271 IDictionary<string, string> options = null )
7288 DeleteResourceGroupResponse actualResponse_ = SubmitRequest<DeleteResourceGroupResponse>(
"/delete/resourcegroup", request_,
false);
7290 return actualResponse_;
7305 IDictionary<string, string> options = null )
7321 DeleteRoleResponse actualResponse_ = SubmitRequest<DeleteRoleResponse>(
"/delete/role", request_,
false);
7323 return actualResponse_;
7338 IDictionary<string, string> options = null )
7354 DeleteUserResponse actualResponse_ = SubmitRequest<DeleteUserResponse>(
"/delete/user", request_,
false);
7356 return actualResponse_;
7371 IDictionary<string, string> options = null )
7388 ExecuteProcResponse actualResponse_ = SubmitRequest<ExecuteProcResponse>(
"/execute/proc", request_,
false);
7390 return actualResponse_;
7482 IDictionary<string, string> _params = null,
7483 IDictionary<
string, byte[]> bin_params = null,
7484 IList<string> input_table_names = null,
7485 IDictionary<
string, IList<string>> input_column_names = null,
7486 IList<string> output_table_names = null,
7487 IDictionary<string, string> options = null )
7492 output_table_names, options ) );
7506 RawExecuteSqlResponse actualResponse_ = SubmitRequest<RawExecuteSqlResponse>(
"/execute/sql", request_,
false);
7509 response_.count_affected = actualResponse_.count_affected;
7510 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
7511 response_.total_number_of_records = actualResponse_.total_number_of_records;
7512 response_.has_more_records = actualResponse_.has_more_records;
7513 response_.paging_table = actualResponse_.paging_table;
7514 response_.info = actualResponse_.info;
7850 string request_schema_str =
"",
7851 IList<byte[]> data = null,
7852 IDictionary<string, string> options = null )
7855 request_schema_str, data, options ) );
7879 FilterResponse actualResponse_ = SubmitRequest<FilterResponse>(
"/filter", request_,
false);
7881 return actualResponse_;
7943 IDictionary<string, string> options = null )
7966 FilterByAreaResponse actualResponse_ = SubmitRequest<FilterByAreaResponse>(
"/filter/byarea", request_,
false);
7968 return actualResponse_;
8017 string x_column_name,
8018 IList<double> x_vector,
8019 string y_column_name,
8020 IList<double> y_vector,
8021 IDictionary<string, string> options = null )
8024 x_column_name, x_vector,
8025 y_column_name, y_vector, options ) );
8047 FilterByAreaGeometryResponse actualResponse_ = SubmitRequest<FilterByAreaGeometryResponse>(
"/filter/byarea/geometry", request_,
false);
8049 return actualResponse_;
8096 IList<double> x_vector,
8097 IList<double> y_vector,
8098 IDictionary<string, string> options = null )
8126 FilterByBoxResponse actualResponse_ = SubmitRequest<FilterByBoxResponse>(
"/filter/bybox", request_,
false);
8128 return actualResponse_;
8181 string x_column_name,
8184 string y_column_name,
8187 IDictionary<string, string> options = null )
8190 x_column_name, min_x, max_x,
8191 y_column_name, min_y, max_y,
8213 FilterByBoxGeometryResponse actualResponse_ = SubmitRequest<FilterByBoxGeometryResponse>(
"/filter/bybox/geometry", request_,
false);
8215 return actualResponse_;
8272 IDictionary<string, string> options = null )
8296 FilterByGeometryResponse actualResponse_ = SubmitRequest<FilterByGeometryResponse>(
"/filter/bygeometry", request_,
false);
8298 return actualResponse_;
8395 IDictionary<string, string> options = null )
8398 column_name, input_wkt,
8399 operation, options ) );
8429 FilterByListResponse actualResponse_ = SubmitRequest<FilterByListResponse>(
"/filter/bylist", request_,
false);
8431 return actualResponse_;
8505 IDictionary<
string, IList<string>> column_values_map,
8506 IDictionary<string, string> options = null )
8509 column_values_map, options ) );
8535 FilterByRadiusResponse actualResponse_ = SubmitRequest<FilterByRadiusResponse>(
"/filter/byradius", request_,
false);
8537 return actualResponse_;
8594 string x_column_name,
8596 string y_column_name,
8599 IDictionary<string, string> options = null )
8602 x_column_name, x_center,
8603 y_column_name, y_center,
8604 radius, options ) );
8628 return actualResponse_;
8682 IDictionary<string, string> options = null )
8717 FilterByRangeResponse actualResponse_ = SubmitRequest<FilterByRangeResponse>(
"/filter/byrange", request_,
false);
8719 return actualResponse_;
8771 IDictionary<string, string> options = null )
8774 column_name, lower_bound,
8775 upper_bound, options ) );
8803 FilterBySeriesResponse actualResponse_ = SubmitRequest<FilterBySeriesResponse>(
"/filter/byseries", request_,
false);
8805 return actualResponse_;
8893 IList<string> target_track_ids,
8894 IDictionary<string, string> options = null )
8897 track_id, target_track_ids,
8917 FilterByStringResponse actualResponse_ = SubmitRequest<FilterByStringResponse>(
"/filter/bystring", request_,
false);
8919 return actualResponse_;
9021 IList<string> column_names,
9022 IDictionary<string, string> options = null )
9026 column_names, options ) );
9050 FilterByTableResponse actualResponse_ = SubmitRequest<FilterByTableResponse>(
"/filter/bytable", request_,
false);
9052 return actualResponse_;
9199 string source_table_name,
9200 string source_table_column_name,
9201 IDictionary<string, string> options = null )
9206 source_table_column_name,
9231 FilterByValueResponse actualResponse_ = SubmitRequest<FilterByValueResponse>(
"/filter/byvalue", request_,
false);
9233 return actualResponse_;
9285 IDictionary<string, string> options = null )
9288 is_string, _value, value_str,
9289 column_name, options ) );
9308 GetJobResponse actualResponse_ = SubmitRequest<GetJobResponse>(
"/get/job", request_,
false);
9310 return actualResponse_;
9330 IDictionary<string, string> options = null )
9360 RawGetRecordsResponse actualResponse_ = SubmitRequest<RawGetRecordsResponse>(
"/get/records", request_,
false);
9363 response_.table_name = actualResponse_.table_name;
9364 response_.type_name = actualResponse_.type_name;
9365 response_.type_schema = actualResponse_.type_schema;
9366 response_.data =
new List<T>();
9367 this.DecodeRawBinaryDataUsingSchemaString<T>( response_.type_schema, actualResponse_.records_binary, response_.data );
9368 response_.total_number_of_records = actualResponse_.total_number_of_records;
9369 response_.has_more_records = actualResponse_.has_more_records;
9370 response_.info = actualResponse_.info;
9473 IDictionary<string, string> options = null ) where T :
new()
9524 response_.table_name = actualResponse_.table_name;
9525 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
9526 response_.total_number_of_records = actualResponse_.total_number_of_records;
9527 response_.has_more_records = actualResponse_.has_more_records;
9528 response_.info = actualResponse_.info;
9657 IList<string> column_names,
9660 IDictionary<string, string> options = null )
9700 response_.table_names = actualResponse_.table_names;
9701 response_.type_names = actualResponse_.type_names;
9702 response_.type_schemas = actualResponse_.type_schemas;
9703 response_.data =
new List<IList<T>>();
9704 this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.list_records_binary, response_.data );
9705 response_.info = actualResponse_.info;
9751 string world_table_name,
9754 IDictionary<string, string> options = null ) where T :
new()
9789 response_.table_name = actualResponse_.table_name;
9790 response_.type_names = actualResponse_.type_names;
9791 response_.data =
new List<T>();
9792 this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.records_binary, response_.data );
9793 response_.record_ids = actualResponse_.record_ids;
9794 response_.info = actualResponse_.info;
9860 IDictionary<string, string> options = null ) where T :
new()
9877 public GetVectortileResponse getVectortile( GetVectortileRequest request_ )
9879 GetVectortileResponse actualResponse_ = SubmitRequest<GetVectortileResponse>(
"/get/vectortile", request_,
false);
9881 return actualResponse_;
9898 public GetVectortileResponse getVectortile( IList<string> table_names,
9899 IList<string> column_names,
9900 IDictionary<
string, IList<string>> layers,
9904 IDictionary<string, string> options = null )
9906 return getVectortile(
new GetVectortileRequest( table_names, column_names,
9907 layers, tile_x, tile_y, zoom,
9924 GrantPermissionProcResponse actualResponse_ = SubmitRequest<GrantPermissionProcResponse>(
"/grant/permission/proc", request_,
false);
9926 return actualResponse_;
9956 IDictionary<string, string> options = null )
9959 proc_name, options ) );
9976 return actualResponse_;
10020 IDictionary<string, string> options = null )
10039 GrantPermissionTableResponse actualResponse_ = SubmitRequest<GrantPermissionTableResponse>(
"/grant/permission/table", request_,
false);
10041 return actualResponse_;
10104 string filter_expression =
"",
10105 IDictionary<string, string> options = null )
10125 GrantRoleResponse actualResponse_ = SubmitRequest<GrantRoleResponse>(
"/grant/role", request_,
false);
10127 return actualResponse_;
10146 IDictionary<string, string> options = null )
10163 HasProcResponse actualResponse_ = SubmitRequest<HasProcResponse>(
"/has/proc", request_,
false);
10165 return actualResponse_;
10181 IDictionary<string, string> options = null )
10198 HasTableResponse actualResponse_ = SubmitRequest<HasTableResponse>(
"/has/table", request_,
false);
10200 return actualResponse_;
10216 IDictionary<string, string> options = null )
10232 HasTypeResponse actualResponse_ = SubmitRequest<HasTypeResponse>(
"/has/type", request_,
false);
10234 return actualResponse_;
10249 IDictionary<string, string> options = null )
10282 InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>(
"/insert/records", request_,
true);
10284 return actualResponse_;
10318 actualRequest_.table_name = request_.table_name;
10319 foreach (var thisObj
in request_.data) actualRequest_.list.Add( AvroEncode( thisObj ) );
10320 actualRequest_.options = request_.options;
10321 InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>(
"/insert/records", actualRequest_,
true);
10323 return actualResponse_;
10494 IDictionary<string, string> options = null )
10528 return actualResponse_;
11047 IList<string> filepaths,
11048 IDictionary<string, string> create_table_options = null,
11049 IDictionary<string, string> options = null )
11053 create_table_options,
11076 InsertRecordsRandomResponse actualResponse_ = SubmitRequest<InsertRecordsRandomResponse>(
"/insert/records/random", request_,
false);
11078 return actualResponse_;
11327 IDictionary<
string, IDictionary<string, double>> options = null )
11354 InsertSymbolResponse actualResponse_ = SubmitRequest<InsertSymbolResponse>(
"/insert/symbol", request_,
false);
11356 return actualResponse_;
11414 string symbol_format,
11415 byte[] symbol_data,
11416 IDictionary<string, string> options = null )
11419 symbol_data, options ) );
11433 KillProcResponse actualResponse_ = SubmitRequest<KillProcResponse>(
"/kill/proc", request_,
false);
11435 return actualResponse_;
11465 IDictionary<string, string> options = null )
11478 public ListGraphResponse listGraph( ListGraphRequest request_ )
11480 ListGraphResponse actualResponse_ = SubmitRequest<ListGraphResponse>(
"/list/graph", request_,
false);
11482 return actualResponse_;
11494 public ListGraphResponse listGraph(
string graph_name =
"",
11495 IDictionary<string, string> options = null )
11497 return listGraph(
new ListGraphRequest( graph_name, options ) );
11521 LockTableResponse actualResponse_ = SubmitRequest<LockTableResponse>(
"/lock/table", request_,
false);
11523 return actualResponse_;
11580 IDictionary<string, string> options = null )
11610 MatchGraphResponse actualResponse_ = SubmitRequest<MatchGraphResponse>(
"/match/graph", request_,
false);
11612 return actualResponse_;
11927 IList<string> sample_points,
11929 string solution_table =
"",
11930 IDictionary<string, string> options = null )
11933 solve_method, solution_table,
11969 MergeRecordsResponse actualResponse_ = SubmitRequest<MergeRecordsResponse>(
"/merge/records", request_,
false);
11971 return actualResponse_;
12097 IList<string> source_table_names,
12098 IList<IDictionary<string, string>> field_maps,
12099 IDictionary<string, string> options = null )
12102 field_maps, options ) );
12125 ModifyGraphResponse actualResponse_ = SubmitRequest<ModifyGraphResponse>(
"/modify/graph", request_,
false);
12127 return actualResponse_;
12386 IList<string> nodes,
12387 IList<string> edges,
12388 IList<string> weights,
12389 IList<string> restrictions,
12390 IDictionary<string, string> options = null )
12393 restrictions, options ) );
12439 QueryGraphResponse actualResponse_ = SubmitRequest<QueryGraphResponse>(
"/query/graph", request_,
false);
12441 return actualResponse_;
12656 IList<string> queries,
12657 IList<string> restrictions = null,
12658 string adjacency_table =
"",
12660 IDictionary<string, string> options = null )
12663 adjacency_table, rings, options ) );
12678 RevokePermissionProcResponse actualResponse_ = SubmitRequest<RevokePermissionProcResponse>(
"/revoke/permission/proc", request_,
false);
12680 return actualResponse_;
12712 IDictionary<string, string> options = null )
12734 return actualResponse_;
12780 IDictionary<string, string> options = null )
12801 return actualResponse_;
12862 IDictionary<string, string> options = null )
12882 RevokeRoleResponse actualResponse_ = SubmitRequest<RevokeRoleResponse>(
"/revoke/role", request_,
false);
12884 return actualResponse_;
12904 IDictionary<string, string> options = null )
12917 public ShowFunctionsResponse showFunctions( ShowFunctionsRequest request_ )
12919 ShowFunctionsResponse actualResponse_ = SubmitRequest<ShowFunctionsResponse>(
"/show/functions", request_,
false);
12921 return actualResponse_;
12940 public ShowFunctionsResponse showFunctions( IDictionary<string, string> options = null )
12942 return showFunctions(
new ShowFunctionsRequest( options ) );
12958 ShowGraphResponse actualResponse_ = SubmitRequest<ShowGraphResponse>(
"/show/graph", request_,
false);
12960 return actualResponse_;
12998 IDictionary<string, string> options = null )
13011 public ShowGraphGrammarResponse showGraphGrammar( ShowGraphGrammarRequest request_ )
13013 ShowGraphGrammarResponse actualResponse_ = SubmitRequest<ShowGraphGrammarResponse>(
"/show/graph/grammar", request_,
false);
13015 return actualResponse_;
13026 public ShowGraphGrammarResponse showGraphGrammar( IDictionary<string, string> options = null )
13028 return showGraphGrammar(
new ShowGraphGrammarRequest( options ) );
13043 ShowProcResponse actualResponse_ = SubmitRequest<ShowProcResponse>(
"/show/proc", request_,
false);
13045 return actualResponse_;
13084 IDictionary<string, string> options = null )
13104 ShowProcStatusResponse actualResponse_ = SubmitRequest<ShowProcStatusResponse>(
"/show/proc/status", request_,
false);
13106 return actualResponse_;
13161 IDictionary<string, string> options = null )
13181 return actualResponse_;
13213 ShowResourceGroupsResponse actualResponse_ = SubmitRequest<ShowResourceGroupsResponse>(
"/show/resourcegroups", request_,
false);
13215 return actualResponse_;
13272 IDictionary<string, string> options = null )
13290 ShowSecurityResponse actualResponse_ = SubmitRequest<ShowSecurityResponse>(
"/show/security", request_,
false);
13292 return actualResponse_;
13310 IDictionary<string, string> options = null )
13327 ShowSqlProcResponse actualResponse_ = SubmitRequest<ShowSqlProcResponse>(
"/show/sql/proc", request_,
false);
13329 return actualResponse_;
13368 IDictionary<string, string> options = null )
13385 ShowStatisticsResponse actualResponse_ = SubmitRequest<ShowStatisticsResponse>(
"/show/statistics", request_,
false);
13387 return actualResponse_;
13403 IDictionary<string, string> options = null )
13421 ShowSystemPropertiesResponse actualResponse_ = SubmitRequest<ShowSystemPropertiesResponse>(
"/show/system/properties", request_,
false);
13423 return actualResponse_;
13464 ShowSystemStatusResponse actualResponse_ = SubmitRequest<ShowSystemStatusResponse>(
"/show/system/status", request_,
false);
13466 return actualResponse_;
13498 ShowSystemTimingResponse actualResponse_ = SubmitRequest<ShowSystemTimingResponse>(
"/show/system/timing", request_,
false);
13500 return actualResponse_;
13556 ShowTableResponse actualResponse_ = SubmitRequest<ShowTableResponse>(
"/show/table", request_,
false);
13559 for (
int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
13561 SetDecoderIfMissing( actualResponse_.
type_ids[i_],
13567 return actualResponse_;
13713 IDictionary<string, string> options = null )
13730 ShowTableMetadataResponse actualResponse_ = SubmitRequest<ShowTableMetadataResponse>(
"/show/table/metadata", request_,
false);
13732 return actualResponse_;
13748 IDictionary<string, string> options = null )
13768 ShowTablesByTypeResponse actualResponse_ = SubmitRequest<ShowTablesByTypeResponse>(
"/show/tables/bytype", request_,
false);
13770 return actualResponse_;
13793 IDictionary<string, string> options = null )
13810 ShowTriggersResponse actualResponse_ = SubmitRequest<ShowTriggersResponse>(
"/show/triggers", request_,
false);
13812 return actualResponse_;
13829 IDictionary<string, string> options = null )
13848 ShowTypesResponse actualResponse_ = SubmitRequest<ShowTypesResponse>(
"/show/types", request_,
false);
13851 for (
int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
13853 SetDecoderIfMissing( actualResponse_.
type_ids[i_],
13854 actualResponse_.
labels[i_],
13859 return actualResponse_;
13901 IDictionary<string, string> options = null )
13932 SolveGraphResponse actualResponse_ = SubmitRequest<SolveGraphResponse>(
"/solve/graph", request_,
false);
13934 return actualResponse_;
14294 IList<string> weights_on_edges = null,
14295 IList<string> restrictions = null,
14297 IList<string> source_nodes = null,
14298 IList<string> destination_nodes = null,
14299 string solution_table =
"graph_solutions",
14300 IDictionary<string, string> options = null )
14303 restrictions, solver_type,
14304 source_nodes, destination_nodes,
14305 solution_table, options ) );
14349 UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>(
"/update/records", request_,
true);
14351 return actualResponse_;
14398 actualRequest_.table_name = request_.table_name;
14399 actualRequest_.expressions = request_.expressions;
14400 actualRequest_.new_values_maps = request_.new_values_maps;
14401 foreach (var thisObj
in request_.data) actualRequest_.records_to_insert.Add( AvroEncode( thisObj ) );
14402 actualRequest_.options = request_.options;
14403 UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>(
"/update/records", actualRequest_,
true);
14405 return actualResponse_;
14601 IList<string> expressions,
14602 IList<IDictionary<string, string>> new_values_maps,
14603 IList<T> data = null,
14604 IDictionary<string, string> options = null )
14607 new_values_maps, data,
14629 return actualResponse_;
14654 string world_table_name,
14655 string view_name =
"",
14656 IList<string> reserved = null,
14657 IDictionary<string, string> options = null )
14674 public VisualizeImageResponse visualizeImage( VisualizeImageRequest request_ )
14676 VisualizeImageResponse actualResponse_ = SubmitRequest<VisualizeImageResponse>(
"/visualize/image", request_,
false);
14678 return actualResponse_;
15062 public VisualizeImageResponse visualizeImage( IList<string> table_names,
15063 IList<string> world_table_names,
15064 string x_column_name,
15065 string y_column_name,
15066 string symbol_column_name,
15067 string geometry_column_name,
15068 IList<IList<string>> track_ids,
15077 IDictionary<
string, IList<string>> style_options,
15078 IDictionary<string, string> options = null )
15080 return visualizeImage(
new VisualizeImageRequest( table_names,
15084 symbol_column_name,
15085 geometry_column_name,
15086 track_ids, min_x, max_x,
15087 min_y, max_y, width, height,
15088 projection, bg_color,
15089 style_options, options ) );
15110 VisualizeImageChartResponse actualResponse_ = SubmitRequest<VisualizeImageChartResponse>(
"/visualize/image/chart", request_,
false);
15112 return actualResponse_;
15366 IList<string> x_column_names,
15367 IList<string> y_column_names,
15375 IDictionary<
string, IList<string>> style_options,
15376 IDictionary<string, string> options = null )
15397 public VisualizeImageClassbreakResponse visualizeImageClassbreak( VisualizeImageClassbreakRequest request_ )
15399 VisualizeImageClassbreakResponse actualResponse_ = SubmitRequest<VisualizeImageClassbreakResponse>(
"/visualize/image/classbreak", request_,
false);
15401 return actualResponse_;
15787 public VisualizeImageClassbreakResponse visualizeImageClassbreak( IList<string> table_names,
15788 IList<string> world_table_names,
15789 string x_column_name,
15790 string y_column_name,
15791 string geometry_column_name,
15792 IList<IList<string>> track_ids,
15794 IList<string> cb_vals,
15795 string cb_pointcolor_attr,
15796 IList<string> cb_pointcolor_vals,
15797 string cb_pointalpha_attr,
15798 IList<string> cb_pointalpha_vals,
15799 string cb_pointsize_attr,
15800 IList<string> cb_pointsize_vals,
15801 string cb_pointshape_attr,
15802 IList<string> cb_pointshape_vals,
15811 IDictionary<
string, IList<string>> style_options,
15812 IDictionary<string, string> options,
15813 IList<int> cb_transparency_vec )
15815 return visualizeImageClassbreak(
new VisualizeImageClassbreakRequest(
15820 geometry_column_name,
15824 cb_pointcolor_attr,
15825 cb_pointcolor_vals,
15826 cb_pointalpha_attr,
15827 cb_pointalpha_vals,
15830 cb_pointshape_attr,
15831 cb_pointshape_vals,
15842 cb_transparency_vec ) );
15854 public VisualizeImageContourResponse visualizeImageContour( VisualizeImageContourRequest request_ )
15856 VisualizeImageContourResponse actualResponse_ = SubmitRequest<VisualizeImageContourResponse>(
"/visualize/image/contour", request_,
false);
15858 return actualResponse_;
16416 public VisualizeImageContourResponse visualizeImageContour( IList<string> table_names,
16417 string x_column_name,
16418 string y_column_name,
16419 string value_column_name,
16427 IDictionary<string, string> style_options,
16428 IDictionary<string, string> options = null )
16430 return visualizeImageContour(
new VisualizeImageContourRequest( table_names,
16451 public VisualizeImageHeatmapResponse visualizeImageHeatmap( VisualizeImageHeatmapRequest request_ )
16453 VisualizeImageHeatmapResponse actualResponse_ = SubmitRequest<VisualizeImageHeatmapResponse>(
"/visualize/image/heatmap", request_,
false);
16455 return actualResponse_;
16853 public VisualizeImageHeatmapResponse visualizeImageHeatmap( IList<string> table_names,
16854 string x_column_name,
16855 string y_column_name,
16856 string value_column_name,
16857 string geometry_column_name,
16865 IDictionary<string, string> style_options,
16866 IDictionary<string, string> options = null )
16868 return visualizeImageHeatmap(
new VisualizeImageHeatmapRequest( table_names,
16872 geometry_column_name,
16890 public VisualizeImageLabelsResponse visualizeImageLabels( VisualizeImageLabelsRequest request_ )
16892 VisualizeImageLabelsResponse actualResponse_ = SubmitRequest<VisualizeImageLabelsResponse>(
"/visualize/image/labels", request_,
false);
16894 return actualResponse_;
16971 public VisualizeImageLabelsResponse visualizeImageLabels(
string table_name,
16972 string x_column_name,
16973 string y_column_name,
16976 string text_string,
16982 string draw_leader,
16986 string leader_x_column_name,
16987 string leader_y_column_name,
16995 string projection = VisualizeImageLabelsRequest.Projection.PLATE_CARREE,
16996 IDictionary<string, string> options = null )
16998 return visualizeImageLabels(
new VisualizeImageLabelsRequest( table_name,
17013 leader_x_column_name,
17014 leader_y_column_name,
17042 VisualizeIsochroneResponse actualResponse_ = SubmitRequest<VisualizeIsochroneResponse>(
"/visualize/isochrone", request_,
false);
17044 return actualResponse_;
17791 string source_node,
17792 double max_solution_radius,
17793 IList<string> weights_on_edges,
17794 IList<string> restrictions,
17796 bool generate_image,
17797 string levels_table,
17798 IDictionary<string, string> style_options,
17799 IDictionary<string, string> solve_options = null,
17800 IDictionary<string, string> contour_options = null,
17801 IDictionary<string, string> options = null )
17805 max_solution_radius,
17825 public VisualizeVideoResponse visualizeVideo( VisualizeVideoRequest request_ )
17827 VisualizeVideoResponse actualResponse_ = SubmitRequest<VisualizeVideoResponse>(
"/visualize/video", request_,
false);
17829 return actualResponse_;
18136 public VisualizeVideoResponse visualizeVideo( IList<string> table_names,
18137 IList<string> world_table_names,
18138 IList<IList<string>> track_ids,
18139 string x_column_name,
18140 string y_column_name,
18141 string geometry_column_name,
18150 IList<IList<double>> time_intervals,
18151 string video_style,
18152 string session_key,
18153 IDictionary<
string, IList<string>> style_options,
18154 IDictionary<string, string> options = null )
18156 return visualizeVideo(
new VisualizeVideoRequest( table_names,
18158 track_ids, x_column_name,
18160 geometry_column_name, min_x,
18161 max_x, min_y, max_y, width,
18162 height, projection,
18163 bg_color, time_intervals,
18164 video_style, session_key,
18165 style_options, options ) );
18177 public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( VisualizeVideoHeatmapRequest request_ )
18179 VisualizeVideoHeatmapResponse actualResponse_ = SubmitRequest<VisualizeVideoHeatmapResponse>(
"/visualize/video/heatmap", request_,
false);
18181 return actualResponse_;
18321 public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( IList<string> table_names,
18322 string x_column_name,
18323 string y_column_name,
18328 IList<IList<double>> time_intervals,
18332 string video_style,
18333 string session_key,
18334 IDictionary<string, string> style_options,
18335 IDictionary<string, string> options = null )
18337 return visualizeVideoHeatmap(
new VisualizeVideoHeatmapRequest( table_names,
A set of parameters for Kinetica.grantPermissionProc(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.aggregateMinMax(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.createUnion(string,IList{string},IList{IList{string}},IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.grantRole(string,string,IDictionary{string, string})...
A set of results returned by Kinetica.aggregateConvexHull(string,string,string,IDictionary{string, string}).
UpdateRecordsResponse updateRecords< T >(UpdateRecordsRequest< T > request_)
Runs multiple predicate-based updates in a single call.
A set of results returned by Kinetica.getRecordsFromCollection{T}(string,long,long,IDictionary{string, string}).
FilterByTableResponse filterByTable(string table_name, string view_name, string column_name, string source_table_name, string source_table_column_name, IDictionary< string, string > options=null)
Filters objects in one table based on objects in another table.
MergeRecordsResponse mergeRecords(MergeRecordsRequest request_)
Create a new empty result table (specified by ), and insert all records from source tables (specified...
CreateProcResponse createProc(string proc_name, string execution_mode=CreateProcRequest.ExecutionMode.DISTRIBUTED, IDictionary< string, byte[]> files=null, string command="", IList< string > args=null, IDictionary< string, string > options=null)
Creates an instance (proc) of the user-defined function (UDF) specified by the given command...
FilterByStringResponse filterByString(FilterByStringRequest request_)
Calculates which objects from a table, collection, or view match a string expression for the given st...
A set of parameters for Kinetica.modifyGraph(string,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}).
CreateTriggerByRangeResponse createTriggerByRange(string request_id, IList< string > table_names, string column_name, double min, double max, IDictionary< string, string > options=null)
Sets up a simple range trigger for a column_name for one or more tables.
HasTableResponse hasTable(HasTableRequest request_)
Checks for the existence of a table with the given name.
A set of results returned by Kinetica.aggregateKMeans(string,IList{string},int,double,IDictionary{string, string}).
UpdateRecordsBySeriesResponse updateRecordsBySeries(string table_name, string world_table_name, string view_name="", IList< string > reserved=null, IDictionary< string, string > options=null)
Updates the view specified by table_name to include full series (track) information from the world_t...
A set of parameters for Kinetica.getRecordsBySeries{T}(string,string,int,int,IDictionary{string, string}).
ShowProcStatusResponse showProcStatus(ShowProcStatusRequest request_)
Shows the statuses of running or completed proc instances.
A set of results returned by Kinetica.adminRebalance(IDictionary{string, string}).
A set of results returned by Kinetica.showSystemProperties(IDictionary{string, string}).
A set of results returned by Kinetica.getRecordsByColumn(string,IList{string},long,long,IDictionary{string, string}).
A set of results returned by Kinetica.insertRecordsRandom(string,long,IDictionary{string, IDictionary{string, double}}).
A set of results returned by Kinetica.aggregateGroupBy(string,IList{string},long,long,IDictionary{string, string}).
A set of results returned by Kinetica.grantPermissionSystem(string,string,IDictionary{string, string}).
DeleteRecordsResponse deleteRecords(DeleteRecordsRequest request_)
Deletes record(s) matching the provided criteria from the given table.
AlterTableColumnsResponse alterTableColumns(AlterTableColumnsRequest request_)
Apply various modifications to columns in a table, view.
AlterTableMetadataResponse alterTableMetadata(AlterTableMetadataRequest request_)
Updates (adds or changes) metadata for tables.
A set of results returned by Kinetica.revokePermissionSystem(string,string,IDictionary{string, string}).
AggregateConvexHullResponse aggregateConvexHull(AggregateConvexHullRequest request_)
Calculates and returns the convex hull for the values in a table specified by .
A set of results returned by Kinetica.adminAddRanks(IList{string},IList{IDictionary{string, string}},IDictionary{string, string}).
HasTypeResponse hasType(HasTypeRequest request_)
Check for the existence of a type.
ShowStatisticsResponse showStatistics(IList< string > table_names, IDictionary< string, string > options=null)
Retrieves the collected column statistics for the specified table.
AggregateUniqueResponse aggregateUnique(string table_name, string column_name, long offset=0, long limit=-9999, IDictionary< string, string > options=null)
Returns all the unique values from a particular column (specified by column_name ) of a particular ta...
ShowTableResponse showTable(string table_name, IDictionary< string, string > options=null)
Retrieves detailed information about a table, view, or collection, specified in table_name ...
DeleteGraphResponse deleteGraph(string graph_name, IDictionary< string, string > options=null)
Deletes an existing graph from the graph server and/or persist.
FilterByListResponse filterByList(string table_name, string view_name, IDictionary< string, IList< string >> column_values_map, IDictionary< string, string > options=null)
Calculates which records from a table have values in the given list for the corresponding column...
HasTypeResponse hasType(string type_id, IDictionary< string, string > options=null)
Check for the existence of a type.
A set of parameters for Kinetica.createType(string,string,IDictionary{string, IList{string}},IDictionary{string, string}).
A set of parameters for Kinetica.updateRecordsBySeries(string,string,string,IList{string},IDictionary{string, string}).
AggregateMinMaxGeometryResponse aggregateMinMaxGeometry(string table_name, string column_name, IDictionary< string, string > options=null)
Calculates and returns the minimum and maximum x- and y-coordinates of a particular geospatial geomet...
A set of parameters for Kinetica.alterResourceGroup(string,IDictionary{string, IDictionary{string, string}},string,string,IDictionary{string, string}).
A set of results returned by Kinetica.createUserInternal(string,string,IDictionary{string, string}).
AdminRebalanceResponse adminRebalance(AdminRebalanceRequest request_)
Rebalance the cluster so that all the nodes contain approximately an equal number of records...
AggregateGroupByResponse aggregateGroupBy(string table_name, IList< string > column_names, long offset=0, long limit=-9999, IDictionary< string, string > options=null)
Calculates unique combinations (groups) of values for the given columns in a given table or view and ...
CreateUnionResponse createUnion(CreateUnionRequest request_)
Merges data from one or more tables with comparable data types into a new table.
FilterByTableResponse filterByTable(FilterByTableRequest request_)
Filters objects in one table based on objects in another table.
VisualizeImageChartResponse visualizeImageChart(string table_name, IList< string > x_column_names, IList< string > y_column_names, double min_x, double max_x, double min_y, double max_y, int width, int height, string bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
Scatter plot is the only plot type currently supported.
A set of parameters for Kinetica.alterTableColumns(string,IList{IDictionary{string, string}},IDictionary{string, string}).
A set of results returned by Kinetica.createTableMonitor(string,IDictionary{string, string}).
CreateJobResponse createJob(CreateJobRequest request_)
Create a job which will run asynchronously.
A set of results returned by Kinetica.showSystemTiming(IDictionary{string, string}).
IDictionary< string, IList< string > > properties
Value of .
ShowTriggersResponse showTriggers(ShowTriggersRequest request_)
Retrieves information regarding the specified triggers or all existing triggers currently active...
A set of results returned by Kinetica.alterSystemProperties(IDictionary{string, string},IDictionary{string, string}).
GrantRoleResponse grantRole(GrantRoleRequest request_)
Grants membership in a role to a user or role.
A set of results returned by Kinetica.adminShowClusterOperations(int,IDictionary{string, string}).
LockTableResponse lockTable(string table_name, string lock_type=LockTableRequest.LockType.STATUS, IDictionary< string, string > options=null)
Manages global access to a table's data.
ShowGraphResponse showGraph(ShowGraphRequest request_)
Shows information and characteristics of graphs that exist on the graph server.
AdminOfflineResponse adminOffline(bool offline, IDictionary< string, string > options=null)
Take the system offline.
RevokePermissionTableResponse revokePermissionTable(RevokePermissionTableRequest request_)
Revokes a table-level permission from a user or role.
RevokeRoleResponse revokeRole(string role, string member, IDictionary< string, string > options=null)
Revokes membership in a role from a user or role.
KillProcResponse killProc(string run_id="", IDictionary< string, string > options=null)
Kills a running proc instance.
A set of results returned by Kinetica.clearTable(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.clearTableMonitor(string,IDictionary{string, string}).
AdminShowShardsResponse adminShowShards(AdminShowShardsRequest request_)
Show the mapping of shards to the corresponding rank and tom.
QueryGraphResponse queryGraph(QueryGraphRequest request_)
Employs a topological query on a network graph generated a-priori by Kinetica.createGraph(string,bool,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}) and returns a list of adjacent edge(s) or node(s), also known as an adjacency list, depending on what's been provided to the endpoint; providing edges will return nodes and providing nodes will return edges.
AlterSystemPropertiesResponse alterSystemProperties(AlterSystemPropertiesRequest request_)
The Kinetica.alterSystemProperties(IDictionary{string, string},IDictionary{string, string}) endpoint is primarily used to simplify the testing of the system and is not expected to be used during normal execution.
A set of results returned by Kinetica.alterRole(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.alterTable(string,string,string,IDictionary{string, string}).
AggregateMinMaxGeometryResponse aggregateMinMaxGeometry(AggregateMinMaxGeometryRequest request_)
Calculates and returns the minimum and maximum x- and y-coordinates of a particular geospatial geomet...
A set of results returned by Kinetica.filterBySeries(string,string,string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.createProc(string,string,IDictionary{string, byte[]},string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.insertRecords{T}(string,IList{T},IDictionary{string, string}).
AdminAddRanksResponse adminAddRanks(AdminAddRanksRequest request_)
Add one or more new ranks to the Kinetica cluster.
InsertRecordsRandomResponse insertRecordsRandom(string table_name, long count, IDictionary< string, IDictionary< string, double >> options=null)
Generates a specified number of random records and adds them to the given table.
HasProcResponse hasProc(string proc_name, IDictionary< string, string > options=null)
Checks the existence of a proc with the given name.
AggregateMinMaxResponse aggregateMinMax(AggregateMinMaxRequest request_)
Calculates and returns the minimum and maximum values of a particular column in a table...
A set of results returned by Kinetica.insertSymbol(string,string,byte[],IDictionary{string, string}).
FilterByAreaResponse filterByArea(FilterByAreaRequest request_)
Calculates which objects from a table are within a named area of interest (NAI/polygon).
IList< IDictionary< string, IList< string > > > properties
AdminShowClusterOperationsResponse adminShowClusterOperations(AdminShowClusterOperationsRequest request_)
Requests the detailed status of the current operation (by default) or a prior cluster operation speci...
KillProcResponse killProc(KillProcRequest request_)
Kills a running proc instance.
IList< string > type_schemas
Type schemas of the respective tables in <member name="table_names">.
A set of parameters for Kinetica.aggregateHistogram(string,string,double,double,double,IDictionary{string, string}).
A set of results returned by Kinetica.visualizeImageChart(string,IList{string},IList{string},double,double,double,double,int,int,string,IDictionary{string, IList{string}},IDictionary{string, string}).
A set of results returned by Kinetica.alterResourceGroup(string,IDictionary{string, IDictionary{string, string}},string,string,IDictionary{string, string}).
A set of results returned by Kinetica.getRecords{T}(string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.createTriggerByRange(string,IList{string},string,double,double,IDictionary{string, string}).
CreateTableResponse createTable(CreateTableRequest request_)
Creates a new table or collection.
A set of parameters for Kinetica.deleteRecords(string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.lockTable(string,string,IDictionary{string, string}).
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in <member name="table_names">.
A set of parameters for Kinetica.deleteRole(string,IDictionary{string, string}).
A set of parameters for Kinetica.showProcStatus(string,IDictionary{string, string}).
A set of results returned by Kinetica.clearStatistics(string,string,IDictionary{string, string}).
A set of parameters for Kinetica.aggregateStatisticsByRange(string,string,string,string,string,double,double,double,IDictionary{string, string}).
A set of parameters for Kinetica.appendRecords(string,string,IDictionary{string, string},IDictionary{string, string}).
IList< string > type_ids
Type ids of the respective tables in <member name="table_names">.
A set of parameters for Kinetica.createTableMonitor(string,IDictionary{string, string}).
A set of results returned by Kinetica.aggregateMinMax(string,string,IDictionary{string, string}).
string type_id
An identifier representing the created type.
A set of results returned by Kinetica.filterByRadius(string,string,string,double,string,double,double,IDictionary{string, string}).
AggregateStatisticsResponse aggregateStatistics(AggregateStatisticsRequest request_)
Calculates the requested statistics of the given column(s) in a given table.
A set of parameters for Kinetica.clearTable(string,string,IDictionary{string, string}).
A set of parameters for Kinetica.createUnion(string,IList{string},IList{IList{string}},IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.createTriggerByArea(string,IList{string},string,IList{double},string,IList{double},IDictionary{string, string}).
A set of parameters for Kinetica.showSystemTiming(IDictionary{string, string}).
A set of results returned by Kinetica.getRecords{T}(string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.adminShowJobs(IDictionary{string, string}). ...
AdminShutdownResponse adminShutdown(AdminShutdownRequest request_)
Exits the database server application.
GrantPermissionProcResponse grantPermissionProc(GrantPermissionProcRequest request_)
Grants a proc-level permission to a user or role.
A set of results returned by Kinetica.aggregateUnpivot(string,IList{string},string,string,IList{string},IDictionary{string, string}).
InsertRecordsFromFilesResponse insertRecordsFromFiles(string table_name, IList< string > filepaths, IDictionary< string, string > create_table_options=null, IDictionary< string, string > options=null)
Reads from one or more files located on the server and inserts the data into a new or existing table...
ShowSecurityResponse showSecurity(ShowSecurityRequest request_)
Shows security information relating to users and/or roles.
A set of parameters for Kinetica.deleteResourceGroup(string,IDictionary{string, string}).
A set of results returned by Kinetica.alterTier(string,IDictionary{string, string}).
A set of results returned by Kinetica.clearTrigger(string,IDictionary{string, string}).
ShowTablesByTypeResponse showTablesByType(ShowTablesByTypeRequest request_)
Gets names of the tables whose type matches the given criteria.
A set of parameters for Kinetica.updateRecords{T}(string,IList{string},IList{IDictionary{string, string}},IList{T},IDictionary{string, string}).
ExecuteSqlResponse executeSql(ExecuteSqlRequest request_)
SQL Request
MergeRecordsResponse mergeRecords(string table_name, IList< string > source_table_names, IList< IDictionary< string, string >> field_maps, IDictionary< string, string > options=null)
Create a new empty result table (specified by table_name ), and insert all records from source tables...
CreateJoinTableResponse createJoinTable(CreateJoinTableRequest request_)
Creates a table that is the result of a SQL JOIN.
FilterByAreaGeometryResponse filterByAreaGeometry(string table_name, string view_name, string column_name, IList< double > x_vector, IList< double > y_vector, IDictionary< string, string > options=null)
Calculates which geospatial geometry objects from a table intersect a named area of interest (NAI/pol...
CreateGraphResponse createGraph(CreateGraphRequest request_)
Creates a new graph network using given nodes, edges, weights, and restrictions.
ShowSqlProcResponse showSqlProc(string procedure_name="", IDictionary< string, string > options=null)
Shows information about SQL procedures, including the full definition of each requested procedure...
RevokePermissionProcResponse revokePermissionProc(RevokePermissionProcRequest request_)
Revokes a proc-level permission from a user or role.
GrantPermissionSystemResponse grantPermissionSystem(GrantPermissionSystemRequest request_)
Grants a system-level permission to a user or role.
AdminRemoveRanksResponse adminRemoveRanks(AdminRemoveRanksRequest request_)
Remove one or more ranks from the cluster.
CreateJobResponse createJob(string endpoint, string request_encoding, byte[] data, string data_str, IDictionary< string, string > options=null)
Create a job which will run asynchronously.
A set of parameters for Kinetica.filterByRadius(string,string,string,double,string,double,double,IDictionary{string, string}).
A set of results returned by Kinetica.hasTable(string,IDictionary{string, string}).
ShowProcStatusResponse showProcStatus(string run_id="", IDictionary< string, string > options=null)
Shows the statuses of running or completed proc instances.
ShowTriggersResponse showTriggers(IList< string > trigger_ids, IDictionary< string, string > options=null)
Retrieves information regarding the specified triggers or all existing triggers currently active...
FilterByValueResponse filterByValue(string table_name, string view_name, bool is_string, double _value, string value_str, string column_name, IDictionary< string, string > options=null)
Calculates which objects from a table has a particular value for a particular column.
RevokePermissionTableResponse revokePermissionTable(string name, string permission, string table_name, IDictionary< string, string > options=null)
Revokes a table-level permission from a user or role.
A set of parameters for Kinetica.createMaterializedView(string,IDictionary{string, string}).
A set of results returned by Kinetica.grantPermissionProc(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.createUserExternal(string,IDictionary{string, string}).
A set of parameters for Kinetica.showGraph(string,IDictionary{string, string}).
DeleteProcResponse deleteProc(string proc_name, IDictionary< string, string > options=null)
Deletes a proc.
A set of results returned by Kinetica.aggregateUnpivot(string,IList{string},string,string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.adminShutdown(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.filterByValue(string,string,bool,double,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.filterByAreaGeometry(string,string,string,IList{double},IList{double},IDictionary{string, string}).
A set of results returned by Kinetica.filterByString(string,string,string,string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.updateRecords{T}(string,IList{string},IList{IDictionary{string, string}},IList{T},IDictionary{string, string}).
GetRecordsBySeriesResponse< T > getRecordsBySeries< T >(GetRecordsBySeriesRequest request_)
Retrieves the complete series/track records from the given based on the partial track information co...
A set of parameters for Kinetica.clearStatistics(string,string,IDictionary{string, string}).
DeleteRoleResponse deleteRole(DeleteRoleRequest request_)
Deletes an existing role.
ClearTableMonitorResponse clearTableMonitor(string topic_id, IDictionary< string, string > options=null)
Deactivates a table monitor previously created with Kinetica.createTableMonitor(string,IDictionary{string, string}).
ShowSystemStatusResponse showSystemStatus(ShowSystemStatusRequest request_)
Provides server configuration and health related status to the caller.
AdminRemoveRanksResponse adminRemoveRanks(IList< int > ranks, IDictionary< string, string > options=null)
Remove one or more ranks from the cluster.
CreateMaterializedViewResponse createMaterializedView(CreateMaterializedViewRequest request_)
Initiates the process of creating a materialized view, reserving the view's name to prevent other vie...
A set of results returned by Kinetica.alterUser(string,string,string,IDictionary{string, string}).
AppendRecordsResponse appendRecords(string table_name, string source_table_name, IDictionary< string, string > field_map, IDictionary< string, string > options=null)
Append (or insert) all records from a source table (specified by source_table_name ) to a particular ...
A set of results returned by Kinetica.updateRecords{T}(string,IList{string},IList{IDictionary{string...
RevokePermissionSystemResponse revokePermissionSystem(string name, string permission, IDictionary< string, string > options=null)
Revokes a system-level permission from a user or role.
A set of parameters for Kinetica.showResourceStatistics(IDictionary{string, string}).
GetRecordsByColumnResponse getRecordsByColumn(string table_name, IList< string > column_names, long offset=0, long limit=-9999, IDictionary< string, string > options=null)
For a given table, retrieves the values from the requested column(s).
A set of parameters for Kinetica.getRecordsByColumn(string,IList{string},long,long,IDictionary{string, string}).
A set of parameters for Kinetica.revokePermissionSystem(string,string,IDictionary{string, string}).
AdminVerifyDbResponse adminVerifyDb(IDictionary< string, string > options=null)
Verify database is in a consistent state.
InsertSymbolResponse insertSymbol(string symbol_id, string symbol_format, byte[] symbol_data, IDictionary< string, string > options=null)
Adds a symbol or icon (i.e.
InsertRecordsFromFilesResponse insertRecordsFromFiles(InsertRecordsFromFilesRequest request_)
Reads from one or more files located on the server and inserts the data into a new or existing table...
A set of parameters for Kinetica.adminAlterJobs(IList{long},string,IDictionary{string, string}).
GrantRoleResponse grantRole(string role, string member, IDictionary< string, string > options=null)
Grants membership in a role to a user or role.
CreateTriggerByAreaResponse createTriggerByArea(string request_id, IList< string > table_names, string x_column_name, IList< double > x_vector, string y_column_name, IList< double > y_vector, IDictionary< string, string > options=null)
Sets up an area trigger mechanism for two column_names for one or more tables.
CreateGraphResponse createGraph(string graph_name, bool directed_graph, IList< string > nodes, IList< string > edges, IList< string > weights, IList< string > restrictions, IDictionary< string, string > options=null)
Creates a new graph network using given nodes, edges, weights, and restrictions.
A set of results returned by Kinetica.alterTableColumns(string,IList{IDictionary{string, string}},IDictionary{string, string}).
AlterTableColumnsResponse alterTableColumns(string table_name, IList< IDictionary< string, string >> column_alterations, IDictionary< string, string > options)
Apply various modifications to columns in a table, view.
AdminOfflineResponse adminOffline(AdminOfflineRequest request_)
Take the system offline.
ShowSystemTimingResponse showSystemTiming(IDictionary< string, string > options=null)
Returns the last 100 database requests along with the request timing and internal job id...
GetRecordsResponse< T > getRecords< T >(GetRecordsRequest request_)
Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column...
A set of results returned by Kinetica.killProc(string,IDictionary{string, string}).
A set of results returned by Kinetica.adminAlterJobs(IList{long},string,IDictionary{string, string}).
FilterByStringResponse filterByString(string table_name, string view_name, string expression, string mode, IList< string > column_names, IDictionary< string, string > options=null)
Calculates which objects from a table, collection, or view match a string expression for the given st...
RevokePermissionProcResponse revokePermissionProc(string name, string permission, string proc_name, IDictionary< string, string > options=null)
Revokes a proc-level permission from a user or role.
IList< string > type_schemas
A set of parameters for Kinetica.showSystemProperties(IDictionary{string, string}).
ShowResourceStatisticsResponse showResourceStatistics(ShowResourceStatisticsRequest request_)
Requests various statistics for storage/memory tiers and resource groups.
CreateUserInternalResponse createUserInternal(string name, string password, IDictionary< string, string > options=null)
Creates a new internal user (a user whose credentials are managed by the database system)...
ClearStatisticsResponse clearStatistics(ClearStatisticsRequest request_)
Clears statistics (cardinality, mean value, etc.) for a column in a specified table.
AdminShowShardsResponse adminShowShards(IDictionary< string, string > options=null)
Show the mapping of shards to the corresponding rank and tom.
ShowResourceStatisticsResponse showResourceStatistics(IDictionary< string, string > options=null)
Requests various statistics for storage/memory tiers and resource groups.
A set of results returned by Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}).
CreateUnionResponse createUnion(string table_name, IList< string > table_names, IList< IList< string >> input_column_names, IList< string > output_column_names, IDictionary< string, string > options=null)
Merges data from one or more tables with comparable data types into a new table.
CreateTableResponse createTable(string table_name, string type_id, IDictionary< string, string > options=null)
Creates a new table or collection.
CreateMaterializedViewResponse createMaterializedView(string table_name, IDictionary< string, string > options=null)
Initiates the process of creating a materialized view, reserving the view's name to prevent other vie...
A set of results returned by Kinetica.revokePermissionProc(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.alterRole(string,string,string,IDictionary{string, string}).
FilterByRadiusResponse filterByRadius(FilterByRadiusRequest request_)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
ShowStatisticsResponse showStatistics(ShowStatisticsRequest request_)
Retrieves the collected column statistics for the specified table.
A set of results returned by Kinetica.updateRecordsBySeries(string,string,string,IList{string},IDictionary{string, string}).
AppendRecordsResponse appendRecords(AppendRecordsRequest request_)
Append (or insert) all records from a source table (specified by ) to a particular target table (spec...
A set of results returned by Kinetica.showSqlProc(string,IDictionary{string, string}).
A set of parameters for Kinetica.deleteProc(string,IDictionary{string, string}).
A set of parameters for Kinetica.hasProc(string,IDictionary{string, string}).
ShowResourceGroupsResponse showResourceGroups(IList< string > names, IDictionary< string, string > options=null)
Requests resource group properties.
A set of parameters for Kinetica.solveGraph(string,IList{string},IList{string},string,IList{string},IList{string},string,IDictionary{string, string}).
A set of results returned by Kinetica.showGraph(string,IDictionary{string, string}).
AlterRoleResponse alterRole(AlterRoleRequest request_)
Alters a Role.
A set of parameters for Kinetica.filterBySeries(string,string,string,IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.adminShutdown(string,string,IDictionary{string, string}).
A set of parameters for Kinetica.mergeRecords(string,IList{string},IList{IDictionary{string, string}},IDictionary{string, string}).
A set of parameters for Kinetica.grantPermissionTable(string,string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.grantPermissionTable(string,string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.showTable(string,IDictionary{string, string}).
A set of results returned by Kinetica.aggregateHistogram(string,string,double,double,double,IDictionary{string, string}).
HasProcResponse hasProc(HasProcRequest request_)
Checks the existence of a proc with the given name.
CollectStatisticsResponse collectStatistics(CollectStatisticsRequest request_)
Collect statistics for a column(s) in a specified table.
A set of parameters for Kinetica.alterTier(string,IDictionary{string, string}).
AlterUserResponse alterUser(AlterUserRequest request_)
Alters a user.
ShowSystemTimingResponse showSystemTiming(ShowSystemTimingRequest request_)
Returns the last 100 database requests along with the request timing and internal job id...
VisualizeIsochroneResponse visualizeIsochrone(string graph_name, string source_node, double max_solution_radius, IList< string > weights_on_edges, IList< string > restrictions, int num_levels, bool generate_image, string levels_table, IDictionary< string, string > style_options, IDictionary< string, string > solve_options=null, IDictionary< string, string > contour_options=null, IDictionary< string, string > options=null)
Generate an image containing isolines for travel results using an existing graph. ...
AdminRebalanceResponse adminRebalance(IDictionary< string, string > options=null)
Rebalance the cluster so that all the nodes contain approximately an equal number of records...
MatchGraphResponse matchGraph(string graph_name, IList< string > sample_points, string solve_method=MatchGraphRequest.SolveMethod.MARKOV_CHAIN, string solution_table="", IDictionary< string, string > options=null)
Matches a directed route implied by a given set of latitude/longitude points to an existing underlyin...
AlterSystemPropertiesResponse alterSystemProperties(IDictionary< string, string > property_updates_map, IDictionary< string, string > options=null)
The Kinetica.alterSystemProperties(IDictionary{string, string},IDictionary{string, string}) endpoint is primarily used to simplify the testing of the system and is not expected to be used during normal execution.
A set of results returned by Kinetica.aggregateUnique(string,string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.filterByBoxGeometry(string,string,string,double,double,double,double,IDictionary{string, string}).
A set of parameters for Kinetica.adminShowShards(IDictionary{string, string}).
A set of parameters for Kinetica.showTypes(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.showResourceGroups(IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.filterByArea(string,string,string,IList{double},string,IList{double},IDictionary{string, string}).
ShowGraphResponse showGraph(string graph_name="", IDictionary< string, string > options=null)
Shows information and characteristics of graphs that exist on the graph server.
CollectStatisticsResponse collectStatistics(string table_name, IList< string > column_names, IDictionary< string, string > options=null)
Collect statistics for a column(s) in a specified table.
A set of results returned by Kinetica.deleteRecords(string,IList{string},IDictionary{string, string}).
AggregateGroupByResponse aggregateGroupBy(AggregateGroupByRequest request_)
Calculates unique combinations (groups) of values for the given columns in a given table or view and ...
A set of parameters for Kinetica.grantPermissionSystem(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.deleteResourceGroup(string,IDictionary{string, string}).
GetJobResponse getJob(long job_id, IDictionary< string, string > options=null)
Get the status and result of asynchronously running job.
RevokeRoleResponse revokeRole(RevokeRoleRequest request_)
Revokes membership in a role from a user or role.
A set of results returned by Kinetica.getRecordsBySeries{T}(string,string,int,int,IDictionary{string, string}).
DeleteResourceGroupResponse deleteResourceGroup(string name, IDictionary< string, string > options=null)
Deletes a resource group.
A set of results returned by Kinetica.executeSql(string,long,long,string,IList{byte[]},IDictionary{string, string}).
CreateTableMonitorResponse createTableMonitor(CreateTableMonitorRequest request_)
Creates a monitor that watches for a single table modification event type (insert, update, or delete) on a particular table (identified by ) and forwards event notifications to subscribers via ZMQ.
AlterTierResponse alterTier(AlterTierRequest request_)
Alters properties of an exisiting tier to facilitate resource management.
LockTableResponse lockTable(LockTableRequest request_)
Manages global access to a table's data.
CreateResourceGroupResponse createResourceGroup(CreateResourceGroupRequest request_)
Creates a new resource group to facilitate resource management.
SolveGraphResponse solveGraph(SolveGraphRequest request_)
Solves an existing graph for a type of problem (e.g., shortest path, page rank, travelling salesman...
A set of parameters for Kinetica.grantRole(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.deleteRole(string,IDictionary{string, string}).
A set of results returned by Kinetica.createMaterializedView(string,IDictionary{string, string}).
CreateTypeResponse createType(string type_definition, string label, IDictionary< string, IList< string >> properties=null, IDictionary< string, string > options=null)
Creates a new type describing the layout or schema of a table.
AlterTierResponse alterTier(string name, IDictionary< string, string > options=null)
Alters properties of an exisiting tier to facilitate resource management.
A set of parameters for Kinetica.filterByList(string,string,IDictionary{string, IList{string}},IDictionary{string, string}).
GetRecordsFromCollectionResponse< T > getRecordsFromCollection< T >(GetRecordsFromCollectionRequest request_)
Retrieves records from a collection.
A set of parameters for Kinetica.filterByValue(string,string,bool,double,string,string,IDictionary{string, string}).
CreateJoinTableResponse createJoinTable(string join_table_name, IList< string > table_names, IList< string > column_names, IList< string > expressions=null, IDictionary< string, string > options=null)
Creates a table that is the result of a SQL JOIN.
A set of results returned by Kinetica.filterByTable(string,string,string,string,string,IDictionary{string, string}).
CreateProcResponse createProc(CreateProcRequest request_)
Creates an instance (proc) of the user-defined function (UDF) specified by the given command...
AggregateStatisticsByRangeResponse aggregateStatisticsByRange(AggregateStatisticsByRangeRequest request_)
Divides the given set into bins and calculates statistics of the values of a value-column in each bin...
GetJobResponse getJob(GetJobRequest request_)
Get the status and result of asynchronously running job.
A set of results returned by Kinetica.showStatistics(IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}).
string type_definition
Value of .
A set of parameters for Kinetica.createTriggerByRange(string,IList{string},string,double,double,IDictionary{string, string}).
FilterByAreaGeometryResponse filterByAreaGeometry(FilterByAreaGeometryRequest request_)
Calculates which geospatial geometry objects from a table intersect a named area of interest (NAI/pol...
FilterByBoxResponse filterByBox(string table_name, string view_name, string x_column_name, double min_x, double max_x, string y_column_name, double min_y, double max_y, IDictionary< string, string > options=null)
Calculates how many objects within the given table lie in a rectangular box.
FilterByGeometryResponse filterByGeometry(string table_name, string view_name, string column_name, string input_wkt, string operation, IDictionary< string, string > options=null)
Applies a geometry filter against a geospatial geometry column in a given table, collection or view...
A set of results returned by Kinetica.createJob(string,string,byte[],string,IDictionary{string, string}).
FilterByRangeResponse filterByRange(FilterByRangeRequest request_)
Calculates which objects from a table have a column that is within the given bounds.
A set of results returned by Kinetica.matchGraph(string,IList{string},string,string,IDictionary{string, string}).
ClearStatisticsResponse clearStatistics(string table_name="", string column_name="", IDictionary< string, string > options=null)
Clears statistics (cardinality, mean value, etc.) for a column in a specified table.
CreateTriggerByRangeResponse createTriggerByRange(CreateTriggerByRangeRequest request_)
Sets up a simple range trigger for a column_name for one or more tables.
AdminShowAlertsResponse adminShowAlerts(int num_alerts, IDictionary< string, string > options=null)
Requests a list of the most recent alerts.
A set of parameters for Kinetica.createGraph(string,bool,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}).
AggregateUnpivotResponse aggregateUnpivot(AggregateUnpivotRequest request_)
Rotate the column values into rows values.
AdminShutdownResponse adminShutdown(string exit_type, string authorization, IDictionary< string, string > options=null)
Exits the database server application.
A set of results returned by Kinetica.createRole(string,IDictionary{string, string}).
A set of parameters for Kinetica.executeSql(string,long,long,string,IList{byte[]},IDictionary{string, string}).
FilterByRadiusResponse filterByRadius(string table_name, string view_name, string x_column_name, double x_center, string y_column_name, double y_center, double radius, IDictionary< string, string > options=null)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
A set of parameters for Kinetica.aggregateUnpivot(string,IList{string},string,string,IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.getRecordsByColumn(string,IList{string},long,long,IDictionary{string, string}).
A set of parameters for Kinetica.alterUser(string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.filterByArea(string,string,string,IList{double},string,IList{double},IDictionary{string, string}).
CreateUserExternalResponse createUserExternal(string name, IDictionary< string, string > options=null)
Creates a new external user (a user whose credentials are managed by an external LDAP).
AdminShowJobsResponse adminShowJobs(AdminShowJobsRequest request_)
Get a list of the current jobs in GPUdb.
FilterBySeriesResponse filterBySeries(string table_name, string view_name, string track_id, IList< string > target_track_ids, IDictionary< string, string > options=null)
Filters objects matching all points of the given track (works only on track type data).
A set of parameters for Kinetica.adminRemoveRanks(IList{int},IDictionary{string, string}).
A set of parameters for Kinetica.createTable(string,string,IDictionary{string, string}).
AlterUserResponse alterUser(string name, string action, string _value, IDictionary< string, string > options=null)
Alters a user.
A set of parameters for Kinetica.getRecords{T}(string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.revokeRole(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.createJoinTable(string,IList{string},IList{string},IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.filterByBoxGeometry(string,string,string,double,double,double,double,IDictionary{string, string}).
ShowProcResponse showProc(string proc_name="", IDictionary< string, string > options=null)
Shows information about a proc.
ClearTableMonitorResponse clearTableMonitor(ClearTableMonitorRequest request_)
Deactivates a table monitor previously created with Kinetica.createTableMonitor(string,IDictionary{string, string}).
AggregateHistogramResponse aggregateHistogram(AggregateHistogramRequest request_)
Performs a histogram calculation given a table, a column, and an interval function.
ExecuteProcResponse executeProc(string proc_name, IDictionary< string, string > _params=null, IDictionary< string, byte[]> bin_params=null, IList< string > input_table_names=null, IDictionary< string, IList< string >> input_column_names=null, IList< string > output_table_names=null, IDictionary< string, string > options=null)
Executes a proc.
FilterByGeometryResponse filterByGeometry(FilterByGeometryRequest request_)
Applies a geometry filter against a geospatial geometry column in a given table, collection or view...
A set of results returned by Kinetica.showTablesByType(string,string,IDictionary{string, string}).
CreateTypeResponse createType(CreateTypeRequest request_)
Creates a new type describing the layout or schema of a table.
AlterTableMetadataResponse alterTableMetadata(IList< string > table_names, IDictionary< string, string > metadata_map, IDictionary< string, string > options=null)
Updates (adds or changes) metadata for tables.
FilterByRadiusGeometryResponse filterByRadiusGeometry(string table_name, string view_name, string column_name, double x_center, double y_center, double radius, IDictionary< string, string > options=null)
Calculates which geospatial geometry objects from a table intersect a circle with the given radius an...
A set of parameters for Kinetica.insertSymbol(string,string,byte[],IDictionary{string, string}).
DeleteGraphResponse deleteGraph(DeleteGraphRequest request_)
Deletes an existing graph from the graph server and/or persist.
A set of results returned by Kinetica.revokePermissionTable(string,string,string,IDictionary{string, string}).
DeleteUserResponse deleteUser(string name, IDictionary< string, string > options=null)
Deletes an existing user.
AdminShowJobsResponse adminShowJobs(IDictionary< string, string > options=null)
Get a list of the current jobs in GPUdb.
CreateUserInternalResponse createUserInternal(CreateUserInternalRequest request_)
Creates a new internal user (a user whose credentials are managed by the database system)...
A set of parameters for Kinetica.getRecordsFromCollection{T}(string,long,long,IDictionary{string, string}).
A set of parameters for Kinetica.adminRebalance(IDictionary{string, string}).
ClearTableResponse clearTable(ClearTableRequest request_)
Clears (drops) one or all tables in the database cluster.
ShowTableResponse showTable(ShowTableRequest request_)
Retrieves detailed information about a table, view, or collection, specified in . ...
A set of results returned by Kinetica.showSystemStatus(IDictionary{string, string}).
A set of results returned by Kinetica.insertRecordsFromFiles(string,IList{string},IDictionary{string, string},IDictionary{string, string}).
ShowSystemPropertiesResponse showSystemProperties(IDictionary< string, string > options=null)
Returns server configuration and version related information to the caller.
A set of results returned by Kinetica.aggregateUnique(string,string,long,long,IDictionary{string, string}).
AggregateStatisticsResponse aggregateStatistics(string table_name, string column_name, string stats, IDictionary< string, string > options=null)
Calculates the requested statistics of the given column(s) in a given table.
DeleteUserResponse deleteUser(DeleteUserRequest request_)
Deletes an existing user.
A set of parameters for Kinetica.hasType(string,IDictionary{string, string}).
A set of parameters for Kinetica.filterByGeometry(string,string,string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.adminShowAlerts(int,IDictionary{string, string}).
ClearTriggerResponse clearTrigger(string trigger_id, IDictionary< string, string > options=null)
Clears or cancels the trigger identified by the specified handle.
A set of results returned by Kinetica.executeProc(string,IDictionary{string, string},IDictionary{string, byte[]},IList{string},IDictionary{string, IList{string}},IList{string},IDictionary{string, string}).
FilterByBoxGeometryResponse filterByBoxGeometry(FilterByBoxGeometryRequest request_)
Calculates which geospatial geometry objects from a table intersect a rectangular box...
FilterByAreaResponse filterByArea(string table_name, string view_name, string x_column_name, IList< double > x_vector, string y_column_name, IList< double > y_vector, IDictionary< string, string > options=null)
Calculates which objects from a table are within a named area of interest (NAI/polygon).
A set of parameters for Kinetica.visualizeIsochrone(string,string,double,IList{string},IList{string},int,bool,string,IDictionary{string, string},IDictionary{string, string},IDictionary{string, string},IDictionary{string, string}).
CreateProjectionResponse createProjection(string table_name, string projection_name, IList< string > column_names, IDictionary< string, string > options=null)
Creates a new projection of an existing table.
A set of parameters for Kinetica.aggregateConvexHull(string,string,string,IDictionary{string, string}).
GrantPermissionProcResponse grantPermissionProc(string name, string permission, string proc_name, IDictionary< string, string > options=null)
Grants a proc-level permission to a user or role.
A set of parameters for Kinetica.showTable(string,IDictionary{string, string}).
A set of results returned by Kinetica.createProc(string,string,IDictionary{string, byte[]},string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.alterSystemProperties(IDictionary{string, string},IDictionary{string, string}).
A set of parameters for Kinetica.showSqlProc(string,IDictionary{string, string}). ...
ShowSystemPropertiesResponse showSystemProperties(ShowSystemPropertiesRequest request_)
Returns server configuration and version related information to the caller.
A set of results returned by Kinetica.createGraph(string,bool,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.filterByRange(string,string,string,double,double,IDictionary{string, string}).
AggregateStatisticsByRangeResponse aggregateStatisticsByRange(string table_name, string select_expression, string column_name, string value_column_name, string stats, double start, double end, double interval, IDictionary< string, string > options=null)
Divides the given set into bins and calculates statistics of the values of a value-column in each bin...
AggregateHistogramResponse aggregateHistogram(string table_name, string column_name, double start, double end, double interval, IDictionary< string, string > options=null)
Performs a histogram calculation given a table, a column, and an interval function.
A set of parameters for Kinetica.revokeRole(string,string,IDictionary{string, string}).
FilterBySeriesResponse filterBySeries(FilterBySeriesRequest request_)
Filters objects matching all points of the given track (works only on track type data).
ShowTypesResponse showTypes(string type_id, string label, IDictionary< string, string > options=null)
Retrieves information for the specified data type ID or type label.
A set of parameters for Kinetica.showProc(string,IDictionary{string, string}).
A set of results returned by Kinetica.aggregateGroupBy(string,IList{string},long,long,IDictionary{string, string}).
ExecuteProcResponse executeProc(ExecuteProcRequest request_)
Executes a proc.
FilterByRangeResponse filterByRange(string table_name, string view_name, string column_name, double lower_bound, double upper_bound, IDictionary< string, string > options=null)
Calculates which objects from a table have a column that is within the given bounds.
A set of parameters for Kinetica.insertRecords{T}(string,IList{T},IDictionary{string, string}).
AggregateMinMaxResponse aggregateMinMax(string table_name, string column_name, IDictionary< string, string > options=null)
Calculates and returns the minimum and maximum values of a particular column in a table...
InsertRecordsResponse insertRecords< T >(InsertRecordsRequest< T > request_)
Adds multiple records to the specified table.
A set of parameters for Kinetica.filterByRadiusGeometry(string,string,string,double,double,double,IDictionary{string, string}).
AlterTableResponse alterTable(AlterTableRequest request_)
Apply various modifications to a table, view, or collection.
A set of results returned by Kinetica.showTriggers(IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.aggregateKMeans(string,IList{string},int,double,IDictionary{string, string}).
MatchGraphResponse matchGraph(MatchGraphRequest request_)
Matches a directed route implied by a given set of latitude/longitude points to an existing underlyin...
A set of parameters for Kinetica.createJob(string,string,byte[],string,IDictionary{string, string}).
CreateTriggerByAreaResponse createTriggerByArea(CreateTriggerByAreaRequest request_)
Sets up an area trigger mechanism for two column_names for one or more tables.
GrantPermissionTableResponse grantPermissionTable(GrantPermissionTableRequest request_)
Grants a table-level permission to a user or role.
A set of results returned by Kinetica.appendRecords(string,string,IDictionary{string, string},IDictionary{string, string}).
A set of results returned by Kinetica.filterByRadiusGeometry(string,string,string,double,double,double,IDictionary{string, string}).
A set of parameters for Kinetica.collectStatistics(string,IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.filterByBox(string,string,string,double,double,string,double,double,IDictionary{string, string}).
A set of results returned by Kinetica.showProc(string,IDictionary{string, string}).
AlterTableResponse alterTable(string table_name, string action, string _value, IDictionary< string, string > options=null)
Apply various modifications to a table, view, or collection.
A set of results returned by Kinetica.createUserExternal(string,IDictionary{string, string}).
A set of results returned by Kinetica.filterByAreaGeometry(string,string,string,IList{double},IList{double},IDictionary{string, string}).
CreateResourceGroupResponse createResourceGroup(string name, IDictionary< string, IDictionary< string, string >> tier_attributes, string ranking, string adjoining_resource_group="", IDictionary< string, string > options=null)
Creates a new resource group to facilitate resource management.
FilterByRadiusGeometryResponse filterByRadiusGeometry(FilterByRadiusGeometryRequest request_)
Calculates which geospatial geometry objects from a table intersect a circle with the given radius an...
InsertSymbolResponse insertSymbol(InsertSymbolRequest request_)
Adds a symbol or icon (i.e.
AdminShowClusterOperationsResponse adminShowClusterOperations(int history_index=0, IDictionary< string, string > options=null)
Requests the detailed status of the current operation (by default) or a prior cluster operation speci...
CreateUserExternalResponse createUserExternal(CreateUserExternalRequest request_)
Creates a new external user (a user whose credentials are managed by an external LDAP).
AggregateKMeansResponse aggregateKMeans(AggregateKMeansRequest request_)
This endpoint runs the k-means algorithm - a heuristic algorithm that attempts to do k-means clusteri...
ShowTableMetadataResponse showTableMetadata(ShowTableMetadataRequest request_)
Retrieves the user provided metadata for the specified tables.
A set of results returned by Kinetica.adminVerifyDb(IDictionary{string, string}). ...
A set of results returned by Kinetica.solveGraph(string,IList{string},IList{string},string,IList{string},IList{string},string,IDictionary{string, string}).
AdminAlterJobsResponse adminAlterJobs(AdminAlterJobsRequest request_)
Perform the requested action on a list of one or more job(s).
FilterByValueResponse filterByValue(FilterByValueRequest request_)
Calculates which objects from a table has a particular value for a particular column.
A set of results returned by Kinetica.getJob(long,IDictionary{string, string}).
SolveGraphResponse solveGraph(string graph_name, IList< string > weights_on_edges=null, IList< string > restrictions=null, string solver_type=SolveGraphRequest.SolverType.SHORTEST_PATH, IList< string > source_nodes=null, IList< string > destination_nodes=null, string solution_table="graph_solutions", IDictionary< string, string > options=null)
Solves an existing graph for a type of problem (e.g., shortest path, page rank, travelling salesman...
GrantPermissionSystemResponse grantPermissionSystem(string name, string permission, IDictionary< string, string > options=null)
Grants a system-level permission to a user or role.
A set of parameters for Kinetica.showSecurity(IList{string},IDictionary{string, string}).
FilterByListResponse filterByList(FilterByListRequest request_)
Calculates which records from a table have values in the given list for the corresponding column...
FilterByBoxGeometryResponse filterByBoxGeometry(string table_name, string view_name, string column_name, double min_x, double max_x, double min_y, double max_y, IDictionary< string, string > options=null)
Calculates which geospatial geometry objects from a table intersect a rectangular box...
AggregateUnpivotResponse aggregateUnpivot(string table_name, IList< string > column_names, string variable_column_name, string value_column_name, IList< string > pivoted_columns, IDictionary< string, string > options=null)
Rotate the column values into rows values.
A set of results returned by Kinetica.showResourceStatistics(IDictionary{string, string}).
FilterResponse filter(string table_name, string view_name, string expression, IDictionary< string, string > options=null)
Filters data based on the specified expression.
A set of parameters for Kinetica.killProc(string,IDictionary{string, string}).
A set of parameters for Kinetica.filterByString(string,string,string,string,IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.filter(string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.hasProc(string,IDictionary{string, string}).
HasTableResponse hasTable(string table_name, IDictionary< string, string > options=null)
Checks for the existence of a table with the given name.
A set of parameters for Kinetica.revokePermissionProc(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.aggregateMinMaxGeometry(string,string,IDictionary{string, string}).
A set of results returned by Kinetica.visualizeIsochrone(string,string,double,IList{string},IList{string},int,bool,string,IDictionary{string, string},IDictionary{string, string},IDictionary{string, string},IDictionary{string, string}).
A set of parameters for Kinetica.createTriggerByArea(string,IList{string},string,IList{double},string,IList{double},IDictionary{string, string}).
IList< string > type_labels
Type labels of the respective tables in <member name="table_names">.
A set of results returned by Kinetica.hasType(string,IDictionary{string, string}).
ShowTablesByTypeResponse showTablesByType(string type_id, string label, IDictionary< string, string > options=null)
Gets names of the tables whose type matches the given criteria.
FilterResponse filter(FilterRequest request_)
Filters data based on the specified expression.
VisualizeImageChartResponse visualizeImageChart(VisualizeImageChartRequest request_)
Scatter plot is the only plot type currently supported.
CreateRoleResponse createRole(CreateRoleRequest request_)
Creates a new role.
ClearTriggerResponse clearTrigger(ClearTriggerRequest request_)
Clears or cancels the trigger identified by the specified handle.
A set of results returned by Kinetica.filterByGeometry(string,string,string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.mergeRecords(string,IList{string},IList{IDictionary{string, string}},IDictionary{string, string}).
A set of parameters for Kinetica.adminAddRanks(IList{string},IList{IDictionary{string, string}},IDictionary{string, string}).
A set of parameters for Kinetica.matchGraph(string,IList{string},string,string,IDictionary{string, string}).
UpdateRecordsResponse updateRecordsRaw(RawUpdateRecordsRequest request_)
Runs multiple predicate-based updates in a single call.
ExecuteSqlResponse executeSql(string statement, long offset=0, long limit=-9999, string request_schema_str="", IList< byte[]> data=null, IDictionary< string, string > options=null)
SQL Request
A set of results returned by Kinetica.filterByRange(string,string,string,double,double,IDictionary{string, string}).
A set of parameters for Kinetica.clearTableMonitor(string,IDictionary{string, string}).
ShowTableMetadataResponse showTableMetadata(IList< string > table_names, IDictionary< string, string > options=null)
Retrieves the user provided metadata for the specified tables.
A set of results returned by Kinetica.getRecordsFromCollection{T}(string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.deleteGraph(string,IDictionary{string, string}).
ShowProcResponse showProc(ShowProcRequest request_)
Shows information about a proc.
A set of parameters for Kinetica.deleteUser(string,IDictionary{string, string}).
A set of parameters for Kinetica.showTablesByType(string,string,IDictionary{string, string}).
GrantPermissionTableResponse grantPermissionTable(string name, string permission, string table_name, string filter_expression="", IDictionary< string, string > options=null)
Grants a table-level permission to a user or role.
A set of results returned by Kinetica.showSecurity(IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.filter(string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.createTable(string,string,IDictionary{string, string}).
AdminAddRanksResponse adminAddRanks(IList< string > hosts, IList< IDictionary< string, string >> config_params, IDictionary< string, string > options=null)
Add one or more new ranks to the Kinetica cluster.
AdminShowAlertsResponse adminShowAlerts(AdminShowAlertsRequest request_)
Requests a list of the most recent alerts.
AdminAlterJobsResponse adminAlterJobs(IList< long > job_ids, string action, IDictionary< string, string > options=null)
Perform the requested action on a list of one or more job(s).
InsertRecordsRandomResponse insertRecordsRandom(InsertRecordsRandomRequest request_)
Generates a specified number of random records and adds them to the given table.
A set of parameters for Kinetica.adminShowClusterOperations(int,IDictionary{string, string}).
ShowSystemStatusResponse showSystemStatus(IDictionary< string, string > options=null)
Provides server configuration and health related status to the caller.
AggregateUniqueResponse aggregateUnique(AggregateUniqueRequest request_)
Returns all the unique values from a particular column (specified by ) of a particular table or view ...
A set of parameters for Kinetica.clearTrigger(string,IDictionary{string, string}).
A set of parameters for Kinetica.aggregateStatistics(string,string,string,IDictionary{string, string}).
ModifyGraphResponse modifyGraph(string graph_name, IList< string > nodes, IList< string > edges, IList< string > weights, IList< string > restrictions, IDictionary< string, string > options=null)
Update an existing graph network using given nodes, edges, weights, restrictions, and options...
ShowTypesResponse showTypes(ShowTypesRequest request_)
Retrieves information for the specified data type ID or type label.
QueryGraphResponse queryGraph(string graph_name, IList< string > queries, IList< string > restrictions=null, string adjacency_table="", int rings=1, IDictionary< string, string > options=null)
Employs a topological query on a network graph generated a-priori by Kinetica.createGraph(string,bool,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}) and returns a list of adjacent edge(s) or node(s), also known as an adjacency list, depending on what's been provided to the endpoint; providing edges will return nodes and providing nodes will return edges.
RevokePermissionSystemResponse revokePermissionSystem(RevokePermissionSystemRequest request_)
Revokes a system-level permission from a user or role.
A set of results returned by Kinetica.modifyGraph(string,IList{string},IList{string},IList{string},IList{string},IDictionary{string, string}).
AlterRoleResponse alterRole(string name, string action, string _value, IDictionary< string, string > options=null)
Alters a Role.
A set of results returned by Kinetica.insertRecords{T}(string,IList{T},IDictionary{string, string}).
A set of parameters for Kinetica.insertRecordsRandom(string,long,IDictionary{string, IDictionary{string, double}}).
A set of parameters for Kinetica.queryGraph(string,IList{string},IList{string},string,int,IDictionary{string, string}).
A set of parameters for Kinetica.adminVerifyDb(IDictionary{string, string}).
GetRecordsByColumnResponse getRecordsByColumn(GetRecordsByColumnRequest request_)
For a given table, retrieves the values from the requested column(s).
VisualizeIsochroneResponse visualizeIsochrone(VisualizeIsochroneRequest request_)
Generate an image containing isolines for travel results using an existing graph. ...
A set of results returned by Kinetica.getRecordsBySeries{T}(string,string,int,int,IDictionary{string, string}).
A set of parameters for Kinetica.filterByTable(string,string,string,string,string,IDictionary{string, string}).
A set of results returned by Kinetica.aggregateStatisticsByRange(string,string,string,string,string,double,double,double,IDictionary{string, string}).
FilterByBoxResponse filterByBox(FilterByBoxRequest request_)
Calculates how many objects within the given table lie in a rectangular box.
A set of results returned by Kinetica.adminRemoveRanks(IList{int},IDictionary{string, string}).
A set of results returned by Kinetica.createResourceGroup(string,IDictionary{string, IDictionary{string, string}},string,string,IDictionary{string, string}).
A set of parameters for Kinetica.showResourceGroups(IList{string},IDictionary{string, string}).
A set of results returned by Kinetica.queryGraph(string,IList{string},IList{string},string,int,IDictionary{string, string}).
ModifyGraphResponse modifyGraph(ModifyGraphRequest request_)
Update an existing graph network using given nodes, edges, weights, restrictions, and options...
A set of results returned by Kinetica.showProcStatus(string,IDictionary{string, string}).
A set of parameters for Kinetica.createUserInternal(string,string,IDictionary{string, string}).
A set of parameters for Kinetica.insertRecordsFromFiles(string,IList{string},IDictionary{string, string},IDictionary{string, string}).
DeleteRoleResponse deleteRole(string name, IDictionary< string, string > options=null)
Deletes an existing role.
A set of parameters for Kinetica.visualizeImageChart(string,IList{string},IList{string},double,double,double,double,int,int,string,IDictionary{string, IList{string}},IDictionary{string, string}).
ClearTableResponse clearTable(string table_name="", string authorization="", IDictionary< string, string > options=null)
Clears (drops) one or all tables in the database cluster.
A set of parameters for Kinetica.showStatistics(IList{string},IDictionary{string, string})...
A set of results returned by Kinetica.lockTable(string,string,IDictionary{string, string})...
ShowResourceGroupsResponse showResourceGroups(ShowResourceGroupsRequest request_)
Requests resource group properties.
A set of results returned by Kinetica.aggregateStatistics(string,string,string,IDictionary{string, string}).
DeleteResourceGroupResponse deleteResourceGroup(DeleteResourceGroupRequest request_)
Deletes a resource group.
UpdateRecordsBySeriesResponse updateRecordsBySeries(UpdateRecordsBySeriesRequest request_)
Updates the view specified by to include full series (track) information from the for the series (t...
A set of results returned by Kinetica.alterTable(string,string,string,IDictionary{string, string}).
CreateProjectionResponse createProjection(CreateProjectionRequest request_)
Creates a new projection of an existing table.
InsertRecordsResponse insertRecordsRaw(RawInsertRecordsRequest request_)
Adds multiple records to the specified table.
AdminVerifyDbResponse adminVerifyDb(AdminVerifyDbRequest request_)
Verify database is in a consistent state.
A set of parameters for Kinetica.getJob(long,IDictionary{string, string}).
A set of parameters for Kinetica.createJoinTable(string,IList{string},IList{string},IList{string},IDictionary{string, string}).
A set of parameters for Kinetica.showSystemStatus(IDictionary{string, string}).
A set of parameters for Kinetica.executeProc(string,IDictionary{string, string},IDictionary{string, byte[]},IList{string},IDictionary{string, IList{string}},IList{string},IDictionary{string, string}).
ShowSecurityResponse showSecurity(IList< string > names, IDictionary< string, string > options=null)
Shows security information relating to users and/or roles.
ShowSqlProcResponse showSqlProc(ShowSqlProcRequest request_)
Shows information about SQL procedures, including the full definition of each requested procedure...
A set of parameters for Kinetica.createRole(string,IDictionary{string, string}).
A set of parameters for Kinetica.adminShowJobs(IDictionary{string, string}).
A set of results returned by Kinetica.createType(string,string,IDictionary{string, IList{string}},IDictionary{string, string}).
A set of results returned by Kinetica.adminShowAlerts(int,IDictionary{string, string}).
A set of parameters for Kinetica.aggregateUnique(string,string,long,long,IDictionary{string, string}).
A set of results returned by Kinetica.showTypes(string,string,IDictionary{string, string})...
A set of results returned by Kinetica.deleteUser(string,IDictionary{string, string}).
AggregateKMeansResponse aggregateKMeans(string table_name, IList< string > column_names, int k, double tolerance, IDictionary< string, string > options=null)
This endpoint runs the k-means algorithm - a heuristic algorithm that attempts to do k-means clusteri...
A set of results returned by Kinetica.adminShowShards(IDictionary{string, string}).
A set of results returned by Kinetica.adminOffline(bool,IDictionary{string, string}).
DeleteProcResponse deleteProc(DeleteProcRequest request_)
Deletes a proc.
A set of results returned by Kinetica.filterByList(string,string,IDictionary{string, IList{string}},IDictionary{string, string}).
DeleteRecordsResponse deleteRecords(string table_name, IList< string > expressions, IDictionary< string, string > options=null)
Deletes record(s) matching the provided criteria from the given table.
CreateTableMonitorResponse createTableMonitor(string table_name, IDictionary< string, string > options=null)
Creates a monitor that watches for a single table modification event type (insert, update, or delete) on a particular table (identified by table_name ) and forwards event notifications to subscribers via ZMQ.
A set of parameters for Kinetica.adminOffline(bool,IDictionary{string, string}).
A set of results returned by Kinetica.collectStatistics(string,IList{string},IDictionary{string, string}).
AlterResourceGroupResponse alterResourceGroup(AlterResourceGroupRequest request_)
Alters the properties of an exisiting resource group to facilitate resource management.
AlterResourceGroupResponse alterResourceGroup(string name, IDictionary< string, IDictionary< string, string >> tier_attributes=null, string ranking=AlterResourceGroupRequest.Ranking.EMPTY_STRING, string adjoining_resource_group="", IDictionary< string, string > options=null)
Alters the properties of an exisiting resource group to facilitate resource management.
A set of parameters for Kinetica.createResourceGroup(string,IDictionary{string, IDictionary{string, string}},string,string,IDictionary{string, string}).
A set of results returned by Kinetica.aggregateMinMaxGeometry(string,string,IDictionary{string, string}).
A set of parameters for Kinetica.hasTable(string,IDictionary{string, string}).
A set of parameters for Kinetica.deleteGraph(string,IDictionary{string, string}). ...
AggregateConvexHullResponse aggregateConvexHull(string table_name, string x_column_name, string y_column_name, IDictionary< string, string > options=null)
Calculates and returns the convex hull for the values in a table specified by table_name ...
CreateRoleResponse createRole(string name, IDictionary< string, string > options=null)
Creates a new role.
A set of parameters for Kinetica.aggregateGroupBy(string,IList{string},long,long,IDictionary{string, string}).
A set of results returned by Kinetica.deleteProc(string,IDictionary{string, string}).
A set of results returned by Kinetica.executeSql(string,long,long,string,IList{byte[]},IDictionary{string, string}).
A set of parameters for Kinetica.revokePermissionTable(string,string,string,IDictionary{string, string}).
A set of parameters for Kinetica.filterByBox(string,string,string,double,double,string,double,double,IDictionary{string, string}).
A set of parameters for Kinetica.showTriggers(IList{string},IDictionary{string, string}).