Kinetica C# API  Version 6.2.0.1
KineticaFunctions.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 
8 using Avro;
9 using System.Collections.Generic;
10 
11 
12 namespace kinetica
13 {
14 
15  public partial class Kinetica
16  {
17 
18  // Kinetica Version
19  public const string API_VERSION = "6.2.0.1";
20 
21 
22 
38  {
39  AdminAlterJobsResponse actualResponse_ = SubmitRequest<AdminAlterJobsResponse>("/admin/alter/jobs", request_, false);
40 
41  return actualResponse_;
42  }
43 
44 
69  public AdminAlterJobsResponse adminAlterJobs( IList<int> job_ids,
70  string action,
71  IDictionary<string, string> options = null )
72  {
73  return adminAlterJobs( new AdminAlterJobsRequest( job_ids, action, options ) );
74  }
75 
76 
88  {
89  AdminOfflineResponse actualResponse_ = SubmitRequest<AdminOfflineResponse>("/admin/offline", request_, false);
90 
91  return actualResponse_;
92  }
93 
94 
135  public AdminOfflineResponse adminOffline( bool offline,
136  IDictionary<string, string> options = null )
137  {
138  return adminOffline( new AdminOfflineRequest( offline, options ) );
139  }
140 
141 
153  {
154  AdminShowAlertsResponse actualResponse_ = SubmitRequest<AdminShowAlertsResponse>("/admin/show/alerts", request_, false);
155 
156  return actualResponse_;
157  }
158 
159 
175  public AdminShowAlertsResponse adminShowAlerts( int num_alerts,
176  IDictionary<string, string> options = null )
177  {
178  return adminShowAlerts( new AdminShowAlertsRequest( num_alerts, options ) );
179  }
180 
181 
191  {
192  AdminShowJobsResponse actualResponse_ = SubmitRequest<AdminShowJobsResponse>("/admin/show/jobs", request_, false);
193 
194  return actualResponse_;
195  }
196 
197 
224  public AdminShowJobsResponse adminShowJobs( IDictionary<string, string> options = null )
225  {
226  return adminShowJobs( new AdminShowJobsRequest( options ) );
227  }
228 
229 
242  {
243  AdminShowShardsResponse actualResponse_ = SubmitRequest<AdminShowShardsResponse>("/admin/show/shards", request_, false);
244 
245  return actualResponse_;
246  }
247 
248 
260  public AdminShowShardsResponse adminShowShards( IDictionary<string, string> options = null )
261  {
262  return adminShowShards( new AdminShowShardsRequest( options ) );
263  }
264 
265 
275  {
276  AdminShutdownResponse actualResponse_ = SubmitRequest<AdminShutdownResponse>("/admin/shutdown", request_, false);
277 
278  return actualResponse_;
279  }
280 
281 
294  public AdminShutdownResponse adminShutdown( string exit_type,
295  string authorization,
296  IDictionary<string, string> options = null )
297  {
298  return adminShutdown( new AdminShutdownRequest( exit_type, authorization,
299  options ) );
300  }
301 
302 
315  {
316  AdminVerifyDbResponse actualResponse_ = SubmitRequest<AdminVerifyDbResponse>("/admin/verifydb", request_, false);
317 
318  return actualResponse_;
319  }
320 
321 
371  public AdminVerifyDbResponse adminVerifyDb( IDictionary<string, string> options = null )
372  {
373  return adminVerifyDb( new AdminVerifyDbRequest( options ) );
374  }
375 
376 
388  {
389  AggregateConvexHullResponse actualResponse_ = SubmitRequest<AggregateConvexHullResponse>("/aggregate/convexhull", request_, false);
390 
391  return actualResponse_;
392  }
393 
394 
414  string x_column_name,
415  string y_column_name,
416  IDictionary<string, string> options = null )
417  {
418  return aggregateConvexHull( new AggregateConvexHullRequest( table_name,
419  x_column_name,
420  y_column_name,
421  options ) );
422  }
423 
424 
509  {
510  RawAggregateGroupByResponse actualResponse_ = SubmitRequest<RawAggregateGroupByResponse>("/aggregate/groupby", request_, false);
511 
513  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
514  response_.total_number_of_records = actualResponse_.total_number_of_records;
515  response_.has_more_records = actualResponse_.has_more_records;
516  return response_;
517  }
518 
519 
843  public AggregateGroupByResponse aggregateGroupBy( string table_name,
844  IList<string> column_names,
845  long offset,
846  long limit = 1000,
847  IDictionary<string, string> options = null )
848  {
849  return aggregateGroupBy( new AggregateGroupByRequest( table_name,
850  column_names, offset,
851  limit, options ) );
852  }
853 
854 
879  {
880  AggregateHistogramResponse actualResponse_ = SubmitRequest<AggregateHistogramResponse>("/aggregate/histogram", request_, false);
881 
882  return actualResponse_;
883  }
884 
885 
930  string column_name,
931  double start,
932  double end,
933  double interval,
934  IDictionary<string, string> options = null )
935  {
936  return aggregateHistogram( new AggregateHistogramRequest( table_name,
937  column_name, start,
938  end, interval,
939  options ) );
940  }
941 
942 
964  {
965  AggregateKMeansResponse actualResponse_ = SubmitRequest<AggregateKMeansResponse>("/aggregate/kmeans", request_, false);
966 
967  return actualResponse_;
968  }
969 
970 
1023  public AggregateKMeansResponse aggregateKMeans( string table_name,
1024  IList<string> column_names,
1025  int k,
1026  double tolerance,
1027  IDictionary<string, string> options = null )
1028  {
1029  return aggregateKMeans( new AggregateKMeansRequest( table_name, column_names,
1030  k, tolerance, options ) );
1031  }
1032 
1033 
1044  {
1045  AggregateMinMaxResponse actualResponse_ = SubmitRequest<AggregateMinMaxResponse>("/aggregate/minmax", request_, false);
1046 
1047  return actualResponse_;
1048  }
1049 
1050 
1064  public AggregateMinMaxResponse aggregateMinMax( string table_name,
1065  string column_name,
1066  IDictionary<string, string> options = null )
1067  {
1068  return aggregateMinMax( new AggregateMinMaxRequest( table_name, column_name,
1069  options ) );
1070  }
1071 
1072 
1084  {
1085  AggregateMinMaxGeometryResponse actualResponse_ = SubmitRequest<AggregateMinMaxGeometryResponse>("/aggregate/minmax/geometry", request_, false);
1086 
1087  return actualResponse_;
1088  }
1089 
1090 
1106  string column_name,
1107  IDictionary<string, string> options = null )
1108  {
1110  table_name,
1111  column_name,
1112  options ) );
1113  }
1114 
1115 
1169  {
1170  AggregateStatisticsResponse actualResponse_ = SubmitRequest<AggregateStatisticsResponse>("/aggregate/statistics", request_, false);
1171 
1172  return actualResponse_;
1173  }
1174 
1175 
1341  string column_name,
1342  string stats,
1343  IDictionary<string, string> options = null )
1344  {
1345  return aggregateStatistics( new AggregateStatisticsRequest( table_name,
1346  column_name,
1347  stats, options ) );
1348  }
1349 
1350 
1388  {
1389  AggregateStatisticsByRangeResponse actualResponse_ = SubmitRequest<AggregateStatisticsByRangeResponse>("/aggregate/statistics/byrange", request_, false);
1390 
1391  return actualResponse_;
1392  }
1393 
1394 
1477  string select_expression,
1478  string column_name,
1479  string value_column_name,
1480  string stats,
1481  double start,
1482  double end,
1483  double interval,
1484  IDictionary<string, string> options = null )
1485  {
1487  table_name,
1488  select_expression,
1489  column_name,
1490  value_column_name,
1491  stats,
1492  start,
1493  end,
1494  interval,
1495  options ) );
1496  }
1497 
1498 
1551  {
1552  RawAggregateUniqueResponse actualResponse_ = SubmitRequest<RawAggregateUniqueResponse>("/aggregate/unique", request_, false);
1553 
1555  response_.table_name = actualResponse_.table_name;
1556  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1557  response_.has_more_records = actualResponse_.has_more_records;
1558  return response_;
1559  }
1560 
1561 
1754  public AggregateUniqueResponse aggregateUnique( string table_name,
1755  string column_name,
1756  long offset,
1757  long limit = 10000,
1758  IDictionary<string, string> options = null )
1759  {
1760  return aggregateUnique( new AggregateUniqueRequest( table_name, column_name,
1761  offset, limit, options ) );
1762  }
1763 
1764 
1791  {
1792  RawAggregateUnpivotResponse actualResponse_ = SubmitRequest<RawAggregateUnpivotResponse>("/aggregate/unpivot", request_, false);
1793 
1795  response_.table_name = actualResponse_.table_name;
1796  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1797  response_.total_number_of_records = actualResponse_.total_number_of_records;
1798  response_.has_more_records = actualResponse_.has_more_records;
1799  return response_;
1800  }
1801 
1802 
1969  public AggregateUnpivotResponse aggregateUnpivot( string table_name,
1970  IList<string> column_names,
1971  string variable_column_name,
1972  string value_column_name,
1973  IList<string> pivoted_columns,
1974  IDictionary<string, string> options = null )
1975  {
1976  return aggregateUnpivot( new AggregateUnpivotRequest( table_name,
1977  column_names,
1978  variable_column_name,
1979  value_column_name,
1980  pivoted_columns, options ) );
1981  }
1982 
1983 
2001  {
2002  AlterSystemPropertiesResponse actualResponse_ = SubmitRequest<AlterSystemPropertiesResponse>("/alter/system/properties", request_, false);
2003 
2004  return actualResponse_;
2005  }
2006 
2007 
2197  public AlterSystemPropertiesResponse alterSystemProperties( IDictionary<string, string> property_updates_map,
2198  IDictionary<string, string> options = null )
2199  {
2201  property_updates_map,
2202  options ) );
2203  }
2204 
2205 
2257  {
2258  AlterTableResponse actualResponse_ = SubmitRequest<AlterTableResponse>("/alter/table", request_, false);
2259 
2260  return actualResponse_;
2261  }
2262 
2263 
2612  public AlterTableResponse alterTable( string table_name,
2613  string action,
2614  string _value,
2615  IDictionary<string, string> options = null )
2616  {
2617  return alterTable( new AlterTableRequest( table_name, action, _value, options ) );
2618  }
2619 
2620 
2634  {
2635  AlterTableMetadataResponse actualResponse_ = SubmitRequest<AlterTableMetadataResponse>("/alter/table/metadata", request_, false);
2636 
2637  return actualResponse_;
2638  }
2639 
2640 
2661  public AlterTableMetadataResponse alterTableMetadata( IList<string> table_names,
2662  IDictionary<string, string> metadata_map,
2663  IDictionary<string, string> options = null )
2664  {
2665  return alterTableMetadata( new AlterTableMetadataRequest( table_names,
2666  metadata_map,
2667  options ) );
2668  }
2669 
2670 
2680  {
2681  AlterUserResponse actualResponse_ = SubmitRequest<AlterUserResponse>("/alter/user", request_, false);
2682 
2683  return actualResponse_;
2684  }
2685 
2686 
2710  public AlterUserResponse alterUser( string name,
2711  string action,
2712  string _value,
2713  IDictionary<string, string> options = null )
2714  {
2715  return alterUser( new AlterUserRequest( name, action, _value, options ) );
2716  }
2717 
2718 
2735  {
2736  AppendRecordsResponse actualResponse_ = SubmitRequest<AppendRecordsResponse>("/append/records", request_, false);
2737 
2738  return actualResponse_;
2739  }
2740 
2741 
2858  public AppendRecordsResponse appendRecords( string table_name,
2859  string source_table_name,
2860  IDictionary<string, string> field_map,
2861  IDictionary<string, string> options = null )
2862  {
2863  return appendRecords( new AppendRecordsRequest( table_name, source_table_name,
2864  field_map, options ) );
2865  }
2866 
2867 
2881  {
2882  ClearTableResponse actualResponse_ = SubmitRequest<ClearTableResponse>("/clear/table", request_, false);
2883 
2884  return actualResponse_;
2885  }
2886 
2887 
2930  public ClearTableResponse clearTable( string table_name = "",
2931  string authorization = "",
2932  IDictionary<string, string> options = null )
2933  {
2934  return clearTable( new ClearTableRequest( table_name, authorization, options ) );
2935  }
2936 
2937 
2949  {
2950  ClearTableMonitorResponse actualResponse_ = SubmitRequest<ClearTableMonitorResponse>("/clear/tablemonitor", request_, false);
2951 
2952  return actualResponse_;
2953  }
2954 
2955 
2969  IDictionary<string, string> options = null )
2970  {
2971  return clearTableMonitor( new ClearTableMonitorRequest( topic_id, options ) );
2972  }
2973 
2974 
2987  {
2988  ClearTriggerResponse actualResponse_ = SubmitRequest<ClearTriggerResponse>("/clear/trigger", request_, false);
2989 
2990  return actualResponse_;
2991  }
2992 
2993 
3007  public ClearTriggerResponse clearTrigger( string trigger_id,
3008  IDictionary<string, string> options = null )
3009  {
3010  return clearTrigger( new ClearTriggerRequest( trigger_id, options ) );
3011  }
3012 
3013 
3028  {
3029  CreateJobResponse actualResponse_ = SubmitRequest<CreateJobResponse>("/create/job", request_, false);
3030 
3031  return actualResponse_;
3032  }
3033 
3034 
3086  public CreateJobResponse createJob( string endpoint,
3087  string request_encoding,
3088  byte[] data,
3089  string data_str,
3090  IDictionary<string, string> options = null )
3091  {
3092  return createJob( new CreateJobRequest( endpoint, request_encoding, data,
3093  data_str, options ) );
3094  }
3095 
3096 
3112  {
3113  CreateJoinTableResponse actualResponse_ = SubmitRequest<CreateJoinTableResponse>("/create/jointable", request_, false);
3114 
3115  return actualResponse_;
3116  }
3117 
3118 
3300  public CreateJoinTableResponse createJoinTable( string join_table_name,
3301  IList<string> table_names,
3302  IList<string> column_names,
3303  IList<string> expressions = null,
3304  IDictionary<string, string> options = null )
3305  {
3306  return createJoinTable( new CreateJoinTableRequest( join_table_name,
3307  table_names, column_names,
3308  expressions, options ) );
3309  }
3310 
3311 
3332  {
3333  CreateMaterializedViewResponse actualResponse_ = SubmitRequest<CreateMaterializedViewResponse>("/create/materializedview", request_, false);
3334 
3335  return actualResponse_;
3336  }
3337 
3338 
3452  IDictionary<string, string> options = null )
3453  {
3454  return createMaterializedView( new CreateMaterializedViewRequest( table_name,
3455  options ) );
3456  }
3457 
3458 
3472  {
3473  CreateProcResponse actualResponse_ = SubmitRequest<CreateProcResponse>("/create/proc", request_, false);
3474 
3475  return actualResponse_;
3476  }
3477 
3478 
3547  public CreateProcResponse createProc( string proc_name,
3548  string execution_mode = CreateProcRequest.ExecutionMode.DISTRIBUTED,
3549  IDictionary<string, byte[]> files = null,
3550  string command = "",
3551  IList<string> args = null,
3552  IDictionary<string, string> options = null )
3553  {
3554  return createProc( new CreateProcRequest( proc_name, execution_mode, files,
3555  command, args, options ) );
3556  }
3557 
3558 
3590  {
3591  CreateProjectionResponse actualResponse_ = SubmitRequest<CreateProjectionResponse>("/create/projection", request_, false);
3592 
3593  return actualResponse_;
3594  }
3595 
3596 
3791  public CreateProjectionResponse createProjection( string table_name,
3792  string projection_name,
3793  IList<string> column_names,
3794  IDictionary<string, string> options = null )
3795  {
3796  return createProjection( new CreateProjectionRequest( table_name,
3797  projection_name,
3798  column_names, options ) );
3799  }
3800 
3801 
3811  {
3812  CreateRoleResponse actualResponse_ = SubmitRequest<CreateRoleResponse>("/create/role", request_, false);
3813 
3814  return actualResponse_;
3815  }
3816 
3817 
3830  public CreateRoleResponse createRole( string name,
3831  IDictionary<string, string> options = null )
3832  {
3833  return createRole( new CreateRoleRequest( name, options ) );
3834  }
3835 
3836 
3858  {
3859  CreateTableResponse actualResponse_ = SubmitRequest<CreateTableResponse>("/create/table", request_, false);
3860 
3861  return actualResponse_;
3862  }
3863 
3864 
4044  public CreateTableResponse createTable( string table_name,
4045  string type_id,
4046  IDictionary<string, string> options = null )
4047  {
4048  return createTable( new CreateTableRequest( table_name, type_id, options ) );
4049  }
4050 
4051 
4073  {
4074  CreateTableMonitorResponse actualResponse_ = SubmitRequest<CreateTableMonitorResponse>("/create/tablemonitor", request_, false);
4075 
4076  return actualResponse_;
4077  }
4078 
4079 
4103  IDictionary<string, string> options = null )
4104  {
4105  return createTableMonitor( new CreateTableMonitorRequest( table_name, options ) );
4106  }
4107 
4108 
4136  {
4137  CreateTriggerByAreaResponse actualResponse_ = SubmitRequest<CreateTriggerByAreaResponse>("/create/trigger/byarea", request_, false);
4138 
4139  return actualResponse_;
4140  }
4141 
4142 
4188  IList<string> table_names,
4189  string x_column_name,
4190  IList<double> x_vector,
4191  string y_column_name,
4192  IList<double> y_vector,
4193  IDictionary<string, string> options = null )
4194  {
4195  return createTriggerByArea( new CreateTriggerByAreaRequest( request_id,
4196  table_names,
4197  x_column_name,
4198  x_vector,
4199  y_column_name,
4200  y_vector, options ) );
4201  }
4202 
4203 
4227  {
4228  CreateTriggerByRangeResponse actualResponse_ = SubmitRequest<CreateTriggerByRangeResponse>("/create/trigger/byrange", request_, false);
4229 
4230  return actualResponse_;
4231  }
4232 
4233 
4268  IList<string> table_names,
4269  string column_name,
4270  double min,
4271  double max,
4272  IDictionary<string, string> options = null )
4273  {
4274  return createTriggerByRange( new CreateTriggerByRangeRequest( request_id,
4275  table_names,
4276  column_name,
4277  min, max,
4278  options ) );
4279  }
4280 
4281 
4331  {
4332  CreateTypeResponse actualResponse_ = SubmitRequest<CreateTypeResponse>("/create/type", request_, false);
4333 
4334  SetDecoderIfMissing( actualResponse_.type_id,
4335  actualResponse_.label,
4336  actualResponse_.type_definition,
4337  actualResponse_.properties );
4338  return actualResponse_;
4339  }
4340 
4341 
4626  public CreateTypeResponse createType( string type_definition,
4627  string label,
4628  IDictionary<string, IList<string>> properties = null,
4629  IDictionary<string, string> options = null )
4630  {
4631  return createType( new CreateTypeRequest( type_definition, label, properties,
4632  options ) );
4633  }
4634 
4635 
4677  {
4678  CreateUnionResponse actualResponse_ = SubmitRequest<CreateUnionResponse>("/create/union", request_, false);
4679 
4680  return actualResponse_;
4681  }
4682 
4683 
4903  public CreateUnionResponse createUnion( string table_name,
4904  IList<string> table_names,
4905  IList<IList<string>> input_column_names,
4906  IList<string> output_column_names,
4907  IDictionary<string, string> options = null )
4908  {
4909  return createUnion( new CreateUnionRequest( table_name, table_names,
4910  input_column_names,
4911  output_column_names, options ) );
4912  }
4913 
4914 
4925  {
4926  CreateUserExternalResponse actualResponse_ = SubmitRequest<CreateUserExternalResponse>("/create/user/external", request_, false);
4927 
4928  return actualResponse_;
4929  }
4930 
4931 
4945  IDictionary<string, string> options = null )
4946  {
4947  return createUserExternal( new CreateUserExternalRequest( name, options ) );
4948  }
4949 
4950 
4961  {
4962  CreateUserInternalResponse actualResponse_ = SubmitRequest<CreateUserInternalResponse>("/create/user/internal", request_, false);
4963 
4964  return actualResponse_;
4965  }
4966 
4967 
4984  string password,
4985  IDictionary<string, string> options = null )
4986  {
4987  return createUserInternal( new CreateUserInternalRequest( name, password,
4988  options ) );
4989  }
4990 
4991 
5002  {
5003  DeleteProcResponse actualResponse_ = SubmitRequest<DeleteProcResponse>("/delete/proc", request_, false);
5004 
5005  return actualResponse_;
5006  }
5007 
5008 
5020  public DeleteProcResponse deleteProc( string proc_name,
5021  IDictionary<string, string> options = null )
5022  {
5023  return deleteProc( new DeleteProcRequest( proc_name, options ) );
5024  }
5025 
5026 
5045  {
5046  DeleteRecordsResponse actualResponse_ = SubmitRequest<DeleteRecordsResponse>("/delete/records", request_, false);
5047 
5048  return actualResponse_;
5049  }
5050 
5051 
5119  public DeleteRecordsResponse deleteRecords( string table_name,
5120  IList<string> expressions,
5121  IDictionary<string, string> options = null )
5122  {
5123  return deleteRecords( new DeleteRecordsRequest( table_name, expressions,
5124  options ) );
5125  }
5126 
5127 
5137  {
5138  DeleteRoleResponse actualResponse_ = SubmitRequest<DeleteRoleResponse>("/delete/role", request_, false);
5139 
5140  return actualResponse_;
5141  }
5142 
5143 
5154  public DeleteRoleResponse deleteRole( string name,
5155  IDictionary<string, string> options = null )
5156  {
5157  return deleteRole( new DeleteRoleRequest( name, options ) );
5158  }
5159 
5160 
5170  {
5171  DeleteUserResponse actualResponse_ = SubmitRequest<DeleteUserResponse>("/delete/user", request_, false);
5172 
5173  return actualResponse_;
5174  }
5175 
5176 
5187  public DeleteUserResponse deleteUser( string name,
5188  IDictionary<string, string> options = null )
5189  {
5190  return deleteUser( new DeleteUserRequest( name, options ) );
5191  }
5192 
5193 
5204  {
5205  ExecuteProcResponse actualResponse_ = SubmitRequest<ExecuteProcResponse>("/execute/proc", request_, false);
5206 
5207  return actualResponse_;
5208  }
5209 
5210 
5291  public ExecuteProcResponse executeProc( string proc_name,
5292  IDictionary<string, string> _params = null,
5293  IDictionary<string, byte[]> bin_params = null,
5294  IList<string> input_table_names = null,
5295  IDictionary<string, IList<string>> input_column_names = null,
5296  IList<string> output_table_names = null,
5297  IDictionary<string, string> options = null )
5298  {
5299  return executeProc( new ExecuteProcRequest( proc_name, _params, bin_params,
5300  input_table_names,
5301  input_column_names,
5302  output_table_names, options ) );
5303  }
5304 
5305 
5325  {
5326  FilterResponse actualResponse_ = SubmitRequest<FilterResponse>("/filter", request_, false);
5327 
5328  return actualResponse_;
5329  }
5330 
5331 
5387  public FilterResponse filter( string table_name,
5388  string view_name,
5389  string expression,
5390  IDictionary<string, string> options = null )
5391  {
5392  return filter( new FilterRequest( table_name, view_name, expression, options ) );
5393  }
5394 
5395 
5412  {
5413  FilterByAreaResponse actualResponse_ = SubmitRequest<FilterByAreaResponse>("/filter/byarea", request_, false);
5414 
5415  return actualResponse_;
5416  }
5417 
5418 
5462  public FilterByAreaResponse filterByArea( string table_name,
5463  string view_name,
5464  string x_column_name,
5465  IList<double> x_vector,
5466  string y_column_name,
5467  IList<double> y_vector,
5468  IDictionary<string, string> options = null )
5469  {
5470  return filterByArea( new FilterByAreaRequest( table_name, view_name,
5471  x_column_name, x_vector,
5472  y_column_name, y_vector, options ) );
5473  }
5474 
5475 
5493  {
5494  FilterByAreaGeometryResponse actualResponse_ = SubmitRequest<FilterByAreaGeometryResponse>("/filter/byarea/geometry", request_, false);
5495 
5496  return actualResponse_;
5497  }
5498 
5499 
5541  string view_name,
5542  string column_name,
5543  IList<double> x_vector,
5544  IList<double> y_vector,
5545  IDictionary<string, string> options = null )
5546  {
5547  return filterByAreaGeometry( new FilterByAreaGeometryRequest( table_name,
5548  view_name,
5549  column_name,
5550  x_vector,
5551  y_vector,
5552  options ) );
5553  }
5554 
5555 
5572  {
5573  FilterByBoxResponse actualResponse_ = SubmitRequest<FilterByBoxResponse>("/filter/bybox", request_, false);
5574 
5575  return actualResponse_;
5576  }
5577 
5578 
5626  public FilterByBoxResponse filterByBox( string table_name,
5627  string view_name,
5628  string x_column_name,
5629  double min_x,
5630  double max_x,
5631  string y_column_name,
5632  double min_y,
5633  double max_y,
5634  IDictionary<string, string> options = null )
5635  {
5636  return filterByBox( new FilterByBoxRequest( table_name, view_name,
5637  x_column_name, min_x, max_x,
5638  y_column_name, min_y, max_y,
5639  options ) );
5640  }
5641 
5642 
5659  {
5660  FilterByBoxGeometryResponse actualResponse_ = SubmitRequest<FilterByBoxGeometryResponse>("/filter/bybox/geometry", request_, false);
5661 
5662  return actualResponse_;
5663  }
5664 
5665 
5713  string view_name,
5714  string column_name,
5715  double min_x,
5716  double max_x,
5717  double min_y,
5718  double max_y,
5719  IDictionary<string, string> options = null )
5720  {
5721  return filterByBoxGeometry( new FilterByBoxGeometryRequest( table_name,
5722  view_name,
5723  column_name,
5724  min_x, max_x,
5725  min_y, max_y,
5726  options ) );
5727  }
5728 
5729 
5742  {
5743  FilterByGeometryResponse actualResponse_ = SubmitRequest<FilterByGeometryResponse>("/filter/bygeometry", request_, false);
5744 
5745  return actualResponse_;
5746  }
5747 
5748 
5837  public FilterByGeometryResponse filterByGeometry( string table_name,
5838  string view_name,
5839  string column_name,
5840  string input_wkt,
5841  string operation,
5842  IDictionary<string, string> options = null )
5843  {
5844  return filterByGeometry( new FilterByGeometryRequest( table_name, view_name,
5845  column_name, input_wkt,
5846  operation, options ) );
5847  }
5848 
5849 
5875  {
5876  FilterByListResponse actualResponse_ = SubmitRequest<FilterByListResponse>("/filter/bylist", request_, false);
5877 
5878  return actualResponse_;
5879  }
5880 
5881 
5950  public FilterByListResponse filterByList( string table_name,
5951  string view_name,
5952  IDictionary<string, IList<string>> column_values_map,
5953  IDictionary<string, string> options = null )
5954  {
5955  return filterByList( new FilterByListRequest( table_name, view_name,
5956  column_values_map, options ) );
5957  }
5958 
5959 
5981  {
5982  FilterByRadiusResponse actualResponse_ = SubmitRequest<FilterByRadiusResponse>("/filter/byradius", request_, false);
5983 
5984  return actualResponse_;
5985  }
5986 
5987 
6039  public FilterByRadiusResponse filterByRadius( string table_name,
6040  string view_name,
6041  string x_column_name,
6042  double x_center,
6043  string y_column_name,
6044  double y_center,
6045  double radius,
6046  IDictionary<string, string> options = null )
6047  {
6048  return filterByRadius( new FilterByRadiusRequest( table_name, view_name,
6049  x_column_name, x_center,
6050  y_column_name, y_center,
6051  radius, options ) );
6052  }
6053 
6054 
6072  {
6073  FilterByRadiusGeometryResponse actualResponse_ = SubmitRequest<FilterByRadiusGeometryResponse>("/filter/byradius/geometry", request_, false);
6074 
6075  return actualResponse_;
6076  }
6077 
6078 
6124  string view_name,
6125  string column_name,
6126  double x_center,
6127  double y_center,
6128  double radius,
6129  IDictionary<string, string> options = null )
6130  {
6131  return filterByRadiusGeometry( new FilterByRadiusGeometryRequest( table_name,
6132  view_name,
6133  column_name,
6134  x_center,
6135  y_center,
6136  radius,
6137  options ) );
6138  }
6139 
6140 
6163  {
6164  FilterByRangeResponse actualResponse_ = SubmitRequest<FilterByRangeResponse>("/filter/byrange", request_, false);
6165 
6166  return actualResponse_;
6167  }
6168 
6169 
6213  public FilterByRangeResponse filterByRange( string table_name,
6214  string view_name,
6215  string column_name,
6216  double lower_bound,
6217  double upper_bound,
6218  IDictionary<string, string> options = null )
6219  {
6220  return filterByRange( new FilterByRangeRequest( table_name, view_name,
6221  column_name, lower_bound,
6222  upper_bound, options ) );
6223  }
6224 
6225 
6249  {
6250  FilterBySeriesResponse actualResponse_ = SubmitRequest<FilterBySeriesResponse>("/filter/byseries", request_, false);
6251 
6252  return actualResponse_;
6253  }
6254 
6255 
6337  public FilterBySeriesResponse filterBySeries( string table_name,
6338  string view_name,
6339  string track_id,
6340  IList<string> target_track_ids,
6341  IDictionary<string, string> options = null )
6342  {
6343  return filterBySeries( new FilterBySeriesRequest( table_name, view_name,
6344  track_id, target_track_ids,
6345  options ) );
6346  }
6347 
6348 
6363  {
6364  FilterByStringResponse actualResponse_ = SubmitRequest<FilterByStringResponse>("/filter/bystring", request_, false);
6365 
6366  return actualResponse_;
6367  }
6368 
6369 
6464  public FilterByStringResponse filterByString( string table_name,
6465  string view_name,
6466  string expression,
6467  string mode,
6468  IList<string> column_names,
6469  IDictionary<string, string> options = null )
6470  {
6471  return filterByString( new FilterByStringRequest( table_name, view_name,
6472  expression, mode,
6473  column_names, options ) );
6474  }
6475 
6476 
6496  {
6497  FilterByTableResponse actualResponse_ = SubmitRequest<FilterByTableResponse>("/filter/bytable", request_, false);
6498 
6499  return actualResponse_;
6500  }
6501 
6502 
6643  public FilterByTableResponse filterByTable( string table_name,
6644  string view_name,
6645  string column_name,
6646  string source_table_name,
6647  string source_table_column_name,
6648  IDictionary<string, string> options = null )
6649  {
6650  return filterByTable( new FilterByTableRequest( table_name, view_name,
6651  column_name,
6652  source_table_name,
6653  source_table_column_name,
6654  options ) );
6655  }
6656 
6657 
6677  {
6678  FilterByValueResponse actualResponse_ = SubmitRequest<FilterByValueResponse>("/filter/byvalue", request_, false);
6679 
6680  return actualResponse_;
6681  }
6682 
6683 
6726  public FilterByValueResponse filterByValue( string table_name,
6727  string view_name,
6728  bool is_string,
6729  double _value,
6730  string value_str,
6731  string column_name,
6732  IDictionary<string, string> options = null )
6733  {
6734  return filterByValue( new FilterByValueRequest( table_name, view_name,
6735  is_string, _value, value_str,
6736  column_name, options ) );
6737  }
6738 
6739 
6748  {
6749  GetJobResponse actualResponse_ = SubmitRequest<GetJobResponse>("/get/job", request_, false);
6750 
6751  return actualResponse_;
6752  }
6753 
6754 
6764  public GetJobResponse getJob( int job_id,
6765  IDictionary<string, string> options = null )
6766  {
6767  return getJob( new GetJobRequest( job_id, options ) );
6768  }
6769 
6770 
6793  public GetRecordsResponse<T> getRecords<T>( GetRecordsRequest request_ ) where T : new()
6794  {
6795  RawGetRecordsResponse actualResponse_ = SubmitRequest<RawGetRecordsResponse>("/get/records", request_, false);
6796 
6797  GetRecordsResponse<T> response_ = new GetRecordsResponse<T>();
6798  response_.table_name = actualResponse_.table_name;
6799  response_.type_name = actualResponse_.type_name;
6800  response_.type_schema = actualResponse_.type_schema;
6801  response_.data = new List<T>();
6802  this.DecodeRawBinaryDataUsingSchemaString<T>( response_.type_schema, actualResponse_.records_binary, response_.data );
6803  response_.total_number_of_records = actualResponse_.total_number_of_records;
6804  response_.has_more_records = actualResponse_.has_more_records;
6805  return response_;
6806  }
6807 
6808 
6897  public GetRecordsResponse<T> getRecords<T>( string table_name,
6898  long offset = 0,
6899  long limit = 10000,
6900  IDictionary<string, string> options = null ) where T : new()
6901  {
6902  return getRecords<T>( new GetRecordsRequest( table_name, offset, limit,
6903  options ) );
6904  }
6905 
6906 
6937  {
6938  RawGetRecordsByColumnResponse actualResponse_ = SubmitRequest<RawGetRecordsByColumnResponse>("/get/records/bycolumn", request_, false);
6939 
6941  response_.table_name = actualResponse_.table_name;
6942  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
6943  response_.total_number_of_records = actualResponse_.total_number_of_records;
6944  response_.has_more_records = actualResponse_.has_more_records;
6945  return response_;
6946  }
6947 
6948 
7051  IList<string> column_names,
7052  long offset,
7053  long limit,
7054  IDictionary<string, string> options = null )
7055  {
7056  return getRecordsByColumn( new GetRecordsByColumnRequest( table_name,
7057  column_names,
7058  offset, limit,
7059  options ) );
7060  }
7061 
7062 
7090  {
7091  RawGetRecordsBySeriesResponse actualResponse_ = SubmitRequest<RawGetRecordsBySeriesResponse>("/get/records/byseries", request_, false);
7092 
7094  response_.table_names = actualResponse_.table_names;
7095  response_.type_names = actualResponse_.type_names;
7096  response_.type_schemas = actualResponse_.type_schemas;
7097  response_.data = new List<IList<T>>();
7098  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.list_records_binary, response_.data );
7099  return response_;
7100  }
7101 
7102 
7144  string world_table_name,
7145  int offset = 0,
7146  int limit = 250,
7147  IDictionary<string, string> options = null ) where T : new()
7148  {
7149  return getRecordsBySeries<T>( new GetRecordsBySeriesRequest( table_name,
7150  world_table_name,
7151  offset, limit,
7152  options ) );
7153  }
7154 
7155 
7178  {
7179  RawGetRecordsFromCollectionResponse actualResponse_ = SubmitRequest<RawGetRecordsFromCollectionResponse>("/get/records/fromcollection", request_, false);
7180 
7182  response_.table_name = actualResponse_.table_name;
7183  response_.type_names = actualResponse_.type_names;
7184  response_.data = new List<T>();
7185  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.records_binary, response_.data );
7186  response_.record_ids = actualResponse_.record_ids;
7187  return response_;
7188  }
7189 
7190 
7244  long offset = 0,
7245  long limit = 10000,
7246  IDictionary<string, string> options = null ) where T : new()
7247  {
7249  table_name,
7250  offset,
7251  limit,
7252  options ) );
7253  }
7254 
7255 
7266  {
7267  GrantPermissionSystemResponse actualResponse_ = SubmitRequest<GrantPermissionSystemResponse>("/grant/permission/system", request_, false);
7268 
7269  return actualResponse_;
7270  }
7271 
7272 
7306  string permission,
7307  IDictionary<string, string> options = null )
7308  {
7310  permission,
7311  options ) );
7312  }
7313 
7314 
7325  {
7326  GrantPermissionTableResponse actualResponse_ = SubmitRequest<GrantPermissionTableResponse>("/grant/permission/table", request_, false);
7327 
7328  return actualResponse_;
7329  }
7330 
7331 
7380  string permission,
7381  string table_name,
7382  string filter_expression = "",
7383  IDictionary<string, string> options = null )
7384  {
7386  permission,
7387  table_name,
7388  filter_expression,
7389  options ) );
7390  }
7391 
7392 
7402  {
7403  GrantRoleResponse actualResponse_ = SubmitRequest<GrantRoleResponse>("/grant/role", request_, false);
7404 
7405  return actualResponse_;
7406  }
7407 
7408 
7422  public GrantRoleResponse grantRole( string role,
7423  string member,
7424  IDictionary<string, string> options = null )
7425  {
7426  return grantRole( new GrantRoleRequest( role, member, options ) );
7427  }
7428 
7429 
7440  {
7441  HasProcResponse actualResponse_ = SubmitRequest<HasProcResponse>("/has/proc", request_, false);
7442 
7443  return actualResponse_;
7444  }
7445 
7446 
7458  public HasProcResponse hasProc( string proc_name,
7459  IDictionary<string, string> options = null )
7460  {
7461  return hasProc( new HasProcRequest( proc_name, options ) );
7462  }
7463 
7464 
7475  {
7476  HasTableResponse actualResponse_ = SubmitRequest<HasTableResponse>("/has/table", request_, false);
7477 
7478  return actualResponse_;
7479  }
7480 
7481 
7493  public HasTableResponse hasTable( string table_name,
7494  IDictionary<string, string> options = null )
7495  {
7496  return hasTable( new HasTableRequest( table_name, options ) );
7497  }
7498 
7499 
7509  {
7510  HasTypeResponse actualResponse_ = SubmitRequest<HasTypeResponse>("/has/type", request_, false);
7511 
7512  return actualResponse_;
7513  }
7514 
7515 
7526  public HasTypeResponse hasType( string type_id,
7527  IDictionary<string, string> options = null )
7528  {
7529  return hasType( new HasTypeRequest( type_id, options ) );
7530  }
7531 
7532 
7559  {
7560  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", request_, true);
7561 
7562  return actualResponse_;
7563  }
7564 
7565 
7594  {
7595  RawInsertRecordsRequest actualRequest_ = new RawInsertRecordsRequest();
7596  actualRequest_.table_name = request_.table_name;
7597  foreach (var thisObj in request_.data) actualRequest_.list.Add( AvroEncode( thisObj ) );
7598  actualRequest_.options = request_.options;
7599  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", actualRequest_, true);
7600 
7601  return actualResponse_;
7602  }
7603 
7604 
7687  public InsertRecordsResponse insertRecords<T>( string table_name,
7688  IList<T> data,
7689  IDictionary<string, string> options = null )
7690  {
7691  return insertRecords<T>( new InsertRecordsRequest<T>( table_name, data,
7692  options ) );
7693  }
7694 
7695 
7713  {
7714  InsertRecordsRandomResponse actualResponse_ = SubmitRequest<InsertRecordsRandomResponse>("/insert/records/random", request_, false);
7715 
7716  return actualResponse_;
7717  }
7718 
7719 
7964  long count,
7965  IDictionary<string, IDictionary<string, double>> options = null )
7966  {
7967  return insertRecordsRandom( new InsertRecordsRandomRequest( table_name, count,
7968  options ) );
7969  }
7970 
7971 
7991  {
7992  InsertSymbolResponse actualResponse_ = SubmitRequest<InsertSymbolResponse>("/insert/symbol", request_, false);
7993 
7994  return actualResponse_;
7995  }
7996 
7997 
8051  public InsertSymbolResponse insertSymbol( string symbol_id,
8052  string symbol_format,
8053  byte[] symbol_data,
8054  IDictionary<string, string> options = null )
8055  {
8056  return insertSymbol( new InsertSymbolRequest( symbol_id, symbol_format,
8057  symbol_data, options ) );
8058  }
8059 
8060 
8070  {
8071  KillProcResponse actualResponse_ = SubmitRequest<KillProcResponse>("/kill/proc", request_, false);
8072 
8073  return actualResponse_;
8074  }
8075 
8076 
8089  public KillProcResponse killProc( string run_id = "",
8090  IDictionary<string, string> options = null )
8091  {
8092  return killProc( new KillProcRequest( run_id, options ) );
8093  }
8094 
8095 
8114  {
8115  LockTableResponse actualResponse_ = SubmitRequest<LockTableResponse>("/lock/table", request_, false);
8116 
8117  return actualResponse_;
8118  }
8119 
8120 
8172  public LockTableResponse lockTable( string table_name,
8173  string lock_type = LockTableRequest.LockType.STATUS,
8174  IDictionary<string, string> options = null )
8175  {
8176  return lockTable( new LockTableRequest( table_name, lock_type, options ) );
8177  }
8178 
8179 
8210  {
8211  MergeRecordsResponse actualResponse_ = SubmitRequest<MergeRecordsResponse>("/merge/records", request_, false);
8212 
8213  return actualResponse_;
8214  }
8215 
8216 
8338  public MergeRecordsResponse mergeRecords( string table_name,
8339  IList<string> source_table_names,
8340  IList<IDictionary<string, string>> field_maps,
8341  IDictionary<string, string> options = null )
8342  {
8343  return mergeRecords( new MergeRecordsRequest( table_name, source_table_names,
8344  field_maps, options ) );
8345  }
8346 
8355  public AdminReplaceTomResponse adminReplaceTom( AdminReplaceTomRequest request_ )
8356  {
8357  AdminReplaceTomResponse actualResponse_ = SubmitRequest<AdminReplaceTomResponse>("/replace/tom", request_, false);
8358 
8359  return actualResponse_;
8360  }
8362 
8371  public AdminReplaceTomResponse adminReplaceTom( long old_rank_tom,
8372  long new_rank_tom )
8373  {
8374  return adminReplaceTom( new AdminReplaceTomRequest( old_rank_tom, new_rank_tom ) );
8375  }
8377 
8378 
8389  {
8390  RevokePermissionSystemResponse actualResponse_ = SubmitRequest<RevokePermissionSystemResponse>("/revoke/permission/system", request_, false);
8391 
8392  return actualResponse_;
8393  }
8394 
8395 
8431  string permission,
8432  IDictionary<string, string> options = null )
8433  {
8435  permission,
8436  options ) );
8437  }
8438 
8439 
8450  {
8451  RevokePermissionTableResponse actualResponse_ = SubmitRequest<RevokePermissionTableResponse>("/revoke/permission/table", request_, false);
8452 
8453  return actualResponse_;
8454  }
8455 
8456 
8504  string permission,
8505  string table_name,
8506  IDictionary<string, string> options = null )
8507  {
8509  permission,
8510  table_name,
8511  options ) );
8512  }
8513 
8514 
8525  {
8526  RevokeRoleResponse actualResponse_ = SubmitRequest<RevokeRoleResponse>("/revoke/role", request_, false);
8527 
8528  return actualResponse_;
8529  }
8530 
8531 
8546  public RevokeRoleResponse revokeRole( string role,
8547  string member,
8548  IDictionary<string, string> options = null )
8549  {
8550  return revokeRole( new RevokeRoleRequest( role, member, options ) );
8551  }
8552 
8553 
8563  {
8564  ShowProcResponse actualResponse_ = SubmitRequest<ShowProcResponse>("/show/proc", request_, false);
8565 
8566  return actualResponse_;
8567  }
8568 
8569 
8604  public ShowProcResponse showProc( string proc_name = "",
8605  IDictionary<string, string> options = null )
8606  {
8607  return showProc( new ShowProcRequest( proc_name, options ) );
8608  }
8609 
8610 
8624  {
8625  ShowProcStatusResponse actualResponse_ = SubmitRequest<ShowProcStatusResponse>("/show/proc/status", request_, false);
8626 
8627  return actualResponse_;
8628  }
8629 
8630 
8670  public ShowProcStatusResponse showProcStatus( string run_id = "",
8671  IDictionary<string, string> options = null )
8672  {
8673  return showProcStatus( new ShowProcStatusRequest( run_id, options ) );
8674  }
8675 
8676 
8688  {
8689  ShowSecurityResponse actualResponse_ = SubmitRequest<ShowSecurityResponse>("/show/security", request_, false);
8690 
8691  return actualResponse_;
8692  }
8693 
8694 
8708  public ShowSecurityResponse showSecurity( IList<string> names,
8709  IDictionary<string, string> options = null )
8710  {
8711  return showSecurity( new ShowSecurityRequest( names, options ) );
8712  }
8713 
8714 
8726  {
8727  ShowSystemPropertiesResponse actualResponse_ = SubmitRequest<ShowSystemPropertiesResponse>("/show/system/properties", request_, false);
8728 
8729  return actualResponse_;
8730  }
8731 
8732 
8752  public ShowSystemPropertiesResponse showSystemProperties( IDictionary<string, string> options = null )
8753  {
8754  return showSystemProperties( new ShowSystemPropertiesRequest( options ) );
8755  }
8756 
8757 
8769  {
8770  ShowSystemStatusResponse actualResponse_ = SubmitRequest<ShowSystemStatusResponse>("/show/system/status", request_, false);
8771 
8772  return actualResponse_;
8773  }
8774 
8775 
8786  public ShowSystemStatusResponse showSystemStatus( IDictionary<string, string> options = null )
8787  {
8788  return showSystemStatus( new ShowSystemStatusRequest( options ) );
8789  }
8790 
8791 
8803  {
8804  ShowSystemTimingResponse actualResponse_ = SubmitRequest<ShowSystemTimingResponse>("/show/system/timing", request_, false);
8805 
8806  return actualResponse_;
8807  }
8808 
8809 
8820  public ShowSystemTimingResponse showSystemTiming( IDictionary<string, string> options = null )
8821  {
8822  return showSystemTiming( new ShowSystemTimingRequest( options ) );
8823  }
8824 
8825 
8863  {
8864  ShowTableResponse actualResponse_ = SubmitRequest<ShowTableResponse>("/show/table", request_, false);
8865 
8866 
8867  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
8868  {
8869  SetDecoderIfMissing( actualResponse_.type_ids[i_],
8870  actualResponse_.type_labels[i_],
8871  actualResponse_.type_schemas[i_],
8872  actualResponse_.properties[i_] );
8873  }
8874 
8875  return actualResponse_;
8876  }
8877 
8878 
9019  public ShowTableResponse showTable( string table_name,
9020  IDictionary<string, string> options = null )
9021  {
9022  return showTable( new ShowTableRequest( table_name, options ) );
9023  }
9024 
9025 
9036  {
9037  ShowTableMetadataResponse actualResponse_ = SubmitRequest<ShowTableMetadataResponse>("/show/table/metadata", request_, false);
9038 
9039  return actualResponse_;
9040  }
9041 
9042 
9054  public ShowTableMetadataResponse showTableMetadata( IList<string> table_names,
9055  IDictionary<string, string> options = null )
9056  {
9057  return showTableMetadata( new ShowTableMetadataRequest( table_names, options ) );
9058  }
9059 
9060 
9074  {
9075  ShowTablesByTypeResponse actualResponse_ = SubmitRequest<ShowTablesByTypeResponse>("/show/tables/bytype", request_, false);
9076 
9077  return actualResponse_;
9078  }
9079 
9080 
9099  string label,
9100  IDictionary<string, string> options = null )
9101  {
9102  return showTablesByType( new ShowTablesByTypeRequest( type_id, label, options ) );
9103  }
9104 
9105 
9116  {
9117  ShowTriggersResponse actualResponse_ = SubmitRequest<ShowTriggersResponse>("/show/triggers", request_, false);
9118 
9119  return actualResponse_;
9120  }
9121 
9122 
9135  public ShowTriggersResponse showTriggers( IList<string> trigger_ids,
9136  IDictionary<string, string> options = null )
9137  {
9138  return showTriggers( new ShowTriggersRequest( trigger_ids, options ) );
9139  }
9140 
9141 
9154  {
9155  ShowTypesResponse actualResponse_ = SubmitRequest<ShowTypesResponse>("/show/types", request_, false);
9156 
9157 
9158  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
9159  {
9160  SetDecoderIfMissing( actualResponse_.type_ids[i_],
9161  actualResponse_.labels[i_],
9162  actualResponse_.type_schemas[i_],
9163  actualResponse_.properties[i_] );
9164  }
9165 
9166  return actualResponse_;
9167  }
9168 
9169 
9206  public ShowTypesResponse showTypes( string type_id,
9207  string label,
9208  IDictionary<string, string> options = null )
9209  {
9210  return showTypes( new ShowTypesRequest( type_id, label, options ) );
9211  }
9212 
9213 
9246  {
9247  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", request_, true);
9248 
9249  return actualResponse_;
9250  }
9251 
9252 
9287  {
9288  RawUpdateRecordsRequest actualRequest_ = new RawUpdateRecordsRequest();
9289  actualRequest_.table_name = request_.table_name;
9290  actualRequest_.expressions = request_.expressions;
9291  actualRequest_.new_values_maps = request_.new_values_maps;
9292  foreach (var thisObj in request_.data) actualRequest_.records_to_insert.Add( AvroEncode( thisObj ) );
9293  actualRequest_.options = request_.options;
9294  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", actualRequest_, true);
9295 
9296  return actualResponse_;
9297  }
9298 
9299 
9432  public UpdateRecordsResponse updateRecords<T>( string table_name,
9433  IList<string> expressions,
9434  IList<IDictionary<string, string>> new_values_maps,
9435  IList<T> data = null,
9436  IDictionary<string, string> options = null )
9437  {
9438  return updateRecords<T>( new UpdateRecordsRequest<T>( table_name, expressions,
9439  new_values_maps, data,
9440  options ) );
9441  }
9442 
9443 
9458  {
9459  UpdateRecordsBySeriesResponse actualResponse_ = SubmitRequest<UpdateRecordsBySeriesResponse>("/update/records/byseries", request_, false);
9460 
9461  return actualResponse_;
9462  }
9463 
9464 
9486  string world_table_name,
9487  string view_name = "",
9488  IList<string> reserved = null,
9489  IDictionary<string, string> options = null )
9490  {
9491  return updateRecordsBySeries( new UpdateRecordsBySeriesRequest( table_name,
9492  world_table_name,
9493  view_name,
9494  reserved,
9495  options ) );
9496  }
9497 
9506  public VisualizeImageResponse visualizeImage( VisualizeImageRequest request_ )
9507  {
9508  VisualizeImageResponse actualResponse_ = SubmitRequest<VisualizeImageResponse>("/visualize/image", request_, false);
9509 
9510  return actualResponse_;
9511  }
9513 
9893  public VisualizeImageResponse visualizeImage( IList<string> table_names,
9894  IList<string> world_table_names,
9895  string x_column_name,
9896  string y_column_name,
9897  string geometry_column_name,
9898  IList<IList<string>> track_ids,
9899  double min_x,
9900  double max_x,
9901  double min_y,
9902  double max_y,
9903  int width,
9904  int height,
9905  string projection,
9906  long bg_color,
9907  IDictionary<string, IList<string>> style_options,
9908  IDictionary<string, string> options = null )
9909  {
9910  return visualizeImage( new VisualizeImageRequest( table_names,
9911  world_table_names,
9912  x_column_name,
9913  y_column_name,
9914  geometry_column_name,
9915  track_ids, min_x, max_x,
9916  min_y, max_y, width, height,
9917  projection, bg_color,
9918  style_options, options ) );
9919  }
9921 
9922 
9938  {
9939  VisualizeImageChartResponse actualResponse_ = SubmitRequest<VisualizeImageChartResponse>("/visualize/image/chart", request_, false);
9940 
9941  return actualResponse_;
9942  }
9943 
9944 
10169  IList<string> x_column_names,
10170  IList<string> y_column_names,
10171  double min_x,
10172  double max_x,
10173  double min_y,
10174  double max_y,
10175  int width,
10176  int height,
10177  string bg_color,
10178  IDictionary<string, IList<string>> style_options,
10179  IDictionary<string, string> options = null )
10180  {
10181  return visualizeImageChart( new VisualizeImageChartRequest( table_name,
10182  x_column_names,
10183  y_column_names,
10184  min_x, max_x,
10185  min_y, max_y,
10186  width, height,
10187  bg_color,
10188  style_options,
10189  options ) );
10190  }
10191 
10200  public VisualizeImageClassbreakResponse visualizeImageClassbreak( VisualizeImageClassbreakRequest request_ )
10201  {
10202  VisualizeImageClassbreakResponse actualResponse_ = SubmitRequest<VisualizeImageClassbreakResponse>("/visualize/image/classbreak", request_, false);
10203 
10204  return actualResponse_;
10205  }
10207 
10582  public VisualizeImageClassbreakResponse visualizeImageClassbreak( IList<string> table_names,
10583  IList<string> world_table_names,
10584  string x_column_name,
10585  string y_column_name,
10586  string geometry_column_name,
10587  IList<IList<string>> track_ids,
10588  string cb_attr,
10589  IList<string> cb_vals,
10590  string cb_pointcolor_attr,
10591  IList<string> cb_pointcolor_vals,
10592  string cb_pointsize_attr,
10593  IList<string> cb_pointsize_vals,
10594  string cb_pointshape_attr,
10595  IList<string> cb_pointshape_vals,
10596  double min_x,
10597  double max_x,
10598  double min_y,
10599  double max_y,
10600  int width,
10601  int height,
10602  string projection,
10603  long bg_color,
10604  IDictionary<string, IList<string>> style_options,
10605  IDictionary<string, string> options = null )
10606  {
10607  return visualizeImageClassbreak( new VisualizeImageClassbreakRequest(
10608  table_names,
10609  world_table_names,
10610  x_column_name,
10611  y_column_name,
10612  geometry_column_name,
10613  track_ids,
10614  cb_attr,
10615  cb_vals,
10616  cb_pointcolor_attr,
10617  cb_pointcolor_vals,
10618  cb_pointsize_attr,
10619  cb_pointsize_vals,
10620  cb_pointshape_attr,
10621  cb_pointshape_vals,
10622  min_x,
10623  max_x,
10624  min_y,
10625  max_y,
10626  width,
10627  height,
10628  projection,
10629  bg_color,
10630  style_options,
10631  options ) );
10632  }
10634 
10643  public VisualizeImageContourResponse visualizeImageContour( VisualizeImageContourRequest request_ )
10644  {
10645  VisualizeImageContourResponse actualResponse_ = SubmitRequest<VisualizeImageContourResponse>("/visualize/image/contour", request_, false);
10646 
10647  return actualResponse_;
10648  }
10650 
11190  public VisualizeImageContourResponse visualizeImageContour( IList<string> table_names,
11191  string x_column_name,
11192  string y_column_name,
11193  string value_column_name,
11194  double min_x,
11195  double max_x,
11196  double min_y,
11197  double max_y,
11198  int width,
11199  int height,
11200  string projection,
11201  IDictionary<string, string> style_options,
11202  IDictionary<string, string> options = null )
11203  {
11204  return visualizeImageContour( new VisualizeImageContourRequest( table_names,
11205  x_column_name,
11206  y_column_name,
11207  value_column_name,
11208  min_x, max_x,
11209  min_y, max_y,
11210  width, height,
11211  projection,
11212  style_options,
11213  options ) );
11214  }
11216 
11225  public VisualizeImageHeatmapResponse visualizeImageHeatmap( VisualizeImageHeatmapRequest request_ )
11226  {
11227  VisualizeImageHeatmapResponse actualResponse_ = SubmitRequest<VisualizeImageHeatmapResponse>("/visualize/image/heatmap", request_, false);
11228 
11229  return actualResponse_;
11230  }
11232 
11627  public VisualizeImageHeatmapResponse visualizeImageHeatmap( IList<string> table_names,
11628  string x_column_name,
11629  string y_column_name,
11630  string value_column_name,
11631  string geometry_column_name,
11632  double min_x,
11633  double max_x,
11634  double min_y,
11635  double max_y,
11636  int width,
11637  int height,
11638  string projection,
11639  IDictionary<string, string> style_options,
11640  IDictionary<string, string> options = null )
11641  {
11642  return visualizeImageHeatmap( new VisualizeImageHeatmapRequest( table_names,
11643  x_column_name,
11644  y_column_name,
11645  value_column_name,
11646  geometry_column_name,
11647  min_x, max_x,
11648  min_y, max_y,
11649  width, height,
11650  projection,
11651  style_options,
11652  options ) );
11653  }
11655 
11664  public VisualizeImageLabelsResponse visualizeImageLabels( VisualizeImageLabelsRequest request_ )
11665  {
11666  VisualizeImageLabelsResponse actualResponse_ = SubmitRequest<VisualizeImageLabelsResponse>("/visualize/image/labels", request_, false);
11667 
11668  return actualResponse_;
11669  }
11671 
11745  public VisualizeImageLabelsResponse visualizeImageLabels( string table_name,
11746  string x_column_name,
11747  string y_column_name,
11748  string x_offset,
11749  string y_offset,
11750  string text_string,
11751  string font,
11752  string text_color,
11753  string text_angle,
11754  string text_scale,
11755  string draw_box,
11756  string draw_leader,
11757  string line_width,
11758  string line_color,
11759  string fill_color,
11760  string leader_x_column_name,
11761  string leader_y_column_name,
11762  string filter,
11763  double min_x,
11764  double max_x,
11765  double min_y,
11766  double max_y,
11767  int width,
11768  int height,
11769  string projection = VisualizeImageLabelsRequest.Projection.PLATE_CARREE,
11770  IDictionary<string, string> options = null )
11771  {
11772  return visualizeImageLabels( new VisualizeImageLabelsRequest( table_name,
11773  x_column_name,
11774  y_column_name,
11775  x_offset,
11776  y_offset,
11777  text_string,
11778  font,
11779  text_color,
11780  text_angle,
11781  text_scale,
11782  draw_box,
11783  draw_leader,
11784  line_width,
11785  line_color,
11786  fill_color,
11787  leader_x_column_name,
11788  leader_y_column_name,
11789  filter, min_x,
11790  max_x, min_y,
11791  max_y, width,
11792  height,
11793  projection,
11794  options ) );
11795  }
11797 
11806  public VisualizeVideoResponse visualizeVideo( VisualizeVideoRequest request_ )
11807  {
11808  VisualizeVideoResponse actualResponse_ = SubmitRequest<VisualizeVideoResponse>("/visualize/video", request_, false);
11809 
11810  return actualResponse_;
11811  }
11813 
12117  public VisualizeVideoResponse visualizeVideo( IList<string> table_names,
12118  IList<string> world_table_names,
12119  IList<IList<string>> track_ids,
12120  string x_column_name,
12121  string y_column_name,
12122  string geometry_column_name,
12123  double min_x,
12124  double max_x,
12125  double min_y,
12126  double max_y,
12127  int width,
12128  int height,
12129  string projection,
12130  long bg_color,
12131  IList<IList<double>> time_intervals,
12132  string video_style,
12133  string session_key,
12134  IDictionary<string, IList<string>> style_options,
12135  IDictionary<string, string> options = null )
12136  {
12137  return visualizeVideo( new VisualizeVideoRequest( table_names,
12138  world_table_names,
12139  track_ids, x_column_name,
12140  y_column_name,
12141  geometry_column_name, min_x,
12142  max_x, min_y, max_y, width,
12143  height, projection,
12144  bg_color, time_intervals,
12145  video_style, session_key,
12146  style_options, options ) );
12147  }
12149 
12158  public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( VisualizeVideoHeatmapRequest request_ )
12159  {
12160  VisualizeVideoHeatmapResponse actualResponse_ = SubmitRequest<VisualizeVideoHeatmapResponse>("/visualize/video/heatmap", request_, false);
12161 
12162  return actualResponse_;
12163  }
12165 
12302  public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( IList<string> table_names,
12303  string x_column_name,
12304  string y_column_name,
12305  double min_x,
12306  double max_x,
12307  double min_y,
12308  double max_y,
12309  IList<IList<double>> time_intervals,
12310  int width,
12311  int height,
12312  string projection,
12313  string video_style,
12314  string session_key,
12315  IDictionary<string, string> style_options,
12316  IDictionary<string, string> options = null )
12317  {
12318  return visualizeVideoHeatmap( new VisualizeVideoHeatmapRequest( table_names,
12319  x_column_name,
12320  y_column_name,
12321  min_x, max_x,
12322  min_y, max_y,
12323  time_intervals,
12324  width, height,
12325  projection,
12326  video_style,
12327  session_key,
12328  style_options,
12329  options ) );
12330  }
12332 
12333 
12334  } // end class Kinetica
12335 } // end namespace kinetica
12336 
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>).
Definition: CreateUnion.cs:823
A set of results returned by Kinetica.grantRole(string,string,IDictionary<string, string>)...
Definition: GrantRole.cs:67
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.
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...
byte [] binary_encoded_response
Avro binary encoded response.
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.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>).
IList< string > type_ids
Definition: ShowTypes.cs:160
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.
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 .
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 tables, views, and collections.
string table_name
Table to which the records are to be added.
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>).
Definition: CreateType.cs:58
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.updateRecords<T>(string,IList<string>,IList<IDictionary<string, string>>,IList<T>,IDictionary<string, string>).
bool has_more_records
Too many records. Returned a partial set.
A set of results returned by Kinetica.createUserInternal(string,string,IDictionary<string, string>).
IList< byte[]> records_binary
If the was &#39;binary&#39;, then this list contains the binary encoded records retrieved from the table...
Definition: GetRecords.cs:489
IList< string > expressions
A list of the actual predicates, one for each update; format should follow the guidelines /filter...
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.
long total_number_of_records
Total/Filtered number of records.
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 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 .
Definition: CreateType.cs:1009
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.
LockTableResponse lockTable(string table_name, string lock_type=LockTableRequest.LockType.STATUS, IDictionary< string, string > options=null)
Manages global access to a table&#39;s data.
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>).
Definition: ClearTable.cs:174
A set of results returned by Kinetica.clearTableMonitor(string,IDictionary<string, string>).
A set of results returned by Kinetica.showTableMetadata(IList<string>,IDictionary<string, string>).
bool has_more_records
Too many records. Returned a partial set.
AdminShowShardsResponse adminShowShards(AdminShowShardsRequest request_)
Show the mapping of shards to the corresponding rank and tom.
IList< string > type_names
The type IDs (one per series/track) of the returned series/tracks.
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 parameters for Kinetica.alterTable(string,string,string,IDictionary<string, string>).
Definition: AlterTable.cs:58
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>).
Definition: CreateProc.cs:22
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.
IList< string > record_ids
If the &#39;return_record_ids&#39; option of the request was &#39;true&#39;, then this list contains the internal ID ...
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
Definition: ShowTypes.cs:163
KillProcResponse killProc(KillProcRequest request_)
Kills a running proc instance.
IList< string > type_schemas
Type schemas of the respective tables in <member name="table_names">.
Definition: ShowTable.cs:840
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.getRecords<T>(string,long,long,IDictionary<string, string>).
Definition: GetRecords.cs:474
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.
string response_schema_str
Avro schema of <member name="binary_encoded_response"> or <member name="json_encoded_response">.
A set of parameters for Kinetica.deleteRecords(string,IList<string>,IDictionary<string, string>).
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 Kinetica.lockTable(string,string,IDictionary<string, string>).
Definition: LockTable.cs:26
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in <member name="table_names">.
Definition: ShowTable.cs:848
A set of parameters for Kinetica.deleteRole(string,IDictionary<string, string>).
Definition: DeleteRole.cs:18
A set of parameters for Kinetica.showProcStatus(string,IDictionary<string, string>).
A set of parameters for Kinetica.aggregateStatisticsByRange(string,string,string,string,string,double,double,double,IDictionary<string, string>).
IList< string > type_names
The type IDs of the corresponding records in <member name="records_binary"> or <member name="records_...
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">.
Definition: ShowTable.cs:836
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.
Definition: CreateType.cs:997
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>).
Definition: ClearTable.cs:22
A set of parameters for Kinetica.createUnion(string,IList<string>,IList<IList<string>>,IList<string>,IDictionary<string, string>).
Definition: CreateUnion.cs:48
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.adminShowJobs(IDictionary<string, string>). ...
AdminShutdownResponse adminShutdown(AdminShutdownRequest request_)
Exits the database server application.
A set of results returned by Kinetica.aggregateUnpivot(string,IList<string>,string,string,IList<string>,IDictionary<string, string>).
bool has_more_records
Too many records. Returned a partial set.
string table_name
Value of .
Definition: GetRecords.cs:520
ShowSecurityResponse showSecurity(ShowSecurityRequest request_)
Shows security information relating to users and/or roles.
A set of results returned by Kinetica.clearTrigger(string,IDictionary<string, string>).
Definition: ClearTrigger.cs:57
ShowTablesByTypeResponse showTablesByType(ShowTablesByTypeRequest request_)
Gets names of the tables whose type matches the given criteria.
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...
GrantPermissionSystemResponse grantPermissionSystem(GrantPermissionSystemRequest request_)
Grants a system-level permission to a user or role.
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>).
Definition: HasTable.cs:55
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 parameters for Kinetica.createUserExternal(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...
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.
CreateMaterializedViewResponse createMaterializedView(CreateMaterializedViewRequest request_)
Initiates the process of creating a materialized view, reserving the view&#39;s name to prevent other vie...
GetJobResponse getJob(int job_id, IDictionary< string, string > options=null)
A unique identifier for the job whose status and result is to be fetched.
A set of results returned by Kinetica.alterUser(string,string,string,IDictionary<string, string>).
Definition: AlterUser.cs:111
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...
Convenience class for using Avro.Generic.GenericRecord objects.
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.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.
A set of parameters for Kinetica.adminAlterJobs(IList<int>,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.
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>).
Definition: KillProc.cs:60
A set of results returned by Kinetica.adminAlterJobs(IList<int>,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...
IList< string > type_schemas
Definition: ShowTypes.cs:161
A set of parameters for Kinetica.showSystemProperties(IDictionary<string, string>).
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)...
AdminShowShardsResponse adminShowShards(IDictionary< string, string > options=null)
Show the mapping of shards to the corresponding rank and tom.
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&#39;s name to prevent other vie...
FilterByRadiusResponse filterByRadius(FilterByRadiusRequest request_)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
void DecodeRawBinaryDataUsingTypeIDs< T >(IList< string > type_ids, IList< byte[]> records_binary, IList< T > records)
Given IDs of records types registered with Kinetica, decode binary data into distinct records (object...
Definition: Kinetica.cs:285
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 parameters for Kinetica.deleteProc(string,IDictionary<string, string>).
Definition: DeleteProc.cs:19
IList< IList< byte[]> > list_records_binary
If the encoding parameter of the request was &#39;binary&#39; then this list-of-lists contains the binary enc...
A set of parameters for Kinetica.hasProc(string,IDictionary<string, string>).
Definition: HasProc.cs:18
long total_number_of_records
Total/Filtered number of records.
Definition: GetRecords.cs:500
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>).
Definition: MergeRecords.cs:35
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>).
Definition: ShowTable.cs:497
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.
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...
long total_number_of_records
Total/Filtered number of records.
byte [] binary_encoded_response
Avro binary encoded response.
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>).
Definition: ShowTypes.cs:22
A set of parameters for Kinetica.filterByArea(string,string,string,IList<double>,string,IList<double>,IDictionary<string, string>).
Definition: FilterByArea.cs:25
A set of results returned by Kinetica.deleteRecords(string,IList<string>,IDictionary<string, string>).
byte [] binary_encoded_response
Avro binary encoded response.
A set of parameters for Kinetica.showTableMetadata(IList<string>,IDictionary<string, string>).
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 Kinetica.grantPermissionSystem(string,string,IDictionary<string, string>).
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>).
IList< string > labels
Definition: ShowTypes.cs:162
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&#39;s data.
A set of parameters for Kinetica.grantRole(string,string,IDictionary<string, string>).
Definition: GrantRole.cs:19
A set of results returned by Kinetica.deleteRole(string,IDictionary<string, string>).
Definition: DeleteRole.cs:56
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.
A set of parameters for Kinetica.alterTableMetadata(IList<string>,IDictionary<string, string>,IDictionary<string, string>).
A set of parameters for Kinetica.filterByList(string,string,IDictionary<string, IList<string>>,IDictionary<string, string>).
Definition: FilterByList.cs:34
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_)
Request object containing the parameters for the operation.
A set of parameters for Kinetica.createProjection(string,string,IList<string>,IDictionary<string, string>).
string type_definition
Value of .
Definition: CreateType.cs:1001
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>).
Definition: CreateJob.cs:171
FilterByRangeResponse filterByRange(FilterByRangeRequest request_)
Calculates which objects from a table have a column that is within the given bounds.
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)
Retrieves a list of the most recent alerts generated.
A set of parameters for Kinetica.insertRecords<T>(string,IList<T>,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>).
Definition: CreateRole.cs:60
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>).
Definition: AlterUser.cs:19
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.createTable(string,string,IDictionary<string, string>).
Definition: CreateTable.cs:29
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>).
Definition: GetRecords.cs:30
const string API_VERSION
IList< IDictionary< string, string > > new_values_maps
List of new values for the matching records.
A set of results returned by Kinetica.revokeRole(string,string,IDictionary<string, string>).
Definition: RevokeRole.cs:67
A set of results returned by Kinetica.createJoinTable(string,IList<string>,IList<string>,IList<string>,IDictionary<string, string>).
IList< byte[]> records_binary
If the encoding parameter of the request was &#39;binary&#39; then this list contains the binary encoded reco...
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>).
void DecodeRawBinaryDataUsingSchemaString< T >(string schema_string, IList< byte[]> records_binary, IList< T > records)
Given a schema string for a certain record type, decode binary data into distinct records (objects)...
Definition: Kinetica.cs:221
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>).
Definition: InsertSymbol.cs:28
const string DISTRIBUTED
Input table data will be divided into data segments that are distributed across all nodes in the clus...
Definition: CreateProc.cs:57
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>).
ClearTableResponse clearTable(ClearTableRequest request_)
Clears (drops) one or all tables in the database cluster.
long total_number_of_records
Total/Filtered number of records.
ShowTableResponse showTable(ShowTableRequest request_)
Retrieves detailed information about tables, views, and collections.
string type_schema
Avro schema of <member name="records_binary"> or <member name="records_json">
Definition: GetRecords.cs:484
bool has_more_records
Too many records. Returned a partial set.
A set of results returned by Kinetica.showSystemStatus(IDictionary<string, string>).
IList< string > table_names
The table name (one per series/track) of the returned series/tracks.
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>).
Definition: HasType.cs:18
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>).
Definition: ExecuteProc.cs:296
FilterByBoxGeometryResponse filterByBoxGeometry(FilterByBoxGeometryRequest request_)
Calculates which geospatial geometry objects from a table intersect a rectangular box...
byte [] binary_encoded_response
Avro binary encoded response.
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).
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>).
A set of parameters for Kinetica.showTable(string,IDictionary<string, string>).
Definition: ShowTable.cs:40
A set of results returned by Kinetica.createProc(string,string,IDictionary<string, byte[]>,string,IList<string>,IDictionary<string, string>).
Definition: CreateProc.cs:247
A set of parameters for Kinetica.alterSystemProperties(IDictionary<string, string>,IDictionary<string, string>).
ShowSystemPropertiesResponse showSystemProperties(ShowSystemPropertiesRequest request_)
Returns server configuration and version related information to the caller.
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>).
Definition: RevokeRole.cs:19
bool has_more_records
Too many records. Returned a partial set.
Definition: GetRecords.cs:503
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>).
Definition: ShowProc.cs:18
A set of results returned by Kinetica.aggregateGroupBy(string,IList<string>,long,long,IDictionary<string, string>).
string table_name
Typically shows the result-table name if provided in the request (Ignore otherwise).
ExecuteProcResponse executeProc(ExecuteProcRequest request_)
Executes a proc.
A set of results returned by Kinetica.getRecordsFromCollection<T>(string,long,long,IDictionary<string, string>).
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>).
string response_schema_str
Avro schema of <member name="binary_encoded_response"> or <member name="json_encoded_response">.
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>).
Definition: ShowTriggers.cs:60
A set of parameters for Kinetica.aggregateKMeans(string,IList<string>,int,double,IDictionary<string, string>).
A set of parameters for Kinetica.createJob(string,string,byte[],string,IDictionary<string, string>).
Definition: CreateJob.cs:23
string table_name
Value of .
Definition: GetRecords.cs:479
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>).
The type of lock being applied to the table.
Definition: LockTable.cs:64
A set of results returned by Kinetica.filterByBox(string,string,string,double,double,string,double,double,IDictionary<string, string>).
Definition: FilterByBox.cs:178
A set of results returned by Kinetica.showProc(string,IDictionary<string, string>).
Definition: ShowProc.cs:155
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>).
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.
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>). ...
const string STATUS
Show locked status
Definition: LockTable.cs:68
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(int,IDictionary<string, string>).
Definition: GetJob.cs:55
GrantPermissionSystemResponse grantPermissionSystem(string name, string permission, IDictionary< string, string > options=null)
Grants a system-level permission to a user or role.
string table_name
The same table name as was passed in the parameter list.
A set of parameters for Kinetica.showSecurity(IList<string>,IDictionary<string, string>).
Definition: ShowSecurity.cs:21
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.
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>).
Definition: KillProc.cs:18
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>).
Definition: Filter.cs:28
A set of results returned by Kinetica.hasProc(string,IDictionary<string, string>).
Definition: HasProc.cs:55
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.aggregateMinMaxGeometry(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">.
Definition: ShowTable.cs:844
A set of results returned by Kinetica.hasType(string,IDictionary<string, string>).
Definition: HasType.cs:56
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.
string table_name
Table to be updated.
AdminAlterJobsResponse adminAlterJobs(IList< int > job_ids, string action, IDictionary< string, string > options=null)
Perform the requested action on a list of one or more job(s).
VisualizeImageChartResponse visualizeImageChart(VisualizeImageChartRequest request_)
Scatter plot is the only plot type currently supported.
CreateRoleResponse createRole(CreateRoleRequest request_)
Creates a new role.
string table_name
The same table name as was passed in the parameter list.
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>).
UpdateRecordsResponse updateRecordsRaw(RawUpdateRecordsRequest request_)
Runs multiple predicate-based updates in a single call.
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>).
static IList< KineticaRecord > DecodeDynamicTableRecords(string dynamic_table_schema_string, byte[] encoded_data)
Decodes binary encoded data of a dynamically created table returned by the server.
ShowProcResponse showProc(ShowProcRequest request_)
Shows information about a proc.
A set of parameters for Kinetica.deleteUser(string,IDictionary<string, string>).
Definition: DeleteUser.cs:18
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>).
Definition: ShowSecurity.cs:61
A set of results returned by Kinetica.filter(string,string,string,IDictionary<string, string>).
Definition: Filter.cs:190
A set of results returned by Kinetica.createTable(string,string,IDictionary<string, string>).
Definition: CreateTable.cs:677
AdminShowAlertsResponse adminShowAlerts(AdminShowAlertsRequest request_)
Retrieves a list of the most recent alerts generated.
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 or colle...
string label
Value of .
Definition: CreateType.cs:1005
A set of parameters for Kinetica.clearTrigger(string,IDictionary<string, string>).
Definition: ClearTrigger.cs:20
A set of parameters for Kinetica.aggregateStatistics(string,string,string,IDictionary<string, string>).
IList< string > table_names
The table name (one per series/track) of the returned series/tracks.
ShowTypesResponse showTypes(ShowTypesRequest request_)
Retrieves information for the specified data type ID or type label.
RevokePermissionSystemResponse revokePermissionSystem(RevokePermissionSystemRequest request_)
Revokes a system-level permission from a user or 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.adminVerifyDb(IDictionary<string, string>).
IList< string > type_schemas
The type schemas (one per series/track) of the returned series/tracks.
GetRecordsByColumnResponse getRecordsByColumn(GetRecordsByColumnRequest request_)
For a given table, retrieves the values from the requested column(s).
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.showProcStatus(string,IDictionary<string, string>).
A set of parameters for Kinetica.createUserInternal(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 results returned by Kinetica.lockTable(string,string,IDictionary<string, string>)...
Definition: LockTable.cs:189
A set of results returned by Kinetica.aggregateStatistics(string,string,string,IDictionary<string, string>).
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>).
Definition: AlterTable.cs:1228
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(int,IDictionary<string, string>).
Definition: GetJob.cs:18
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>).
Definition: ExecuteProc.cs:20
ShowSecurityResponse showSecurity(IList< string > names, IDictionary< string, string > options=null)
Shows security information relating to users and/or roles.
A set of results returned by Kinetica.alterTableMetadata(IList<string>,IDictionary<string, string>,IDictionary<string, string>).
string response_schema_str
Avro schema of <member name="binary_encoded_response"> or <member name="json_encoded_response">.
A set of results returned by Kinetica.getRecordsBySeries<T>(string,string,int,int,IDictionary<string, string>).
A set of parameters for Kinetica.createRole(string,IDictionary<string, string>).
Definition: CreateRole.cs:18
A set of parameters for Kinetica.adminShowJobs(IDictionary<string, string>).
The execution mode of the proc.
Definition: CreateProc.cs:49
A set of results returned by Kinetica.createType(string,string,IDictionary<string, IList<string>>,IDictionary<string, string>).
Definition: CreateType.cs:992
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>).
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 Kinetica.showTypes(string,string,IDictionary<string, string>)...
Definition: ShowTypes.cs:158
A set of results returned by Kinetica.deleteUser(string,IDictionary<string, string>).
Definition: DeleteUser.cs:56
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 new records inserted into a particular table (identified by table_...
A set of results returned by Kinetica.getRecords<T>(string,long,long,IDictionary<string, string>).
Definition: GetRecords.cs:515
A set of parameters for Kinetica.adminOffline(bool,IDictionary<string, string>).
Definition: AdminOffline.cs:19
string response_schema_str
Avro schema of <member name="binary_encoded_response"> or <member name="json_encoded_response">.
A set of results returned by Kinetica.aggregateMinMaxGeometry(string,string,IDictionary<string, string>).
A set of parameters for Kinetica.hasTable(string,IDictionary<string, string>).
Definition: HasTable.cs:18
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 from the requested column(s).
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>).
Definition: DeleteProc.cs:57
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>).
Definition: FilterByBox.cs:25
A set of parameters for Kinetica.showTriggers(IList<string>,IDictionary<string, string>).
Definition: ShowTriggers.cs:20