9 using System.Collections.Generic;
15 public partial class Kinetica
34 AdminDeleteNodeResponse actualResponse_ = SubmitRequest<AdminDeleteNodeResponse>(
"/admin/delete/node", request_,
false);
36 return actualResponse_;
52 IDictionary<string, string> options = null )
72 return actualResponse_;
102 AdminOfflineResponse actualResponse_ = SubmitRequest<AdminOfflineResponse>(
"/admin/offline", request_,
false);
104 return actualResponse_;
121 IDictionary<string, string> options = null )
138 AdminRebalanceResponse actualResponse_ = SubmitRequest<AdminRebalanceResponse>(
"/admin/rebalance", request_,
false);
140 return actualResponse_;
154 IDictionary<string, string> options = null )
173 return actualResponse_;
191 bool partial_reassignment,
192 IList<int> shard_assignments_rank,
193 IList<int> shard_assignments_tom,
194 IList<int> assignment_index,
195 IDictionary<string, string> options = null )
198 partial_reassignment,
199 shard_assignments_rank,
200 shard_assignments_tom,
216 AdminShutdownResponse actualResponse_ = SubmitRequest<AdminShutdownResponse>(
"/admin/shutdown", request_,
false);
218 return actualResponse_;
234 string authorization,
235 IDictionary<string, string> options = null )
255 AdminVerifyDbResponse actualResponse_ = SubmitRequest<AdminVerifyDbResponse>(
"/admin/verifydb", request_,
false);
257 return actualResponse_;
289 AggregateConvexHullResponse actualResponse_ = SubmitRequest<AggregateConvexHullResponse>(
"/aggregate/convexhull", request_,
false);
291 return actualResponse_;
313 string x_column_name,
314 string y_column_name,
315 IDictionary<string, string> options = null )
390 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
391 response_.total_number_of_records = actualResponse_.total_number_of_records;
392 response_.has_more_records = actualResponse_.has_more_records;
532 IList<string> column_names,
535 IDictionary<string, string> options = null )
538 column_names, offset,
564 AggregateHistogramResponse actualResponse_ = SubmitRequest<AggregateHistogramResponse>(
"/aggregate/histogram", request_,
false);
566 return actualResponse_;
613 IDictionary<string, string> options = null )
641 AggregateKMeansResponse actualResponse_ = SubmitRequest<AggregateKMeansResponse>(
"/aggregate/kmeans", request_,
false);
643 return actualResponse_;
694 IList<string> column_names,
697 IDictionary<string, string> options = null )
700 k, tolerance, options ) );
715 AggregateMinMaxResponse actualResponse_ = SubmitRequest<AggregateMinMaxResponse>(
"/aggregate/minmax", request_,
false);
717 return actualResponse_;
735 IDictionary<string, string> options = null )
791 AggregateStatisticsResponse actualResponse_ = SubmitRequest<AggregateStatisticsResponse>(
"/aggregate/statistics", request_,
false);
793 return actualResponse_;
870 IDictionary<string, string> options = null )
915 return actualResponse_;
994 string select_expression,
996 string value_column_name,
1001 IDictionary<string, string> options = null )
1069 RawAggregateUniqueResponse actualResponse_ = SubmitRequest<RawAggregateUniqueResponse>(
"/aggregate/unique", request_,
false);
1072 response_.table_name = actualResponse_.table_name;
1073 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1074 response_.has_more_records = actualResponse_.has_more_records;
1187 IDictionary<string, string> options = null )
1190 offset, limit, options ) );
1214 return actualResponse_;
1319 IDictionary<string, string> options = null )
1322 property_updates_map,
1361 AlterTableResponse actualResponse_ = SubmitRequest<AlterTableResponse>(
"/alter/table", request_,
false);
1363 return actualResponse_;
1448 IDictionary<string, string> options = null )
1468 AlterTableMetadataResponse actualResponse_ = SubmitRequest<AlterTableMetadataResponse>(
"/alter/table/metadata", request_,
false);
1470 return actualResponse_;
1494 IDictionary<string, string> metadata_map,
1495 IDictionary<string, string> options = null )
1513 AlterUserResponse actualResponse_ = SubmitRequest<AlterUserResponse>(
"/alter/user", request_,
false);
1515 return actualResponse_;
1536 IDictionary<string, string> options )
1556 ClearTableResponse actualResponse_ = SubmitRequest<ClearTableResponse>(
"/clear/table", request_,
false);
1558 return actualResponse_;
1579 string authorization =
"",
1580 IDictionary<string, string> options = null )
1598 ClearTableMonitorResponse actualResponse_ = SubmitRequest<ClearTableMonitorResponse>(
"/clear/tablemonitor", request_,
false);
1600 return actualResponse_;
1616 IDictionary<string, string> options = null )
1635 ClearTriggerResponse actualResponse_ = SubmitRequest<ClearTriggerResponse>(
"/clear/trigger", request_,
false);
1637 return actualResponse_;
1654 IDictionary<string, string> options = null )
1672 CreateJoinTableResponse actualResponse_ = SubmitRequest<CreateJoinTableResponse>(
"/create/jointable", request_,
false);
1674 return actualResponse_;
1750 IList<string> table_names = null,
1751 IList<string> column_names = null,
1752 IList<string> expressions = null,
1753 IDictionary<string, string> options = null )
1756 table_names, column_names,
1757 expressions, options ) );
1775 CreateProcResponse actualResponse_ = SubmitRequest<CreateProcResponse>(
"/create/proc", request_,
false);
1777 return actualResponse_;
1819 IDictionary<
string, byte[]> files = null,
1820 string command =
"",
1821 IList<string> args = null,
1822 IDictionary<string, string> options = null )
1825 command, args, options ) );
1869 CreateProjectionResponse actualResponse_ = SubmitRequest<CreateProjectionResponse>(
"/create/projection", request_,
false);
1871 return actualResponse_;
1983 string projection_name,
1984 IList<string> column_names,
1985 IDictionary<string, string> options = null )
1989 column_names, options ) );
2003 CreateRoleResponse actualResponse_ = SubmitRequest<CreateRoleResponse>(
"/create/role", request_,
false);
2005 return actualResponse_;
2021 IDictionary<string, string> options )
2049 CreateTableResponse actualResponse_ = SubmitRequest<CreateTableResponse>(
"/create/table", request_,
false);
2051 return actualResponse_;
2153 IDictionary<string, string> options = null )
2181 CreateTableMonitorResponse actualResponse_ = SubmitRequest<CreateTableMonitorResponse>(
"/create/tablemonitor", request_,
false);
2183 return actualResponse_;
2209 IDictionary<string, string> options = null )
2241 CreateTriggerByAreaResponse actualResponse_ = SubmitRequest<CreateTriggerByAreaResponse>(
"/create/trigger/byarea", request_,
false);
2243 return actualResponse_;
2291 IList<string> table_names,
2292 string x_column_name,
2293 IList<double> x_vector,
2294 string y_column_name,
2295 IList<double> y_vector,
2296 IDictionary<string, string> options = null )
2303 y_vector, options ) );
2330 CreateTriggerByRangeResponse actualResponse_ = SubmitRequest<CreateTriggerByRangeResponse>(
"/create/trigger/byrange", request_,
false);
2332 return actualResponse_;
2369 IList<string> table_names,
2373 IDictionary<string, string> options = null )
2431 CreateTypeResponse actualResponse_ = SubmitRequest<CreateTypeResponse>(
"/create/type", request_,
false);
2433 SetDecoderIfMissing( actualResponse_.
type_id,
2434 actualResponse_.
label,
2437 return actualResponse_;
2499 IDictionary<
string, IList<string>> properties = null,
2500 IDictionary<string, string> options = null )
2526 CreateUnionResponse actualResponse_ = SubmitRequest<CreateUnionResponse>(
"/create/union", request_,
false);
2528 return actualResponse_;
2599 IList<string> table_names,
2600 IList<IList<string>> input_column_names,
2601 IList<string> output_column_names,
2602 IDictionary<string, string> options = null )
2606 output_column_names, options ) );
2621 CreateUserExternalResponse actualResponse_ = SubmitRequest<CreateUserExternalResponse>(
"/create/user/external", request_,
false);
2623 return actualResponse_;
2639 IDictionary<string, string> options )
2656 CreateUserInternalResponse actualResponse_ = SubmitRequest<CreateUserInternalResponse>(
"/create/user/internal", request_,
false);
2658 return actualResponse_;
2678 IDictionary<string, string> options )
2696 DeleteProcResponse actualResponse_ = SubmitRequest<DeleteProcResponse>(
"/delete/proc", request_,
false);
2698 return actualResponse_;
2713 IDictionary<string, string> options = null )
2737 DeleteRecordsResponse actualResponse_ = SubmitRequest<DeleteRecordsResponse>(
"/delete/records", request_,
false);
2739 return actualResponse_;
2784 IList<string> expressions,
2785 IDictionary<string, string> options = null )
2802 DeleteRoleResponse actualResponse_ = SubmitRequest<DeleteRoleResponse>(
"/delete/role", request_,
false);
2804 return actualResponse_;
2818 IDictionary<string, string> options )
2834 DeleteUserResponse actualResponse_ = SubmitRequest<DeleteUserResponse>(
"/delete/user", request_,
false);
2836 return actualResponse_;
2850 IDictionary<string, string> options )
2867 ExecuteProcResponse actualResponse_ = SubmitRequest<ExecuteProcResponse>(
"/execute/proc", request_,
false);
2869 return actualResponse_;
2936 IDictionary<string, string> _params = null,
2937 IDictionary<
string, byte[]> bin_params = null,
2938 IList<string> input_table_names = null,
2939 IDictionary<
string, IList<string>> input_column_names = null,
2940 IList<string> output_table_names = null,
2941 IDictionary<string, string> options = null )
2946 output_table_names, options ) );
2969 FilterResponse actualResponse_ = SubmitRequest<FilterResponse>(
"/filter", request_,
false);
2971 return actualResponse_;
3023 IDictionary<string, string> options = null )
3051 FilterByAreaResponse actualResponse_ = SubmitRequest<FilterByAreaResponse>(
"/filter/byarea", request_,
false);
3053 return actualResponse_;
3094 string x_column_name,
3095 IList<double> x_vector,
3096 string y_column_name,
3097 IList<double> y_vector,
3098 IDictionary<string, string> options = null )
3101 x_column_name, x_vector,
3102 y_column_name, y_vector, options ) );
3123 FilterByBoxResponse actualResponse_ = SubmitRequest<FilterByBoxResponse>(
"/filter/bybox", request_,
false);
3125 return actualResponse_;
3169 string x_column_name,
3172 string y_column_name,
3175 IDictionary<string, string> options = null )
3178 x_column_name, min_x, max_x,
3179 y_column_name, min_y, max_y,
3197 FilterByGeometryResponse actualResponse_ = SubmitRequest<FilterByGeometryResponse>(
"/filter/bygeometry", request_,
false);
3199 return actualResponse_;
3233 IDictionary<string, string> options = null )
3236 column_name, input_wkt,
3237 operation, options ) );
3267 FilterByListResponse actualResponse_ = SubmitRequest<FilterByListResponse>(
"/filter/bylist", request_,
false);
3269 return actualResponse_;
3316 IDictionary<
string, IList<string>> column_values_map,
3317 IDictionary<string, string> options = null )
3320 column_values_map, options ) );
3349 FilterByRadiusResponse actualResponse_ = SubmitRequest<FilterByRadiusResponse>(
"/filter/byradius", request_,
false);
3351 return actualResponse_;
3400 string x_column_name,
3402 string y_column_name,
3405 IDictionary<string, string> options = null )
3408 x_column_name, x_center,
3409 y_column_name, y_center,
3410 radius, options ) );
3437 FilterByRangeResponse actualResponse_ = SubmitRequest<FilterByRangeResponse>(
"/filter/byrange", request_,
false);
3439 return actualResponse_;
3480 IDictionary<string, string> options = null )
3483 column_name, lower_bound,
3484 upper_bound, options ) );
3512 FilterBySeriesResponse actualResponse_ = SubmitRequest<FilterBySeriesResponse>(
"/filter/byseries", request_,
false);
3514 return actualResponse_;
3580 IList<string> target_track_ids,
3581 IDictionary<string, string> options = null )
3584 track_id, target_track_ids,
3604 FilterByStringResponse actualResponse_ = SubmitRequest<FilterByStringResponse>(
"/filter/bystring", request_,
false);
3606 return actualResponse_;
3649 IList<string> column_names,
3650 IDictionary<string, string> options = null )
3654 column_names, options ) );
3678 FilterByTableResponse actualResponse_ = SubmitRequest<FilterByTableResponse>(
"/filter/bytable", request_,
false);
3680 return actualResponse_;
3768 string source_table_name,
3769 string source_table_column_name,
3770 IDictionary<string, string> options = null )
3775 source_table_column_name,
3800 FilterByValueResponse actualResponse_ = SubmitRequest<FilterByValueResponse>(
"/filter/byvalue", request_,
false);
3802 return actualResponse_;
3841 IDictionary<string, string> options = null )
3844 is_string, _value, value_str,
3845 column_name, options ) );
3873 RawGetRecordsResponse actualResponse_ = SubmitRequest<RawGetRecordsResponse>(
"/get/records", request_,
false);
3876 response_.table_name = actualResponse_.table_name;
3877 response_.type_name = actualResponse_.type_name;
3878 response_.type_schema = actualResponse_.type_schema;
3879 response_.data =
new List<T>();
3880 this.DecodeRawBinaryDataUsingSchemaString<T>( response_.type_schema, actualResponse_.records_binary, response_.data );
3881 response_.total_number_of_records = actualResponse_.total_number_of_records;
3882 response_.has_more_records = actualResponse_.has_more_records;
3950 IDictionary<string, string> options = null ) where T :
new()
3988 response_.table_name = actualResponse_.table_name;
3989 response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
3990 response_.total_number_of_records = actualResponse_.total_number_of_records;
3991 response_.has_more_records = actualResponse_.has_more_records;
4064 IList<string> column_names,
4067 IDictionary<string, string> options = null )
4107 response_.table_names = actualResponse_.table_names;
4108 response_.type_names = actualResponse_.type_names;
4109 response_.type_schemas = actualResponse_.type_schemas;
4110 response_.data =
new List<IList<T>>();
4111 this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.list_records_binary, response_.data );
4156 string world_table_name,
4159 IDictionary<string, string> options = null ) where T :
new()
4193 response_.table_name = actualResponse_.table_name;
4194 response_.type_names = actualResponse_.type_names;
4195 response_.data =
new List<T>();
4196 this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.records_binary, response_.data );
4197 response_.record_ids = actualResponse_.record_ids;
4244 IDictionary<string, string> options = null ) where T :
new()
4267 return actualResponse_;
4286 IDictionary<string, string> options )
4305 GrantPermissionTableResponse actualResponse_ = SubmitRequest<GrantPermissionTableResponse>(
"/grant/permission/table", request_,
false);
4307 return actualResponse_;
4333 string filter_expression,
4334 IDictionary<string, string> options )
4354 GrantRoleResponse actualResponse_ = SubmitRequest<GrantRoleResponse>(
"/grant/role", request_,
false);
4356 return actualResponse_;
4374 IDictionary<string, string> options )
4391 HasProcResponse actualResponse_ = SubmitRequest<HasProcResponse>(
"/has/proc", request_,
false);
4393 return actualResponse_;
4408 IDictionary<string, string> options = null )
4425 HasTableResponse actualResponse_ = SubmitRequest<HasTableResponse>(
"/has/table", request_,
false);
4427 return actualResponse_;
4442 IDictionary<string, string> options = null )
4458 HasTypeResponse actualResponse_ = SubmitRequest<HasTypeResponse>(
"/has/type", request_,
false);
4460 return actualResponse_;
4474 IDictionary<string, string> options = null )
4510 InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>(
"/insert/records", request_,
true);
4512 return actualResponse_;
4549 actualRequest_.table_name = request_.table_name;
4550 foreach (var thisObj
in request_.data) actualRequest_.list.Add( AvroEncode( thisObj ) );
4551 actualRequest_.options = request_.options;
4552 InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>(
"/insert/records", actualRequest_,
true);
4554 return actualResponse_;
4624 IDictionary<string, string> options = null )
4649 InsertRecordsRandomResponse actualResponse_ = SubmitRequest<InsertRecordsRandomResponse>(
"/insert/records/random", request_,
false);
4651 return actualResponse_;
4862 IDictionary<
string, IDictionary<string, double>> options = null )
4889 InsertSymbolResponse actualResponse_ = SubmitRequest<InsertSymbolResponse>(
"/insert/symbol", request_,
false);
4891 return actualResponse_;
4938 string symbol_format,
4940 IDictionary<string, string> options = null )
4943 symbol_data, options ) );
4957 KillProcResponse actualResponse_ = SubmitRequest<KillProcResponse>(
"/kill/proc", request_,
false);
4959 return actualResponse_;
4975 IDictionary<string, string> options = null )
5000 LockTableResponse actualResponse_ = SubmitRequest<LockTableResponse>(
"/lock/table", request_,
false);
5002 return actualResponse_;
5030 IDictionary<string, string> options = null )
5049 return actualResponse_;
5069 IDictionary<string, string> options )
5090 return actualResponse_;
5115 IDictionary<string, string> options )
5135 RevokeRoleResponse actualResponse_ = SubmitRequest<RevokeRoleResponse>(
"/revoke/role", request_,
false);
5137 return actualResponse_;
5156 IDictionary<string, string> options )
5172 ShowProcResponse actualResponse_ = SubmitRequest<ShowProcResponse>(
"/show/proc", request_,
false);
5174 return actualResponse_;
5199 IDictionary<string, string> options = null )
5219 ShowProcStatusResponse actualResponse_ = SubmitRequest<ShowProcStatusResponse>(
"/show/proc/status", request_,
false);
5221 return actualResponse_;
5253 IDictionary<string, string> options = null )
5271 ShowSecurityResponse actualResponse_ = SubmitRequest<ShowSecurityResponse>(
"/show/security", request_,
false);
5273 return actualResponse_;
5290 IDictionary<string, string> options )
5308 ShowSystemPropertiesResponse actualResponse_ = SubmitRequest<ShowSystemPropertiesResponse>(
"/show/system/properties", request_,
false);
5310 return actualResponse_;
5350 ShowSystemStatusResponse actualResponse_ = SubmitRequest<ShowSystemStatusResponse>(
"/show/system/status", request_,
false);
5352 return actualResponse_;
5384 ShowSystemTimingResponse actualResponse_ = SubmitRequest<ShowSystemTimingResponse>(
"/show/system/timing", request_,
false);
5386 return actualResponse_;
5438 ShowTableResponse actualResponse_ = SubmitRequest<ShowTableResponse>(
"/show/table", request_,
false);
5441 for (
int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
5443 SetDecoderIfMissing( actualResponse_.
type_ids[i_],
5449 return actualResponse_;
5514 IDictionary<string, string> options = null )
5531 ShowTableMetadataResponse actualResponse_ = SubmitRequest<ShowTableMetadataResponse>(
"/show/table/metadata", request_,
false);
5533 return actualResponse_;
5548 IDictionary<string, string> options = null )
5569 ShowTablesByTypeResponse actualResponse_ = SubmitRequest<ShowTablesByTypeResponse>(
"/show/tables/bytype", request_,
false);
5571 return actualResponse_;
5594 IDictionary<string, string> options = null )
5611 ShowTriggersResponse actualResponse_ = SubmitRequest<ShowTriggersResponse>(
"/show/triggers", request_,
false);
5613 return actualResponse_;
5629 IDictionary<string, string> options = null )
5650 ShowTypesResponse actualResponse_ = SubmitRequest<ShowTypesResponse>(
"/show/types", request_,
false);
5653 for (
int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
5655 SetDecoderIfMissing( actualResponse_.
type_ids[i_],
5656 actualResponse_.
labels[i_],
5661 return actualResponse_;
5683 IDictionary<string, string> options = null )
5722 UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>(
"/update/records", request_,
true);
5724 return actualResponse_;
5764 actualRequest_.table_name = request_.table_name;
5765 actualRequest_.expressions = request_.expressions;
5766 actualRequest_.new_values_maps = request_.new_values_maps;
5767 foreach (var thisObj
in request_.data) actualRequest_.records_to_insert.Add( AvroEncode( thisObj ) );
5768 actualRequest_.options = request_.options;
5769 UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>(
"/update/records", actualRequest_,
true);
5771 return actualResponse_;
5854 IList<string> expressions,
5855 IList<IDictionary<string, string>> new_values_maps,
5856 IList<T> data = null,
5857 IDictionary<string, string> options = null )
5860 new_values_maps, data,
5882 return actualResponse_;
5904 string world_table_name,
5905 string view_name =
"",
5906 IList<string> reserved = null,
5907 IDictionary<string, string> options = null )
5928 VisualizeImageResponse actualResponse_ = SubmitRequest<VisualizeImageResponse>(
"/visualize/image", request_,
false);
5930 return actualResponse_;
6044 IList<string> world_table_names,
6045 string x_column_name,
6046 string y_column_name,
6047 IList<IList<string>> track_ids,
6056 IDictionary<
string, IList<string>> style_options,
6057 IDictionary<string, string> options = null )
6062 y_column_name, track_ids,
6063 min_x, max_x, min_y, max_y,
6064 width, height, projection,
6065 bg_color, style_options,
6083 return actualResponse_;
6201 IList<string> world_table_names,
6202 string x_column_name,
6203 string y_column_name,
6204 IList<IList<string>> track_ids,
6205 string cb_column_name1,
6206 IList<string> cb_vals1,
6207 IList<string> cb_column_name2,
6208 IList<IList<string>> cb_vals2,
6217 IDictionary<
string, IList<string>> style_options,
6218 IDictionary<string, string> options = null )
6256 return actualResponse_;
6308 string x_column_name,
6309 string y_column_name,
6310 string value_column_name,
6318 IDictionary<string, string> style_options,
6319 IDictionary<string, string> options = null )
6345 VisualizeImageLabelsResponse actualResponse_ = SubmitRequest<VisualizeImageLabelsResponse>(
"/visualize/image/labels", request_,
false);
6347 return actualResponse_;
6386 string x_column_name,
6387 string y_column_name,
6400 string leader_x_column_name,
6401 string leader_y_column_name,
6409 IDictionary<string, string> options = null )
6426 leader_x_column_name,
6427 leader_y_column_name,
6481 VisualizeVideoResponse actualResponse_ = SubmitRequest<VisualizeVideoResponse>(
"/visualize/video", request_,
false);
6483 return actualResponse_;
6650 IList<string> world_table_names,
6651 IList<IList<string>> track_ids,
6652 string x_column_name,
6653 string y_column_name,
6662 IList<IList<double>> time_intervals,
6665 IDictionary<
string, IList<string>> style_options,
6666 IDictionary<string, string> options = null )
6670 track_ids, x_column_name,
6671 y_column_name, min_x, max_x,
6672 min_y, max_y, width, height,
6673 projection, bg_color,
6674 time_intervals, video_style,
6675 session_key, style_options,
6693 return actualResponse_;
6747 string x_column_name,
6748 string y_column_name,
6753 IList<IList<double>> time_intervals,
6759 IDictionary<string, string> style_options,
6760 IDictionary<string, string> options = null )
A set of parameters for /aggregate/minmax.
A set of results returned by /create/union.
A set of results returned by /grant/role.
A set of results returned by /aggregate/convexhull.
UpdateRecordsResponse updateRecords< T >(UpdateRecordsRequest< T > request_)
Runs multiple predicate-based updates in a single call.
A set of results returned by /get/records/fromcollection.
DeleteUserResponse deleteUser(string name, IDictionary< string, string > options)
Deletes an existing user.
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.
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...
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 /aggregate/kmeans.
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...
VisualizeImageClassbreakResponse visualizeImageClassbreak(IList< string > table_names, IList< string > world_table_names, string x_column_name, string y_column_name, IList< IList< string >> track_ids, string cb_column_name1, IList< string > cb_vals1, IList< string > cb_column_name2, IList< IList< string >> cb_vals2, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
A set of parameters for /get/records/byseries.
ShowProcStatusResponse showProcStatus(ShowProcStatusRequest request_)
Shows the statuses of running or completed proc instances.
A set of results returned by /admin/rebalance.
A set of results returned by /show/system/properties.
VisualizeVideoHeatmapResponse visualizeVideoHeatmap(IList< string > table_names, string x_column_name, string y_column_name, double min_x, double max_x, double min_y, double max_y, IList< IList< double >> time_intervals, int width, int height, string projection, string video_style, string session_key, IDictionary< string, string > style_options, IDictionary< string, string > options=null)
A set of results returned by /get/records/bycolumn.
A set of parameters for /visualize/video.
A set of results returned by /insert/records/random.
A set of results returned by /aggregate/groupby.
VisualizeImageResponse visualizeImage(VisualizeImageRequest request_)
A set of results returned by /grant/permission/system.
DeleteRecordsResponse deleteRecords(DeleteRecordsRequest request_)
Deletes record(s) matching the provided criteria from the given table.
AlterTableMetadataResponse alterTableMetadata(AlterTableMetadataRequest request_)
Updates (adds or changes) metadata for tables.
A set of results returned by /revoke/permission/system.
AggregateConvexHullResponse aggregateConvexHull(AggregateConvexHullRequest request_)
Calculates and returns the convex hull for the values in a table specified by .
AdminRebalanceResponse adminRebalance(IList< string > table_names, IDictionary< string, string > options=null)
A set of results returned by /visualize/image/labels.
HasTypeResponse hasType(HasTypeRequest request_)
Check for the existence of a type.
ShowTableResponse showTable(string table_name, IDictionary< string, string > options=null)
Retrieves detailed information about a table, view, or collection, specified in table_name ...
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 /create/type.
A set of parameters for /update/records/byseries.
A set of results returned by /create/user/internal.
GrantRoleResponse grantRole(string role, string member, IDictionary< string, string > options)
Grants membership in a role to a user or role.
AdminRebalanceResponse adminRebalance(AdminRebalanceRequest request_)
CreateUnionResponse createUnion(CreateUnionRequest request_)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
FilterByTableResponse filterByTable(FilterByTableRequest request_)
Filters objects in one table based on objects in another table.
A set of results returned by /create/tablemonitor.
AdminSetShardAssignmentsResponse adminSetShardAssignments(long version, bool partial_reassignment, IList< int > shard_assignments_rank, IList< int > shard_assignments_tom, IList< int > assignment_index, IDictionary< string, string > options=null)
A set of results returned by /show/system/timing.
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 /alter/system/properties.
A set of results returned by /visualize/video.
GrantRoleResponse grantRole(GrantRoleRequest request_)
Grants membership in a role to a user or role.
AdminDeleteNodeResponse adminDeleteNode(AdminDeleteNodeRequest request_)
LockTableResponse lockTable(string table_name, string lock_type=LockTableRequest.LockType.STATUS, IDictionary< string, string > options=null)
Manages global access to a table's data.
RevokePermissionTableResponse revokePermissionTable(string name, string permission, string table_name, IDictionary< string, string > options)
Revokes a table-level permission from a user or role.
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.
KillProcResponse killProc(string run_id="", IDictionary< string, string > options=null)
Kills a running proc instance.
A set of results returned by /clear/table.
A set of results returned by /clear/tablemonitor.
VisualizeImageResponse visualizeImage(IList< string > table_names, IList< string > world_table_names, string x_column_name, string y_column_name, IList< IList< string >> track_ids, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
AlterSystemPropertiesResponse alterSystemProperties(AlterSystemPropertiesRequest request_)
The Kinetica.alterSystemProperties(AlterSystemPropertiesRequest) endpoint is primarily used to simpli...
A set of parameters for /alter/table.
A set of results returned by /filter/byseries.
A set of parameters for /create/proc.
A set of parameters for /insert/records.
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.
A set of parameters for /admin/setshardassignments.
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 /insert/symbol.
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
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 results returned by /admin/getshardassignments.
A set of parameters for /aggregate/histogram.
A set of results returned by /get/records.
A set of results returned by /create/trigger/byrange.
CreateTableResponse createTable(CreateTableRequest request_)
Creates a new table or collection.
A set of parameters for /delete/records.
AggregateUniqueResponse aggregateUnique(string table_name, string column_name, long offset, long limit=10000, IDictionary< string, string > options=null)
Returns all the unique values from a particular column (specified by column_name ) of a particular ta...
A set of parameters for /lock/table.
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in <member name="table_names">.
A set of parameters for /delete/role.
A set of parameters for /show/proc/status.
A set of parameters for /visualize/video/heatmap.
A set of parameters for /aggregate/statistics/byrange.
IList< string > type_ids
Type ids of the respective tables in <member name="table_names">.
CreateRoleResponse createRole(string name, IDictionary< string, string > options)
Creates a new role.
A set of parameters for /create/tablemonitor.
A set of results returned by /aggregate/minmax.
string type_id
An identifier representing the created type.
A set of results returned by /filter/byradius.
AggregateStatisticsResponse aggregateStatistics(AggregateStatisticsRequest request_)
Calculates the requested statistics of the given column(s) in a given table.
A set of parameters for /clear/table.
A set of parameters for /create/union.
A set of results returned by /create/trigger/byarea.
A set of parameters for /show/system/timing.
A set of results returned by /get/records.
VisualizeImageLabelsResponse visualizeImageLabels(string table_name, string x_column_name, string y_column_name, string x_offset, string y_offset, string text_string, string font, string text_color, string text_angle, string text_scale, string draw_box, string draw_leader, string line_width, string line_color, string fill_color, string leader_x_column_name, string leader_y_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection=VisualizeImageLabelsRequest.Projection.PLATE_CARREE, IDictionary< string, string > options=null)
A set of results returned by /visualize/image/classbreak.
VisualizeImageHeatmapResponse visualizeImageHeatmap(IList< string > table_names, string x_column_name, string y_column_name, string value_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, IDictionary< string, string > style_options, IDictionary< string, string > options=null)
AdminShutdownResponse adminShutdown(AdminShutdownRequest request_)
Exits the database server application.
AdminGetShardAssignmentsResponse adminGetShardAssignments(AdminGetShardAssignmentsRequest request_)
ShowSecurityResponse showSecurity(ShowSecurityRequest request_)
Shows security information relating to users and/or roles.
A set of results returned by /admin/setshardassignments.
A set of results returned by /clear/trigger.
ShowTablesByTypeResponse showTablesByType(ShowTablesByTypeRequest request_)
Gets names of the tables whose type matches the given criteria.
A set of parameters for /update/records.
A set of results returned by /visualize/image.
CreateJoinTableResponse createJoinTable(CreateJoinTableRequest request_)
Creates a table that is the result of a SQL JOIN.
DeleteRoleResponse deleteRole(string name, IDictionary< string, string > options)
Deletes an existing role.
GrantPermissionSystemResponse grantPermissionSystem(GrantPermissionSystemRequest request_)
Grants a system-level permission to a user or role.
A set of parameters for /filter/byradius.
A set of results returned by /has/table.
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.
A set of parameters for /create/user/external.
DeleteProcResponse deleteProc(string proc_name, IDictionary< string, string > options=null)
Deletes a proc.
VisualizeImageLabelsResponse visualizeImageLabels(VisualizeImageLabelsRequest request_)
A set of parameters for /admin/shutdown.
A set of results returned by /filter/byvalue.
A set of results returned by /filter/bystring.
A set of parameters for /update/records.
GetRecordsBySeriesResponse< T > getRecordsBySeries< T >(GetRecordsBySeriesRequest request_)
Retrieves the complete series/track records from the given based on the partial track information co...
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.
A set of results returned by /alter/user.
A set of results returned by /update/records.
A set of parameters for /get/records/bycolumn.
A set of parameters for /revoke/permission/system.
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.
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.
CreateJoinTableResponse createJoinTable(string join_table_name, IList< string > table_names=null, IList< string > column_names=null, IList< string > expressions=null, IDictionary< string, string > options=null)
Creates a table that is the result of a SQL JOIN.
RevokeRoleResponse revokeRole(string role, string member, IDictionary< string, string > options)
Revokes membership in a role from a user or role.
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 /kill/proc.
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...
IList< string > type_schemas
A set of parameters for /show/system/properties.
A set of results returned by /create/projection.
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)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
CreateTableResponse createTable(string table_name, string type_id, IDictionary< string, string > options=null)
Creates a new table or collection.
FilterByRadiusResponse filterByRadius(FilterByRadiusRequest request_)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
A set of results returned by /update/records/byseries.
AdminGetShardAssignmentsResponse adminGetShardAssignments(IDictionary< string, string > options=null)
A set of parameters for /delete/proc.
A set of parameters for /has/proc.
A set of parameters for /filter/byseries.
A set of results returned by /admin/shutdown.
A set of parameters for /grant/permission/table.
A set of results returned by /grant/permission/table.
A set of results returned by /show/table.
A set of results returned by /aggregate/histogram.
HasProcResponse hasProc(HasProcRequest request_)
Checks the existence of a proc with the given name.
VisualizeVideoResponse visualizeVideo(IList< string > table_names, IList< string > world_table_names, IList< IList< string >> track_ids, string x_column_name, string y_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IList< IList< double >> time_intervals, string video_style, string session_key, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
Creates raster images of data in the given table based on provided input parameters.
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...
A set of results returned by /admin/delete/node.
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 /aggregate/unique.
AdminDeleteNodeResponse adminDeleteNode(int rank, string authorization, IDictionary< string, string > options=null)
A set of parameters for /show/types.
A set of parameters for /filter/byarea.
VisualizeVideoHeatmapResponse visualizeVideoHeatmap(VisualizeVideoHeatmapRequest request_)
A set of results returned by /delete/records.
AggregateGroupByResponse aggregateGroupBy(AggregateGroupByRequest request_)
Calculates unique combinations (groups) of values for the given columns in a given table/view/collect...
A set of parameters for /grant/permission/system.
GrantPermissionTableResponse grantPermissionTable(string name, string permission, string table_name, string filter_expression, IDictionary< string, string > options)
Grants a table-level permission to a user or role.
RevokeRoleResponse revokeRole(RevokeRoleRequest request_)
Revokes membership in a role from a user or role.
A set of results returned by /get/records/byseries.
CreateTableMonitorResponse createTableMonitor(CreateTableMonitorRequest request_)
Creates a monitor that watches for new records inserted into a particular table (identified by ) and ...
LockTableResponse lockTable(LockTableRequest request_)
Manages global access to a table's data.
A set of parameters for /grant/role.
A set of results returned by /delete/role.
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.
A set of parameters for /filter/bylist.
GetRecordsFromCollectionResponse< T > getRecordsFromCollection< T >(GetRecordsFromCollectionRequest request_)
Retrieves records from a collection.
A set of parameters for /filter/byvalue.
A set of results returned by /filter/bytable.
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...
A set of parameters for /create/projection.
string type_definition
Value of .
A set of parameters for /create/trigger/byrange.
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 spatial column named WKT in a given table, collection or view...
FilterByRangeResponse filterByRange(FilterByRangeRequest request_)
Calculates which objects from a table have a column that is within the given bounds.
A set of parameters for /visualize/image.
CreateTriggerByRangeResponse createTriggerByRange(CreateTriggerByRangeRequest request_)
Sets up a simple range trigger for a column_name for one or more tables.
A set of results returned by /visualize/video/heatmap.
A set of results returned by /visualize/image/heatmap.
AdminShutdownResponse adminShutdown(string exit_type, string authorization, IDictionary< string, string > options=null)
Exits the database server application.
A set of results returned by /create/role.
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 results returned by /get/records/bycolumn.
A set of parameters for /alter/user.
AlterUserResponse alterUser(string name, string action, string _value, IDictionary< string, string > options)
Alters a user.
A set of results returned by /filter/byarea.
VisualizeImageHeatmapResponse visualizeImageHeatmap(VisualizeImageHeatmapRequest request_)
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 /create/table.
CreateUserExternalResponse createUserExternal(string name, IDictionary< string, string > options)
Creates a new external user (a user whose credentials are managed by an external LDAP).
A set of parameters for /get/records.
A set of results returned by /revoke/role.
A set of results returned by /create/jointable.
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(CreateTableMonitorReq...
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 spatial column named WKT in a given table, collection or view...
A set of results returned by /show/tables/bytype.
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.
A set of parameters for /insert/symbol.
A set of results returned by /revoke/permission/table.
CreateUserInternalResponse createUserInternal(CreateUserInternalRequest request_)
Creates a new internal user (a user whose credentials are managed by the database system)...
A set of parameters for /get/records/fromcollection.
A set of parameters for /admin/rebalance.
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 /show/system/status.
CreateUserInternalResponse createUserInternal(string name, string password, IDictionary< string, string > options)
Creates a new internal user (a user whose credentials are managed by the database system)...
RevokePermissionSystemResponse revokePermissionSystem(string name, string permission, IDictionary< string, string > options)
Revokes a system-level permission from a user or role.
ShowSystemPropertiesResponse showSystemProperties(IDictionary< string, string > options=null)
Returns server configuration and version related information to the caller.
A set of results returned by /aggregate/unique.
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 /has/type.
A set of parameters for /filter/bygeometry.
ClearTriggerResponse clearTrigger(string trigger_id, IDictionary< string, string > options=null)
Clears or cancels the trigger identified by the specified handle.
AdminSetShardAssignmentsResponse adminSetShardAssignments(AdminSetShardAssignmentsRequest request_)
A set of results returned by /execute/proc.
A set of parameters for /admin/delete/node.
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 /visualize/image/heatmap.
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 /aggregate/convexhull.
A set of parameters for /show/table.
A set of results returned by /create/proc.
A set of parameters for /alter/system/properties.
ShowSystemPropertiesResponse showSystemProperties(ShowSystemPropertiesRequest request_)
Returns server configuration and version related information to the caller.
A set of parameters for /filter/byrange.
VisualizeImageClassbreakResponse visualizeImageClassbreak(VisualizeImageClassbreakRequest request_)
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 /revoke/role.
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.
A set of parameters for /show/proc.
A set of results returned by /aggregate/groupby.
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 /insert/records.
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.
AlterTableResponse alterTable(AlterTableRequest request_)
Apply various modifications to a table or collection.
A set of results returned by /show/triggers.
A set of parameters for /aggregate/kmeans.
A set of parameters for /visualize/image/labels.
A set of parameters for /visualize/image/classbreak.
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 /filter/bybox.
A set of results returned by /show/proc.
AlterTableResponse alterTable(string table_name, string action, string _value, IDictionary< string, string > options=null)
Apply various modifications to a table or collection.
A set of results returned by /create/user/external.
InsertSymbolResponse insertSymbol(InsertSymbolRequest request_)
Adds a symbol or icon (i.e.
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...
VisualizeVideoResponse visualizeVideo(VisualizeVideoRequest request_)
Creates raster images of data in the given table based on provided input parameters.
ShowTableMetadataResponse showTableMetadata(ShowTableMetadataRequest request_)
Retrieves the user provided metadata for the specified tables.
A set of results returned by /admin/verifydb.
FilterByValueResponse filterByValue(FilterByValueRequest request_)
Calculates which objects from a table has a particular value for a particular column.
A set of parameters for /show/security.
FilterByListResponse filterByList(FilterByListRequest request_)
Calculates which records from a table have values in the given list for the corresponding column...
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 /kill/proc.
A set of parameters for /filter/bystring.
A set of parameters for /filter.
A set of results returned by /has/proc.
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 /create/trigger/byarea.
IList< string > type_labels
Type labels of the respective tables in <member name="table_names">.
A set of results returned by /has/type.
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.
ShowSecurityResponse showSecurity(IList< string > names, IDictionary< string, string > options)
Shows security information relating to users and/or roles.
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 /filter/bygeometry.
UpdateRecordsResponse updateRecordsRaw(RawUpdateRecordsRequest request_)
Runs multiple predicate-based updates in a single call.
A set of results returned by /filter/byrange.
A set of parameters for /clear/tablemonitor.
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 /get/records/fromcollection.
ShowProcResponse showProc(ShowProcRequest request_)
Shows information about a proc.
A set of parameters for /delete/user.
A set of parameters for /show/tables/bytype.
A set of results returned by /show/security.
A set of results returned by /filter.
A set of results returned by /create/table.
InsertRecordsRandomResponse insertRecordsRandom(InsertRecordsRandomRequest request_)
Generates a specified number of random records and adds them to the given table.
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 (specifi...
A set of parameters for /clear/trigger.
A set of parameters for /aggregate/statistics.
ShowTypesResponse showTypes(ShowTypesRequest request_)
Retrieves information for the specified data type.
RevokePermissionSystemResponse revokePermissionSystem(RevokePermissionSystemRequest request_)
Revokes a system-level permission from a user or role.
A set of results returned by /insert/records.
A set of parameters for /insert/records/random.
A set of parameters for /admin/verifydb.
GetRecordsByColumnResponse getRecordsByColumn(GetRecordsByColumnRequest request_)
For a given table, retrieves the values of the given columns within a given range.
A set of results returned by /get/records/byseries.
A set of parameters for /filter/bytable.
A set of results returned by /aggregate/statistics/byrange.
FilterByBoxResponse filterByBox(FilterByBoxRequest request_)
Calculates how many objects within the given table lie in a rectangular box.
A set of results returned by /show/proc/status.
A set of parameters for /create/user/internal.
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 results returned by /lock/table.
A set of results returned by /aggregate/statistics.
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 /alter/table.
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 /create/jointable.
A set of parameters for /show/system/status.
A set of parameters for /execute/proc.
GrantPermissionSystemResponse grantPermissionSystem(string name, string permission, IDictionary< string, string > options)
Grants a system-level permission to a user or role.
A set of parameters for /create/role.
A set of results returned by /create/type.
A set of parameters for /aggregate/unique.
AggregateGroupByResponse aggregateGroupBy(string table_name, IList< string > column_names, long offset, long limit=1000, IDictionary< string, string > options=null)
Calculates unique combinations (groups) of values for the given columns in a given table/view/collect...
A set of results returned by /show/types.
A set of results returned by /delete/user.
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 /admin/offline.
DeleteProcResponse deleteProc(DeleteProcRequest request_)
Deletes a proc.
A set of results returned by /filter/bylist.
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 new records inserted into a particular table (identified by table_...
A set of parameters for /admin/offline.
A set of parameters for /has/table.
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 ...
GetRecordsByColumnResponse getRecordsByColumn(string table_name, IList< string > column_names, long offset, long limit, IDictionary< string, string > options=null)
For a given table, retrieves the values of the given columns within a given range.
A set of parameters for /aggregate/groupby.
A set of parameters for /admin/getshardassignments.
A set of results returned by /delete/proc.
A set of parameters for /revoke/permission/table.
A set of parameters for /filter/bybox.
A set of parameters for /show/triggers.