Kinetica C# API  Version 6.1.0.0
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.1.0.0";
20 
21 
22 
33  {
34  AdminAlterConfigurationResponse actualResponse_ = SubmitRequest<AdminAlterConfigurationResponse>("/admin/alter/configuration", request_, false);
35 
36  return actualResponse_;
37  }
38 
39 
51  IDictionary<string, string> options = null )
52  {
54  config_string,
55  options ) );
56  }
57 
58 
74  {
75  AdminAlterJobsResponse actualResponse_ = SubmitRequest<AdminAlterJobsResponse>("/admin/alter/jobs", request_, false);
76 
77  return actualResponse_;
78  }
79 
80 
104  public AdminAlterJobsResponse adminAlterJobs( IList<int> job_ids,
105  string action,
106  IDictionary<string, string> options = null )
107  {
108  return adminAlterJobs( new AdminAlterJobsRequest( job_ids, action, options ) );
109  }
110 
111 
123  {
124  AdminOfflineResponse actualResponse_ = SubmitRequest<AdminOfflineResponse>("/admin/offline", request_, false);
125 
126  return actualResponse_;
127  }
128 
129 
170  public AdminOfflineResponse adminOffline( bool offline,
171  IDictionary<string, string> options = null )
172  {
173  return adminOffline( new AdminOfflineRequest( offline, options ) );
174  }
175 
176 
186  {
187  AdminShowConfigurationResponse actualResponse_ = SubmitRequest<AdminShowConfigurationResponse>("/admin/show/configuration", request_, false);
188 
189  return actualResponse_;
190  }
191 
192 
200  public AdminShowConfigurationResponse adminShowConfiguration( IDictionary<string, string> options = null )
201  {
202  return adminShowConfiguration( new AdminShowConfigurationRequest( options ) );
203  }
204 
205 
215  {
216  AdminShowJobsResponse actualResponse_ = SubmitRequest<AdminShowJobsResponse>("/admin/show/jobs", request_, false);
217 
218  return actualResponse_;
219  }
220 
221 
248  public AdminShowJobsResponse adminShowJobs( IDictionary<string, string> options = null )
249  {
250  return adminShowJobs( new AdminShowJobsRequest( options ) );
251  }
252 
253 
266  {
267  AdminShowShardsResponse actualResponse_ = SubmitRequest<AdminShowShardsResponse>("/admin/show/shards", request_, false);
268 
269  return actualResponse_;
270  }
271 
272 
283  public AdminShowShardsResponse adminShowShards( IDictionary<string, string> options = null )
284  {
285  return adminShowShards( new AdminShowShardsRequest( options ) );
286  }
287 
288 
298  {
299  AdminShutdownResponse actualResponse_ = SubmitRequest<AdminShutdownResponse>("/admin/shutdown", request_, false);
300 
301  return actualResponse_;
302  }
303 
304 
316  public AdminShutdownResponse adminShutdown( string exit_type,
317  string authorization,
318  IDictionary<string, string> options = null )
319  {
320  return adminShutdown( new AdminShutdownRequest( exit_type, authorization,
321  options ) );
322  }
323 
324 
337  {
338  AdminVerifyDbResponse actualResponse_ = SubmitRequest<AdminVerifyDbResponse>("/admin/verifydb", request_, false);
339 
340  return actualResponse_;
341  }
342 
343 
393  public AdminVerifyDbResponse adminVerifyDb( IDictionary<string, string> options = null )
394  {
395  return adminVerifyDb( new AdminVerifyDbRequest( options ) );
396  }
397 
398 
410  {
411  AggregateConvexHullResponse actualResponse_ = SubmitRequest<AggregateConvexHullResponse>("/aggregate/convexhull", request_, false);
412 
413  return actualResponse_;
414  }
415 
416 
435  string x_column_name,
436  string y_column_name,
437  IDictionary<string, string> options = null )
438  {
439  return aggregateConvexHull( new AggregateConvexHullRequest( table_name,
440  x_column_name,
441  y_column_name,
442  options ) );
443  }
444 
445 
508  {
509  RawAggregateGroupByResponse actualResponse_ = SubmitRequest<RawAggregateGroupByResponse>("/aggregate/groupby", request_, false);
510 
512  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
513  response_.total_number_of_records = actualResponse_.total_number_of_records;
514  response_.has_more_records = actualResponse_.has_more_records;
515  return response_;
516  }
517 
518 
747  public AggregateGroupByResponse aggregateGroupBy( string table_name,
748  IList<string> column_names,
749  long offset,
750  long limit = 1000,
751  IDictionary<string, string> options = null )
752  {
753  return aggregateGroupBy( new AggregateGroupByRequest( table_name,
754  column_names, offset,
755  limit, options ) );
756  }
757 
758 
779  {
780  AggregateHistogramResponse actualResponse_ = SubmitRequest<AggregateHistogramResponse>("/aggregate/histogram", request_, false);
781 
782  return actualResponse_;
783  }
784 
785 
826  string column_name,
827  double start,
828  double end,
829  double interval,
830  IDictionary<string, string> options = null )
831  {
832  return aggregateHistogram( new AggregateHistogramRequest( table_name,
833  column_name, start,
834  end, interval,
835  options ) );
836  }
837 
838 
857  {
858  AggregateKMeansResponse actualResponse_ = SubmitRequest<AggregateKMeansResponse>("/aggregate/kmeans", request_, false);
859 
860  return actualResponse_;
861  }
862 
863 
913  public AggregateKMeansResponse aggregateKMeans( string table_name,
914  IList<string> column_names,
915  int k,
916  double tolerance,
917  IDictionary<string, string> options = null )
918  {
919  return aggregateKMeans( new AggregateKMeansRequest( table_name, column_names,
920  k, tolerance, options ) );
921  }
922 
923 
934  {
935  AggregateMinMaxResponse actualResponse_ = SubmitRequest<AggregateMinMaxResponse>("/aggregate/minmax", request_, false);
936 
937  return actualResponse_;
938  }
939 
940 
953  public AggregateMinMaxResponse aggregateMinMax( string table_name,
954  string column_name,
955  IDictionary<string, string> options = null )
956  {
957  return aggregateMinMax( new AggregateMinMaxRequest( table_name, column_name,
958  options ) );
959  }
960 
961 
973  {
974  AggregateMinMaxGeometryResponse actualResponse_ = SubmitRequest<AggregateMinMaxGeometryResponse>("/aggregate/minmax/geometry", request_, false);
975 
976  return actualResponse_;
977  }
978 
979 
994  string column_name,
995  IDictionary<string, string> options = null )
996  {
998  table_name,
999  column_name,
1000  options ) );
1001  }
1002 
1003 
1052  {
1053  AggregateStatisticsResponse actualResponse_ = SubmitRequest<AggregateStatisticsResponse>("/aggregate/statistics", request_, false);
1054 
1055  return actualResponse_;
1056  }
1057 
1058 
1217  string column_name,
1218  string stats,
1219  IDictionary<string, string> options = null )
1220  {
1221  return aggregateStatistics( new AggregateStatisticsRequest( table_name,
1222  column_name,
1223  stats, options ) );
1224  }
1225 
1226 
1261  {
1262  AggregateStatisticsByRangeResponse actualResponse_ = SubmitRequest<AggregateStatisticsByRangeResponse>("/aggregate/statistics/byrange", request_, false);
1263 
1264  return actualResponse_;
1265  }
1266 
1267 
1347  string select_expression,
1348  string column_name,
1349  string value_column_name,
1350  string stats,
1351  double start,
1352  double end,
1353  double interval,
1354  IDictionary<string, string> options = null )
1355  {
1357  table_name,
1358  select_expression,
1359  column_name,
1360  value_column_name,
1361  stats,
1362  start,
1363  end,
1364  interval,
1365  options ) );
1366  }
1367 
1368 
1422  {
1423  RawAggregateUniqueResponse actualResponse_ = SubmitRequest<RawAggregateUniqueResponse>("/aggregate/unique", request_, false);
1424 
1426  response_.table_name = actualResponse_.table_name;
1427  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1428  response_.has_more_records = actualResponse_.has_more_records;
1429  return response_;
1430  }
1431 
1432 
1594  public AggregateUniqueResponse aggregateUnique( string table_name,
1595  string column_name,
1596  long offset,
1597  long limit = 10000,
1598  IDictionary<string, string> options = null )
1599  {
1600  return aggregateUnique( new AggregateUniqueRequest( table_name, column_name,
1601  offset, limit, options ) );
1602  }
1603 
1604 
1626  {
1627  RawAggregateUnpivotResponse actualResponse_ = SubmitRequest<RawAggregateUnpivotResponse>("/aggregate/unpivot", request_, false);
1628 
1630  response_.table_name = actualResponse_.table_name;
1631  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1632  response_.total_number_of_records = actualResponse_.total_number_of_records;
1633  response_.has_more_records = actualResponse_.has_more_records;
1634  return response_;
1635  }
1636 
1637 
1741  public AggregateUnpivotResponse aggregateUnpivot( string table_name,
1742  string variable_column_name,
1743  string value_column_name,
1744  IList<string> pivoted_columns,
1745  IDictionary<string, string> options = null )
1746  {
1747  return aggregateUnpivot( new AggregateUnpivotRequest( table_name,
1748  variable_column_name,
1749  value_column_name,
1750  pivoted_columns, options ) );
1751  }
1752 
1753 
1771  {
1772  AlterSystemPropertiesResponse actualResponse_ = SubmitRequest<AlterSystemPropertiesResponse>("/alter/system/properties", request_, false);
1773 
1774  return actualResponse_;
1775  }
1776 
1777 
1952  public AlterSystemPropertiesResponse alterSystemProperties( IDictionary<string, string> property_updates_map,
1953  IDictionary<string, string> options = null )
1954  {
1956  property_updates_map,
1957  options ) );
1958  }
1959 
1960 
2008  {
2009  AlterTableResponse actualResponse_ = SubmitRequest<AlterTableResponse>("/alter/table", request_, false);
2010 
2011  return actualResponse_;
2012  }
2013 
2014 
2282  public AlterTableResponse alterTable( string table_name,
2283  string action,
2284  string _value,
2285  IDictionary<string, string> options = null )
2286  {
2287  return alterTable( new AlterTableRequest( table_name, action, _value, options ) );
2288  }
2289 
2290 
2304  {
2305  AlterTableMetadataResponse actualResponse_ = SubmitRequest<AlterTableMetadataResponse>("/alter/table/metadata", request_, false);
2306 
2307  return actualResponse_;
2308  }
2309 
2310 
2330  public AlterTableMetadataResponse alterTableMetadata( IList<string> table_names,
2331  IDictionary<string, string> metadata_map,
2332  IDictionary<string, string> options = null )
2333  {
2334  return alterTableMetadata( new AlterTableMetadataRequest( table_names,
2335  metadata_map,
2336  options ) );
2337  }
2338 
2339 
2349  {
2350  AlterUserResponse actualResponse_ = SubmitRequest<AlterUserResponse>("/alter/user", request_, false);
2351 
2352  return actualResponse_;
2353  }
2354 
2355 
2378  public AlterUserResponse alterUser( string name,
2379  string action,
2380  string _value,
2381  IDictionary<string, string> options )
2382  {
2383  return alterUser( new AlterUserRequest( name, action, _value, options ) );
2384  }
2385 
2386 
2403  {
2404  AppendRecordsResponse actualResponse_ = SubmitRequest<AppendRecordsResponse>("/append/records", request_, false);
2405 
2406  return actualResponse_;
2407  }
2408 
2409 
2504  public AppendRecordsResponse appendRecords( string table_name,
2505  string source_table_name,
2506  IDictionary<string, string> field_map,
2507  IDictionary<string, string> options = null )
2508  {
2509  return appendRecords( new AppendRecordsRequest( table_name, source_table_name,
2510  field_map, options ) );
2511  }
2512 
2513 
2527  {
2528  ClearTableResponse actualResponse_ = SubmitRequest<ClearTableResponse>("/clear/table", request_, false);
2529 
2530  return actualResponse_;
2531  }
2532 
2533 
2575  public ClearTableResponse clearTable( string table_name = "",
2576  string authorization = "",
2577  IDictionary<string, string> options = null )
2578  {
2579  return clearTable( new ClearTableRequest( table_name, authorization, options ) );
2580  }
2581 
2582 
2594  {
2595  ClearTableMonitorResponse actualResponse_ = SubmitRequest<ClearTableMonitorResponse>("/clear/tablemonitor", request_, false);
2596 
2597  return actualResponse_;
2598  }
2599 
2600 
2613  IDictionary<string, string> options = null )
2614  {
2615  return clearTableMonitor( new ClearTableMonitorRequest( topic_id, options ) );
2616  }
2617 
2618 
2631  {
2632  ClearTriggerResponse actualResponse_ = SubmitRequest<ClearTriggerResponse>("/clear/trigger", request_, false);
2633 
2634  return actualResponse_;
2635  }
2636 
2637 
2650  public ClearTriggerResponse clearTrigger( string trigger_id,
2651  IDictionary<string, string> options = null )
2652  {
2653  return clearTrigger( new ClearTriggerRequest( trigger_id, options ) );
2654  }
2655 
2656 
2668  {
2669  CreateJoinTableResponse actualResponse_ = SubmitRequest<CreateJoinTableResponse>("/create/jointable", request_, false);
2670 
2671  return actualResponse_;
2672  }
2673 
2674 
2824  public CreateJoinTableResponse createJoinTable( string join_table_name,
2825  IList<string> table_names = null,
2826  IList<string> column_names = null,
2827  IList<string> expressions = null,
2828  IDictionary<string, string> options = null )
2829  {
2830  return createJoinTable( new CreateJoinTableRequest( join_table_name,
2831  table_names, column_names,
2832  expressions, options ) );
2833  }
2834 
2835 
2849  {
2850  CreateProcResponse actualResponse_ = SubmitRequest<CreateProcResponse>("/create/proc", request_, false);
2851 
2852  return actualResponse_;
2853  }
2854 
2855 
2912  public CreateProcResponse createProc( string proc_name,
2913  string execution_mode = CreateProcRequest.ExecutionMode.DISTRIBUTED,
2914  IDictionary<string, byte[]> files = null,
2915  string command = "",
2916  IList<string> args = null,
2917  IDictionary<string, string> options = null )
2918  {
2919  return createProc( new CreateProcRequest( proc_name, execution_mode, files,
2920  command, args, options ) );
2921  }
2922 
2923 
2963  {
2964  CreateProjectionResponse actualResponse_ = SubmitRequest<CreateProjectionResponse>("/create/projection", request_, false);
2965 
2966  return actualResponse_;
2967  }
2968 
2969 
3116  public CreateProjectionResponse createProjection( string table_name,
3117  string projection_name,
3118  IList<string> column_names,
3119  IDictionary<string, string> options = null )
3120  {
3121  return createProjection( new CreateProjectionRequest( table_name,
3122  projection_name,
3123  column_names, options ) );
3124  }
3125 
3126 
3136  {
3137  CreateRoleResponse actualResponse_ = SubmitRequest<CreateRoleResponse>("/create/role", request_, false);
3138 
3139  return actualResponse_;
3140  }
3141 
3142 
3154  public CreateRoleResponse createRole( string name,
3155  IDictionary<string, string> options )
3156  {
3157  return createRole( new CreateRoleRequest( name, options ) );
3158  }
3159 
3160 
3182  {
3183  CreateTableResponse actualResponse_ = SubmitRequest<CreateTableResponse>("/create/table", request_, false);
3184 
3185  return actualResponse_;
3186  }
3187 
3188 
3368  public CreateTableResponse createTable( string table_name,
3369  string type_id,
3370  IDictionary<string, string> options = null )
3371  {
3372  return createTable( new CreateTableRequest( table_name, type_id, options ) );
3373  }
3374 
3375 
3397  {
3398  CreateTableMonitorResponse actualResponse_ = SubmitRequest<CreateTableMonitorResponse>("/create/tablemonitor", request_, false);
3399 
3400  return actualResponse_;
3401  }
3402 
3403 
3426  IDictionary<string, string> options = null )
3427  {
3428  return createTableMonitor( new CreateTableMonitorRequest( table_name, options ) );
3429  }
3430 
3431 
3459  {
3460  CreateTriggerByAreaResponse actualResponse_ = SubmitRequest<CreateTriggerByAreaResponse>("/create/trigger/byarea", request_, false);
3461 
3462  return actualResponse_;
3463  }
3464 
3465 
3510  IList<string> table_names,
3511  string x_column_name,
3512  IList<double> x_vector,
3513  string y_column_name,
3514  IList<double> y_vector,
3515  IDictionary<string, string> options = null )
3516  {
3517  return createTriggerByArea( new CreateTriggerByAreaRequest( request_id,
3518  table_names,
3519  x_column_name,
3520  x_vector,
3521  y_column_name,
3522  y_vector, options ) );
3523  }
3524 
3525 
3549  {
3550  CreateTriggerByRangeResponse actualResponse_ = SubmitRequest<CreateTriggerByRangeResponse>("/create/trigger/byrange", request_, false);
3551 
3552  return actualResponse_;
3553  }
3554 
3555 
3589  IList<string> table_names,
3590  string column_name,
3591  double min,
3592  double max,
3593  IDictionary<string, string> options = null )
3594  {
3595  return createTriggerByRange( new CreateTriggerByRangeRequest( request_id,
3596  table_names,
3597  column_name,
3598  min, max,
3599  options ) );
3600  }
3601 
3602 
3650  {
3651  CreateTypeResponse actualResponse_ = SubmitRequest<CreateTypeResponse>("/create/type", request_, false);
3652 
3653  SetDecoderIfMissing( actualResponse_.type_id,
3654  actualResponse_.label,
3655  actualResponse_.type_definition,
3656  actualResponse_.properties );
3657  return actualResponse_;
3658  }
3659 
3660 
3940  public CreateTypeResponse createType( string type_definition,
3941  string label,
3942  IDictionary<string, IList<string>> properties = null,
3943  IDictionary<string, string> options = null )
3944  {
3945  return createType( new CreateTypeRequest( type_definition, label, properties,
3946  options ) );
3947  }
3948 
3949 
3968  {
3969  CreateUnionResponse actualResponse_ = SubmitRequest<CreateUnionResponse>("/create/union", request_, false);
3970 
3971  return actualResponse_;
3972  }
3973 
3974 
4124  public CreateUnionResponse createUnion( string table_name,
4125  IList<string> table_names,
4126  IList<IList<string>> input_column_names,
4127  IList<string> output_column_names,
4128  IDictionary<string, string> options = null )
4129  {
4130  return createUnion( new CreateUnionRequest( table_name, table_names,
4131  input_column_names,
4132  output_column_names, options ) );
4133  }
4134 
4135 
4146  {
4147  CreateUserExternalResponse actualResponse_ = SubmitRequest<CreateUserExternalResponse>("/create/user/external", request_, false);
4148 
4149  return actualResponse_;
4150  }
4151 
4152 
4165  IDictionary<string, string> options )
4166  {
4167  return createUserExternal( new CreateUserExternalRequest( name, options ) );
4168  }
4169 
4170 
4181  {
4182  CreateUserInternalResponse actualResponse_ = SubmitRequest<CreateUserInternalResponse>("/create/user/internal", request_, false);
4183 
4184  return actualResponse_;
4185  }
4186 
4187 
4203  string password,
4204  IDictionary<string, string> options )
4205  {
4206  return createUserInternal( new CreateUserInternalRequest( name, password,
4207  options ) );
4208  }
4209 
4210 
4221  {
4222  DeleteProcResponse actualResponse_ = SubmitRequest<DeleteProcResponse>("/delete/proc", request_, false);
4223 
4224  return actualResponse_;
4225  }
4226 
4227 
4238  public DeleteProcResponse deleteProc( string proc_name,
4239  IDictionary<string, string> options = null )
4240  {
4241  return deleteProc( new DeleteProcRequest( proc_name, options ) );
4242  }
4243 
4244 
4262  {
4263  DeleteRecordsResponse actualResponse_ = SubmitRequest<DeleteRecordsResponse>("/delete/records", request_, false);
4264 
4265  return actualResponse_;
4266  }
4267 
4268 
4312  public DeleteRecordsResponse deleteRecords( string table_name,
4313  IList<string> expressions,
4314  IDictionary<string, string> options = null )
4315  {
4316  return deleteRecords( new DeleteRecordsRequest( table_name, expressions,
4317  options ) );
4318  }
4319 
4320 
4330  {
4331  DeleteRoleResponse actualResponse_ = SubmitRequest<DeleteRoleResponse>("/delete/role", request_, false);
4332 
4333  return actualResponse_;
4334  }
4335 
4336 
4346  public DeleteRoleResponse deleteRole( string name,
4347  IDictionary<string, string> options )
4348  {
4349  return deleteRole( new DeleteRoleRequest( name, options ) );
4350  }
4351 
4352 
4362  {
4363  DeleteUserResponse actualResponse_ = SubmitRequest<DeleteUserResponse>("/delete/user", request_, false);
4364 
4365  return actualResponse_;
4366  }
4367 
4368 
4378  public DeleteUserResponse deleteUser( string name,
4379  IDictionary<string, string> options )
4380  {
4381  return deleteUser( new DeleteUserRequest( name, options ) );
4382  }
4383 
4384 
4395  {
4396  ExecuteProcResponse actualResponse_ = SubmitRequest<ExecuteProcResponse>("/execute/proc", request_, false);
4397 
4398  return actualResponse_;
4399  }
4400 
4401 
4466  public ExecuteProcResponse executeProc( string proc_name,
4467  IDictionary<string, string> _params = null,
4468  IDictionary<string, byte[]> bin_params = null,
4469  IList<string> input_table_names = null,
4470  IDictionary<string, IList<string>> input_column_names = null,
4471  IList<string> output_table_names = null,
4472  IDictionary<string, string> options = null )
4473  {
4474  return executeProc( new ExecuteProcRequest( proc_name, _params, bin_params,
4475  input_table_names,
4476  input_column_names,
4477  output_table_names, options ) );
4478  }
4479 
4480 
4501  {
4502  FilterResponse actualResponse_ = SubmitRequest<FilterResponse>("/filter", request_, false);
4503 
4504  return actualResponse_;
4505  }
4506 
4507 
4557  public FilterResponse filter( string table_name,
4558  string view_name,
4559  string expression,
4560  IDictionary<string, string> options = null )
4561  {
4562  return filter( new FilterRequest( table_name, view_name, expression, options ) );
4563  }
4564 
4565 
4582  {
4583  FilterByAreaResponse actualResponse_ = SubmitRequest<FilterByAreaResponse>("/filter/byarea", request_, false);
4584 
4585  return actualResponse_;
4586  }
4587 
4588 
4619  public FilterByAreaResponse filterByArea( string table_name,
4620  string view_name,
4621  string x_column_name,
4622  IList<double> x_vector,
4623  string y_column_name,
4624  IList<double> y_vector,
4625  IDictionary<string, string> options = null )
4626  {
4627  return filterByArea( new FilterByAreaRequest( table_name, view_name,
4628  x_column_name, x_vector,
4629  y_column_name, y_vector, options ) );
4630  }
4631 
4632 
4650  {
4651  FilterByAreaGeometryResponse actualResponse_ = SubmitRequest<FilterByAreaGeometryResponse>("/filter/byarea/geometry", request_, false);
4652 
4653  return actualResponse_;
4654  }
4655 
4656 
4685  string view_name,
4686  string column_name,
4687  IList<double> x_vector,
4688  IList<double> y_vector,
4689  IDictionary<string, string> options = null )
4690  {
4691  return filterByAreaGeometry( new FilterByAreaGeometryRequest( table_name,
4692  view_name,
4693  column_name,
4694  x_vector,
4695  y_vector,
4696  options ) );
4697  }
4698 
4699 
4716  {
4717  FilterByBoxResponse actualResponse_ = SubmitRequest<FilterByBoxResponse>("/filter/bybox", request_, false);
4718 
4719  return actualResponse_;
4720  }
4721 
4722 
4759  public FilterByBoxResponse filterByBox( string table_name,
4760  string view_name,
4761  string x_column_name,
4762  double min_x,
4763  double max_x,
4764  string y_column_name,
4765  double min_y,
4766  double max_y,
4767  IDictionary<string, string> options = null )
4768  {
4769  return filterByBox( new FilterByBoxRequest( table_name, view_name,
4770  x_column_name, min_x, max_x,
4771  y_column_name, min_y, max_y,
4772  options ) );
4773  }
4774 
4775 
4792  {
4793  FilterByBoxGeometryResponse actualResponse_ = SubmitRequest<FilterByBoxGeometryResponse>("/filter/bybox/geometry", request_, false);
4794 
4795  return actualResponse_;
4796  }
4797 
4798 
4834  string view_name,
4835  string column_name,
4836  double min_x,
4837  double max_x,
4838  double min_y,
4839  double max_y,
4840  IDictionary<string, string> options = null )
4841  {
4842  return filterByBoxGeometry( new FilterByBoxGeometryRequest( table_name,
4843  view_name,
4844  column_name,
4845  min_x, max_x,
4846  min_y, max_y,
4847  options ) );
4848  }
4849 
4850 
4863  {
4864  FilterByGeometryResponse actualResponse_ = SubmitRequest<FilterByGeometryResponse>("/filter/bygeometry", request_, false);
4865 
4866  return actualResponse_;
4867  }
4868 
4869 
4946  public FilterByGeometryResponse filterByGeometry( string table_name,
4947  string view_name,
4948  string column_name,
4949  string input_wkt,
4950  string operation,
4951  IDictionary<string, string> options = null )
4952  {
4953  return filterByGeometry( new FilterByGeometryRequest( table_name, view_name,
4954  column_name, input_wkt,
4955  operation, options ) );
4956  }
4957 
4958 
4984  {
4985  FilterByListResponse actualResponse_ = SubmitRequest<FilterByListResponse>("/filter/bylist", request_, false);
4986 
4987  return actualResponse_;
4988  }
4989 
4990 
5049  public FilterByListResponse filterByList( string table_name,
5050  string view_name,
5051  IDictionary<string, IList<string>> column_values_map,
5052  IDictionary<string, string> options = null )
5053  {
5054  return filterByList( new FilterByListRequest( table_name, view_name,
5055  column_values_map, options ) );
5056  }
5057 
5058 
5080  {
5081  FilterByRadiusResponse actualResponse_ = SubmitRequest<FilterByRadiusResponse>("/filter/byradius", request_, false);
5082 
5083  return actualResponse_;
5084  }
5085 
5086 
5127  public FilterByRadiusResponse filterByRadius( string table_name,
5128  string view_name,
5129  string x_column_name,
5130  double x_center,
5131  string y_column_name,
5132  double y_center,
5133  double radius,
5134  IDictionary<string, string> options = null )
5135  {
5136  return filterByRadius( new FilterByRadiusRequest( table_name, view_name,
5137  x_column_name, x_center,
5138  y_column_name, y_center,
5139  radius, options ) );
5140  }
5141 
5142 
5160  {
5161  FilterByRadiusGeometryResponse actualResponse_ = SubmitRequest<FilterByRadiusGeometryResponse>("/filter/byradius/geometry", request_, false);
5162 
5163  return actualResponse_;
5164  }
5165 
5166 
5201  string view_name,
5202  string column_name,
5203  double x_center,
5204  double y_center,
5205  double radius,
5206  IDictionary<string, string> options = null )
5207  {
5208  return filterByRadiusGeometry( new FilterByRadiusGeometryRequest( table_name,
5209  view_name,
5210  column_name,
5211  x_center,
5212  y_center,
5213  radius,
5214  options ) );
5215  }
5216 
5217 
5240  {
5241  FilterByRangeResponse actualResponse_ = SubmitRequest<FilterByRangeResponse>("/filter/byrange", request_, false);
5242 
5243  return actualResponse_;
5244  }
5245 
5246 
5279  public FilterByRangeResponse filterByRange( string table_name,
5280  string view_name,
5281  string column_name,
5282  double lower_bound,
5283  double upper_bound,
5284  IDictionary<string, string> options = null )
5285  {
5286  return filterByRange( new FilterByRangeRequest( table_name, view_name,
5287  column_name, lower_bound,
5288  upper_bound, options ) );
5289  }
5290 
5291 
5315  {
5316  FilterBySeriesResponse actualResponse_ = SubmitRequest<FilterBySeriesResponse>("/filter/byseries", request_, false);
5317 
5318  return actualResponse_;
5319  }
5320 
5321 
5394  public FilterBySeriesResponse filterBySeries( string table_name,
5395  string view_name,
5396  string track_id,
5397  IList<string> target_track_ids,
5398  IDictionary<string, string> options = null )
5399  {
5400  return filterBySeries( new FilterBySeriesRequest( table_name, view_name,
5401  track_id, target_track_ids,
5402  options ) );
5403  }
5404 
5405 
5420  {
5421  FilterByStringResponse actualResponse_ = SubmitRequest<FilterByStringResponse>("/filter/bystring", request_, false);
5422 
5423  return actualResponse_;
5424  }
5425 
5426 
5513  public FilterByStringResponse filterByString( string table_name,
5514  string view_name,
5515  string expression,
5516  string mode,
5517  IList<string> column_names,
5518  IDictionary<string, string> options = null )
5519  {
5520  return filterByString( new FilterByStringRequest( table_name, view_name,
5521  expression, mode,
5522  column_names, options ) );
5523  }
5524 
5525 
5545  {
5546  FilterByTableResponse actualResponse_ = SubmitRequest<FilterByTableResponse>("/filter/bytable", request_, false);
5547 
5548  return actualResponse_;
5549  }
5550 
5551 
5680  public FilterByTableResponse filterByTable( string table_name,
5681  string view_name,
5682  string column_name,
5683  string source_table_name,
5684  string source_table_column_name,
5685  IDictionary<string, string> options = null )
5686  {
5687  return filterByTable( new FilterByTableRequest( table_name, view_name,
5688  column_name,
5689  source_table_name,
5690  source_table_column_name,
5691  options ) );
5692  }
5693 
5694 
5714  {
5715  FilterByValueResponse actualResponse_ = SubmitRequest<FilterByValueResponse>("/filter/byvalue", request_, false);
5716 
5717  return actualResponse_;
5718  }
5719 
5720 
5750  public FilterByValueResponse filterByValue( string table_name,
5751  string view_name,
5752  bool is_string,
5753  double _value,
5754  string value_str,
5755  string column_name,
5756  IDictionary<string, string> options = null )
5757  {
5758  return filterByValue( new FilterByValueRequest( table_name, view_name,
5759  is_string, _value, value_str,
5760  column_name, options ) );
5761  }
5762 
5763 
5786  public GetRecordsResponse<T> getRecords<T>( GetRecordsRequest request_ ) where T : new()
5787  {
5788  RawGetRecordsResponse actualResponse_ = SubmitRequest<RawGetRecordsResponse>("/get/records", request_, false);
5789 
5790  GetRecordsResponse<T> response_ = new GetRecordsResponse<T>();
5791  response_.table_name = actualResponse_.table_name;
5792  response_.type_name = actualResponse_.type_name;
5793  response_.type_schema = actualResponse_.type_schema;
5794  response_.data = new List<T>();
5795  this.DecodeRawBinaryDataUsingSchemaString<T>( response_.type_schema, actualResponse_.records_binary, response_.data );
5796  response_.total_number_of_records = actualResponse_.total_number_of_records;
5797  response_.has_more_records = actualResponse_.has_more_records;
5798  return response_;
5799  }
5800 
5801 
5889  public GetRecordsResponse<T> getRecords<T>( string table_name,
5890  long offset = 0,
5891  long limit = 10000,
5892  IDictionary<string, string> options = null ) where T : new()
5893  {
5894  return getRecords<T>( new GetRecordsRequest( table_name, offset, limit,
5895  options ) );
5896  }
5897 
5898 
5923  {
5924  RawGetRecordsByColumnResponse actualResponse_ = SubmitRequest<RawGetRecordsByColumnResponse>("/get/records/bycolumn", request_, false);
5925 
5927  response_.table_name = actualResponse_.table_name;
5928  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
5929  response_.total_number_of_records = actualResponse_.total_number_of_records;
5930  response_.has_more_records = actualResponse_.has_more_records;
5931  return response_;
5932  }
5933 
5934 
6014  IList<string> column_names,
6015  long offset,
6016  long limit,
6017  IDictionary<string, string> options = null )
6018  {
6019  return getRecordsByColumn( new GetRecordsByColumnRequest( table_name,
6020  column_names,
6021  offset, limit,
6022  options ) );
6023  }
6024 
6025 
6053  {
6054  RawGetRecordsBySeriesResponse actualResponse_ = SubmitRequest<RawGetRecordsBySeriesResponse>("/get/records/byseries", request_, false);
6055 
6057  response_.table_names = actualResponse_.table_names;
6058  response_.type_names = actualResponse_.type_names;
6059  response_.type_schemas = actualResponse_.type_schemas;
6060  response_.data = new List<IList<T>>();
6061  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.list_records_binary, response_.data );
6062  return response_;
6063  }
6064 
6065 
6106  string world_table_name,
6107  int offset = 0,
6108  int limit = 250,
6109  IDictionary<string, string> options = null ) where T : new()
6110  {
6111  return getRecordsBySeries<T>( new GetRecordsBySeriesRequest( table_name,
6112  world_table_name,
6113  offset, limit,
6114  options ) );
6115  }
6116 
6117 
6140  {
6141  RawGetRecordsFromCollectionResponse actualResponse_ = SubmitRequest<RawGetRecordsFromCollectionResponse>("/get/records/fromcollection", request_, false);
6142 
6144  response_.table_name = actualResponse_.table_name;
6145  response_.type_names = actualResponse_.type_names;
6146  response_.data = new List<T>();
6147  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.records_binary, response_.data );
6148  response_.record_ids = actualResponse_.record_ids;
6149  return response_;
6150  }
6151 
6152 
6205  long offset = 0,
6206  long limit = 10000,
6207  IDictionary<string, string> options = null ) where T : new()
6208  {
6210  table_name,
6211  offset,
6212  limit,
6213  options ) );
6214  }
6215 
6216 
6227  {
6228  GrantPermissionSystemResponse actualResponse_ = SubmitRequest<GrantPermissionSystemResponse>("/grant/permission/system", request_, false);
6229 
6230  return actualResponse_;
6231  }
6232 
6233 
6266  string permission,
6267  IDictionary<string, string> options )
6268  {
6270  permission,
6271  options ) );
6272  }
6273 
6274 
6285  {
6286  GrantPermissionTableResponse actualResponse_ = SubmitRequest<GrantPermissionTableResponse>("/grant/permission/table", request_, false);
6287 
6288  return actualResponse_;
6289  }
6290 
6291 
6338  string permission,
6339  string table_name,
6340  string filter_expression,
6341  IDictionary<string, string> options )
6342  {
6344  permission,
6345  table_name,
6346  filter_expression,
6347  options ) );
6348  }
6349 
6350 
6360  {
6361  GrantRoleResponse actualResponse_ = SubmitRequest<GrantRoleResponse>("/grant/role", request_, false);
6362 
6363  return actualResponse_;
6364  }
6365 
6366 
6379  public GrantRoleResponse grantRole( string role,
6380  string member,
6381  IDictionary<string, string> options )
6382  {
6383  return grantRole( new GrantRoleRequest( role, member, options ) );
6384  }
6385 
6386 
6397  {
6398  HasProcResponse actualResponse_ = SubmitRequest<HasProcResponse>("/has/proc", request_, false);
6399 
6400  return actualResponse_;
6401  }
6402 
6403 
6414  public HasProcResponse hasProc( string proc_name,
6415  IDictionary<string, string> options = null )
6416  {
6417  return hasProc( new HasProcRequest( proc_name, options ) );
6418  }
6419 
6420 
6431  {
6432  HasTableResponse actualResponse_ = SubmitRequest<HasTableResponse>("/has/table", request_, false);
6433 
6434  return actualResponse_;
6435  }
6436 
6437 
6448  public HasTableResponse hasTable( string table_name,
6449  IDictionary<string, string> options = null )
6450  {
6451  return hasTable( new HasTableRequest( table_name, options ) );
6452  }
6453 
6454 
6464  {
6465  HasTypeResponse actualResponse_ = SubmitRequest<HasTypeResponse>("/has/type", request_, false);
6466 
6467  return actualResponse_;
6468  }
6469 
6470 
6480  public HasTypeResponse hasType( string type_id,
6481  IDictionary<string, string> options = null )
6482  {
6483  return hasType( new HasTypeRequest( type_id, options ) );
6484  }
6485 
6486 
6516  {
6517  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", request_, true);
6518 
6519  return actualResponse_;
6520  }
6521 
6522 
6554  {
6555  RawInsertRecordsRequest actualRequest_ = new RawInsertRecordsRequest();
6556  actualRequest_.table_name = request_.table_name;
6557  foreach (var thisObj in request_.data) actualRequest_.list.Add( AvroEncode( thisObj ) );
6558  actualRequest_.options = request_.options;
6559  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", actualRequest_, true);
6560 
6561  return actualResponse_;
6562  }
6563 
6564 
6656  public InsertRecordsResponse insertRecords<T>( string table_name,
6657  IList<T> data,
6658  IDictionary<string, string> options = null )
6659  {
6660  return insertRecords<T>( new InsertRecordsRequest<T>( table_name, data,
6661  options ) );
6662  }
6663 
6664 
6682  {
6683  InsertRecordsRandomResponse actualResponse_ = SubmitRequest<InsertRecordsRandomResponse>("/insert/records/random", request_, false);
6684 
6685  return actualResponse_;
6686  }
6687 
6688 
6933  long count,
6934  IDictionary<string, IDictionary<string, double>> options = null )
6935  {
6936  return insertRecordsRandom( new InsertRecordsRandomRequest( table_name, count,
6937  options ) );
6938  }
6939 
6940 
6960  {
6961  InsertSymbolResponse actualResponse_ = SubmitRequest<InsertSymbolResponse>("/insert/symbol", request_, false);
6962 
6963  return actualResponse_;
6964  }
6965 
6966 
7020  public InsertSymbolResponse insertSymbol( string symbol_id,
7021  string symbol_format,
7022  byte[] symbol_data,
7023  IDictionary<string, string> options = null )
7024  {
7025  return insertSymbol( new InsertSymbolRequest( symbol_id, symbol_format,
7026  symbol_data, options ) );
7027  }
7028 
7029 
7039  {
7040  KillProcResponse actualResponse_ = SubmitRequest<KillProcResponse>("/kill/proc", request_, false);
7041 
7042  return actualResponse_;
7043  }
7044 
7045 
7057  public KillProcResponse killProc( string run_id = "",
7058  IDictionary<string, string> options = null )
7059  {
7060  return killProc( new KillProcRequest( run_id, options ) );
7061  }
7062 
7063 
7082  {
7083  LockTableResponse actualResponse_ = SubmitRequest<LockTableResponse>("/lock/table", request_, false);
7084 
7085  return actualResponse_;
7086  }
7087 
7088 
7139  public LockTableResponse lockTable( string table_name,
7140  string lock_type = LockTableRequest.LockType.STATUS,
7141  IDictionary<string, string> options = null )
7142  {
7143  return lockTable( new LockTableRequest( table_name, lock_type, options ) );
7144  }
7145 
7146 
7172  {
7173  MergeRecordsResponse actualResponse_ = SubmitRequest<MergeRecordsResponse>("/merge/records", request_, false);
7174 
7175  return actualResponse_;
7176  }
7177 
7178 
7266  public MergeRecordsResponse mergeRecords( string table_name,
7267  IList<string> source_table_names,
7268  IList<IDictionary<string, string>> field_maps,
7269  IDictionary<string, string> options = null )
7270  {
7271  return mergeRecords( new MergeRecordsRequest( table_name, source_table_names,
7272  field_maps, options ) );
7273  }
7274 
7283  public AdminReplaceTomResponse adminReplaceTom( AdminReplaceTomRequest request_ )
7284  {
7285  AdminReplaceTomResponse actualResponse_ = SubmitRequest<AdminReplaceTomResponse>("/replace/tom", request_, false);
7286 
7287  return actualResponse_;
7288  }
7290 
7299  public AdminReplaceTomResponse adminReplaceTom( long old_rank_tom,
7300  long new_rank_tom )
7301  {
7302  return adminReplaceTom( new AdminReplaceTomRequest( old_rank_tom, new_rank_tom ) );
7303  }
7305 
7306 
7317  {
7318  RevokePermissionSystemResponse actualResponse_ = SubmitRequest<RevokePermissionSystemResponse>("/revoke/permission/system", request_, false);
7319 
7320  return actualResponse_;
7321  }
7322 
7323 
7358  string permission,
7359  IDictionary<string, string> options )
7360  {
7362  permission,
7363  options ) );
7364  }
7365 
7366 
7377  {
7378  RevokePermissionTableResponse actualResponse_ = SubmitRequest<RevokePermissionTableResponse>("/revoke/permission/table", request_, false);
7379 
7380  return actualResponse_;
7381  }
7382 
7383 
7430  string permission,
7431  string table_name,
7432  IDictionary<string, string> options )
7433  {
7435  permission,
7436  table_name,
7437  options ) );
7438  }
7439 
7440 
7451  {
7452  RevokeRoleResponse actualResponse_ = SubmitRequest<RevokeRoleResponse>("/revoke/role", request_, false);
7453 
7454  return actualResponse_;
7455  }
7456 
7457 
7471  public RevokeRoleResponse revokeRole( string role,
7472  string member,
7473  IDictionary<string, string> options )
7474  {
7475  return revokeRole( new RevokeRoleRequest( role, member, options ) );
7476  }
7477 
7478 
7488  {
7489  ShowProcResponse actualResponse_ = SubmitRequest<ShowProcResponse>("/show/proc", request_, false);
7490 
7491  return actualResponse_;
7492  }
7493 
7494 
7528  public ShowProcResponse showProc( string proc_name = "",
7529  IDictionary<string, string> options = null )
7530  {
7531  return showProc( new ShowProcRequest( proc_name, options ) );
7532  }
7533 
7534 
7548  {
7549  ShowProcStatusResponse actualResponse_ = SubmitRequest<ShowProcStatusResponse>("/show/proc/status", request_, false);
7550 
7551  return actualResponse_;
7552  }
7553 
7554 
7594  public ShowProcStatusResponse showProcStatus( string run_id = "",
7595  IDictionary<string, string> options = null )
7596  {
7597  return showProcStatus( new ShowProcStatusRequest( run_id, options ) );
7598  }
7599 
7600 
7612  {
7613  ShowSecurityResponse actualResponse_ = SubmitRequest<ShowSecurityResponse>("/show/security", request_, false);
7614 
7615  return actualResponse_;
7616  }
7617 
7618 
7631  public ShowSecurityResponse showSecurity( IList<string> names,
7632  IDictionary<string, string> options )
7633  {
7634  return showSecurity( new ShowSecurityRequest( names, options ) );
7635  }
7636 
7637 
7649  {
7650  ShowSystemPropertiesResponse actualResponse_ = SubmitRequest<ShowSystemPropertiesResponse>("/show/system/properties", request_, false);
7651 
7652  return actualResponse_;
7653  }
7654 
7655 
7675  public ShowSystemPropertiesResponse showSystemProperties( IDictionary<string, string> options = null )
7676  {
7677  return showSystemProperties( new ShowSystemPropertiesRequest( options ) );
7678  }
7679 
7680 
7692  {
7693  ShowSystemStatusResponse actualResponse_ = SubmitRequest<ShowSystemStatusResponse>("/show/system/status", request_, false);
7694 
7695  return actualResponse_;
7696  }
7697 
7698 
7709  public ShowSystemStatusResponse showSystemStatus( IDictionary<string, string> options = null )
7710  {
7711  return showSystemStatus( new ShowSystemStatusRequest( options ) );
7712  }
7713 
7714 
7726  {
7727  ShowSystemTimingResponse actualResponse_ = SubmitRequest<ShowSystemTimingResponse>("/show/system/timing", request_, false);
7728 
7729  return actualResponse_;
7730  }
7731 
7732 
7743  public ShowSystemTimingResponse showSystemTiming( IDictionary<string, string> options = null )
7744  {
7745  return showSystemTiming( new ShowSystemTimingRequest( options ) );
7746  }
7747 
7748 
7779  {
7780  ShowTableResponse actualResponse_ = SubmitRequest<ShowTableResponse>("/show/table", request_, false);
7781 
7782 
7783  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
7784  {
7785  SetDecoderIfMissing( actualResponse_.type_ids[i_],
7786  actualResponse_.type_labels[i_],
7787  actualResponse_.type_schemas[i_],
7788  actualResponse_.properties[i_] );
7789  }
7790 
7791  return actualResponse_;
7792  }
7793 
7794 
7911  public ShowTableResponse showTable( string table_name,
7912  IDictionary<string, string> options = null )
7913  {
7914  return showTable( new ShowTableRequest( table_name, options ) );
7915  }
7916 
7917 
7928  {
7929  ShowTableMetadataResponse actualResponse_ = SubmitRequest<ShowTableMetadataResponse>("/show/table/metadata", request_, false);
7930 
7931  return actualResponse_;
7932  }
7933 
7934 
7945  public ShowTableMetadataResponse showTableMetadata( IList<string> table_names,
7946  IDictionary<string, string> options = null )
7947  {
7948  return showTableMetadata( new ShowTableMetadataRequest( table_names, options ) );
7949  }
7950 
7951 
7966  {
7967  ShowTablesByTypeResponse actualResponse_ = SubmitRequest<ShowTablesByTypeResponse>("/show/tables/bytype", request_, false);
7968 
7969  return actualResponse_;
7970  }
7971 
7972 
7991  string label,
7992  IDictionary<string, string> options = null )
7993  {
7994  return showTablesByType( new ShowTablesByTypeRequest( type_id, label, options ) );
7995  }
7996 
7997 
8008  {
8009  ShowTriggersResponse actualResponse_ = SubmitRequest<ShowTriggersResponse>("/show/triggers", request_, false);
8010 
8011  return actualResponse_;
8012  }
8013 
8014 
8026  public ShowTriggersResponse showTriggers( IList<string> trigger_ids,
8027  IDictionary<string, string> options = null )
8028  {
8029  return showTriggers( new ShowTriggersRequest( trigger_ids, options ) );
8030  }
8031 
8032 
8047  {
8048  ShowTypesResponse actualResponse_ = SubmitRequest<ShowTypesResponse>("/show/types", request_, false);
8049 
8050 
8051  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
8052  {
8053  SetDecoderIfMissing( actualResponse_.type_ids[i_],
8054  actualResponse_.labels[i_],
8055  actualResponse_.type_schemas[i_],
8056  actualResponse_.properties[i_] );
8057  }
8058 
8059  return actualResponse_;
8060  }
8061 
8062 
8079  public ShowTypesResponse showTypes( string type_id,
8080  string label,
8081  IDictionary<string, string> options = null )
8082  {
8083  return showTypes( new ShowTypesRequest( type_id, label, options ) );
8084  }
8085 
8086 
8119  {
8120  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", request_, true);
8121 
8122  return actualResponse_;
8123  }
8124 
8125 
8160  {
8161  RawUpdateRecordsRequest actualRequest_ = new RawUpdateRecordsRequest();
8162  actualRequest_.table_name = request_.table_name;
8163  actualRequest_.expressions = request_.expressions;
8164  actualRequest_.new_values_maps = request_.new_values_maps;
8165  foreach (var thisObj in request_.data) actualRequest_.records_to_insert.Add( AvroEncode( thisObj ) );
8166  actualRequest_.options = request_.options;
8167  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", actualRequest_, true);
8168 
8169  return actualResponse_;
8170  }
8171 
8172 
8279  public UpdateRecordsResponse updateRecords<T>( string table_name,
8280  IList<string> expressions,
8281  IList<IDictionary<string, string>> new_values_maps,
8282  IList<T> data = null,
8283  IDictionary<string, string> options = null )
8284  {
8285  return updateRecords<T>( new UpdateRecordsRequest<T>( table_name, expressions,
8286  new_values_maps, data,
8287  options ) );
8288  }
8289 
8290 
8305  {
8306  UpdateRecordsBySeriesResponse actualResponse_ = SubmitRequest<UpdateRecordsBySeriesResponse>("/update/records/byseries", request_, false);
8307 
8308  return actualResponse_;
8309  }
8310 
8311 
8330  string world_table_name,
8331  string view_name = "",
8332  IList<string> reserved = null,
8333  IDictionary<string, string> options = null )
8334  {
8335  return updateRecordsBySeries( new UpdateRecordsBySeriesRequest( table_name,
8336  world_table_name,
8337  view_name,
8338  reserved,
8339  options ) );
8340  }
8341 
8350  public VisualizeImageResponse visualizeImage( VisualizeImageRequest request_ )
8351  {
8352  VisualizeImageResponse actualResponse_ = SubmitRequest<VisualizeImageResponse>("/visualize/image", request_, false);
8353 
8354  return actualResponse_;
8355  }
8357 
8735  public VisualizeImageResponse visualizeImage( IList<string> table_names,
8736  IList<string> world_table_names,
8737  string x_column_name,
8738  string y_column_name,
8739  string geometry_column_name,
8740  IList<IList<string>> track_ids,
8741  double min_x,
8742  double max_x,
8743  double min_y,
8744  double max_y,
8745  int width,
8746  int height,
8747  string projection,
8748  long bg_color,
8749  IDictionary<string, IList<string>> style_options,
8750  IDictionary<string, string> options = null )
8751  {
8752  return visualizeImage( new VisualizeImageRequest( table_names,
8753  world_table_names,
8754  x_column_name,
8755  y_column_name,
8756  geometry_column_name,
8757  track_ids, min_x, max_x,
8758  min_y, max_y, width, height,
8759  projection, bg_color,
8760  style_options, options ) );
8761  }
8763 
8764 
8780  {
8781  VisualizeImageChartResponse actualResponse_ = SubmitRequest<VisualizeImageChartResponse>("/visualize/image/chart", request_, false);
8782 
8783  return actualResponse_;
8784  }
8785 
8786 
8952  string x_column_name,
8953  string y_column_name,
8954  double min_x,
8955  double max_x,
8956  double min_y,
8957  double max_y,
8958  int width,
8959  int height,
8960  string bg_color,
8961  IDictionary<string, IList<string>> style_options,
8962  IDictionary<string, string> options = null )
8963  {
8964  return visualizeImageChart( new VisualizeImageChartRequest( table_name,
8965  x_column_name,
8966  y_column_name,
8967  min_x, max_x,
8968  min_y, max_y,
8969  width, height,
8970  bg_color,
8971  style_options,
8972  options ) );
8973  }
8974 
8983  public VisualizeImageClassbreakResponse visualizeImageClassbreak( VisualizeImageClassbreakRequest request_ )
8984  {
8985  VisualizeImageClassbreakResponse actualResponse_ = SubmitRequest<VisualizeImageClassbreakResponse>("/visualize/image/classbreak", request_, false);
8986 
8987  return actualResponse_;
8988  }
8990 
9357  public VisualizeImageClassbreakResponse visualizeImageClassbreak( IList<string> table_names,
9358  IList<string> world_table_names,
9359  string x_column_name,
9360  string y_column_name,
9361  string geometry_column_name,
9362  IList<IList<string>> track_ids,
9363  string cb_column_name,
9364  IList<string> cb_vals,
9365  double min_x,
9366  double max_x,
9367  double min_y,
9368  double max_y,
9369  int width,
9370  int height,
9371  string projection,
9372  long bg_color,
9373  IDictionary<string, IList<string>> style_options,
9374  IDictionary<string, string> options = null )
9375  {
9376  return visualizeImageClassbreak( new VisualizeImageClassbreakRequest(
9377  table_names,
9378  world_table_names,
9379  x_column_name,
9380  y_column_name,
9381  geometry_column_name,
9382  track_ids,
9383  cb_column_name,
9384  cb_vals,
9385  min_x,
9386  max_x,
9387  min_y,
9388  max_y,
9389  width,
9390  height,
9391  projection,
9392  bg_color,
9393  style_options,
9394  options ) );
9395  }
9397 
9406  public VisualizeImageHeatmapResponse visualizeImageHeatmap( VisualizeImageHeatmapRequest request_ )
9407  {
9408  VisualizeImageHeatmapResponse actualResponse_ = SubmitRequest<VisualizeImageHeatmapResponse>("/visualize/image/heatmap", request_, false);
9409 
9410  return actualResponse_;
9411  }
9413 
9552  public VisualizeImageHeatmapResponse visualizeImageHeatmap( IList<string> table_names,
9553  string x_column_name,
9554  string y_column_name,
9555  string value_column_name,
9556  string geometry_column_name,
9557  double min_x,
9558  double max_x,
9559  double min_y,
9560  double max_y,
9561  int width,
9562  int height,
9563  string projection,
9564  IDictionary<string, string> style_options,
9565  IDictionary<string, string> options = null )
9566  {
9567  return visualizeImageHeatmap( new VisualizeImageHeatmapRequest( table_names,
9568  x_column_name,
9569  y_column_name,
9570  value_column_name,
9571  geometry_column_name,
9572  min_x, max_x,
9573  min_y, max_y,
9574  width, height,
9575  projection,
9576  style_options,
9577  options ) );
9578  }
9580 
9589  public VisualizeImageLabelsResponse visualizeImageLabels( VisualizeImageLabelsRequest request_ )
9590  {
9591  VisualizeImageLabelsResponse actualResponse_ = SubmitRequest<VisualizeImageLabelsResponse>("/visualize/image/labels", request_, false);
9592 
9593  return actualResponse_;
9594  }
9596 
9670  public VisualizeImageLabelsResponse visualizeImageLabels( string table_name,
9671  string x_column_name,
9672  string y_column_name,
9673  string x_offset,
9674  string y_offset,
9675  string text_string,
9676  string font,
9677  string text_color,
9678  string text_angle,
9679  string text_scale,
9680  string draw_box,
9681  string draw_leader,
9682  string line_width,
9683  string line_color,
9684  string fill_color,
9685  string leader_x_column_name,
9686  string leader_y_column_name,
9687  string filter,
9688  double min_x,
9689  double max_x,
9690  double min_y,
9691  double max_y,
9692  int width,
9693  int height,
9694  string projection = VisualizeImageLabelsRequest.Projection.PLATE_CARREE,
9695  IDictionary<string, string> options = null )
9696  {
9697  return visualizeImageLabels( new VisualizeImageLabelsRequest( table_name,
9698  x_column_name,
9699  y_column_name,
9700  x_offset,
9701  y_offset,
9702  text_string,
9703  font,
9704  text_color,
9705  text_angle,
9706  text_scale,
9707  draw_box,
9708  draw_leader,
9709  line_width,
9710  line_color,
9711  fill_color,
9712  leader_x_column_name,
9713  leader_y_column_name,
9714  filter, min_x,
9715  max_x, min_y,
9716  max_y, width,
9717  height,
9718  projection,
9719  options ) );
9720  }
9722 
9731  public VisualizeVideoResponse visualizeVideo( VisualizeVideoRequest request_ )
9732  {
9733  VisualizeVideoResponse actualResponse_ = SubmitRequest<VisualizeVideoResponse>("/visualize/video", request_, false);
9734 
9735  return actualResponse_;
9736  }
9738 
10041  public VisualizeVideoResponse visualizeVideo( IList<string> table_names,
10042  IList<string> world_table_names,
10043  IList<IList<string>> track_ids,
10044  string x_column_name,
10045  string y_column_name,
10046  string geometry_column_name,
10047  double min_x,
10048  double max_x,
10049  double min_y,
10050  double max_y,
10051  int width,
10052  int height,
10053  string projection,
10054  long bg_color,
10055  IList<IList<double>> time_intervals,
10056  string video_style,
10057  string session_key,
10058  IDictionary<string, IList<string>> style_options,
10059  IDictionary<string, string> options = null )
10060  {
10061  return visualizeVideo( new VisualizeVideoRequest( table_names,
10062  world_table_names,
10063  track_ids, x_column_name,
10064  y_column_name,
10065  geometry_column_name, min_x,
10066  max_x, min_y, max_y, width,
10067  height, projection,
10068  bg_color, time_intervals,
10069  video_style, session_key,
10070  style_options, options ) );
10071  }
10073 
10082  public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( VisualizeVideoHeatmapRequest request_ )
10083  {
10084  VisualizeVideoHeatmapResponse actualResponse_ = SubmitRequest<VisualizeVideoHeatmapResponse>("/visualize/video/heatmap", request_, false);
10085 
10086  return actualResponse_;
10087  }
10089 
10225  public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( IList<string> table_names,
10226  string x_column_name,
10227  string y_column_name,
10228  double min_x,
10229  double max_x,
10230  double min_y,
10231  double max_y,
10232  IList<IList<double>> time_intervals,
10233  int width,
10234  int height,
10235  string projection,
10236  string video_style,
10237  string session_key,
10238  IDictionary<string, string> style_options,
10239  IDictionary<string, string> options = null )
10240  {
10241  return visualizeVideoHeatmap( new VisualizeVideoHeatmapRequest( table_names,
10242  x_column_name,
10243  y_column_name,
10244  min_x, max_x,
10245  min_y, max_y,
10246  time_intervals,
10247  width, height,
10248  projection,
10249  video_style,
10250  session_key,
10251  style_options,
10252  options ) );
10253  }
10255 
10256 
10257  } // end class Kinetica
10258 } // end namespace kinetica
10259 
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:606
A set of results returned by Kinetica.grantRole(string,string,IDictionary<string, string>)...
Definition: GrantRole.cs:65
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.
DeleteUserResponse deleteUser(string name, IDictionary< string, string > options)
Deletes an existing user.
FilterByTableResponse filterByTable(string table_name, string view_name, string column_name, string source_table_name, string source_table_column_name, IDictionary< string, string > options=null)
Filters objects in one table based on objects in another table.
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:69
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 a table, view, or collection, specified in table_name ...
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:56
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>).
GrantRoleResponse grantRole(string role, string member, IDictionary< string, string > options)
Grants membership in a role to a user or role.
IList< byte[]> records_binary
If the was &#39;binary&#39;, then this list contains the binary encoded records retrieved from the set...
Definition: GetRecords.cs:473
IList< string > expressions
A list of the actual predicates, one for each update; format should follow the guidelines /filter...
CreateUnionResponse createUnion(CreateUnionRequest request_)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
FilterByTableResponse filterByTable(FilterByTableRequest request_)
Filters objects in one table based on objects in another table.
long total_number_of_records
Total/Filtered number of records.
A set of results returned by Kinetica.createTableMonitor(string,IDictionary<string, string>).
A set of results returned by Kinetica.showSystemTiming(IDictionary<string, string>).
IDictionary< string, IList< string > > properties
Value of .
Definition: CreateType.cs:997
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.
RevokePermissionTableResponse revokePermissionTable(string name, string permission, string table_name, IDictionary< string, string > options)
Revokes a table-level permission from a user or role.
AdminOfflineResponse adminOffline(bool offline, IDictionary< string, string > options=null)
Take the system offline.
RevokePermissionTableResponse revokePermissionTable(RevokePermissionTableRequest request_)
Revokes a table-level permission from a user or role.
KillProcResponse killProc(string run_id="", IDictionary< string, string > options=null)
Kills a running proc instance.
A set of results returned by Kinetica.clearTable(string,string,IDictionary<string, string>).
Definition: ClearTable.cs:170
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:55
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:23
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:72
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:648
A set of parameters for Kinetica.aggregateHistogram(string,string,double,double,double,IDictionary<string, string>).
A set of results returned by Kinetica.visualizeImageChart(string,string,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:458
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:656
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:644
CreateRoleResponse createRole(string name, IDictionary< string, string > options)
Creates a new role.
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:985
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:28
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,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:501
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:55
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...
DeleteRoleResponse deleteRole(string name, IDictionary< string, string > options)
Deletes an existing role.
GrantPermissionSystemResponse grantPermissionSystem(GrantPermissionSystemRequest request_)
Grants a system-level permission to a user or role.
A set of parameters for 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:53
ShowProcStatusResponse showProcStatus(string run_id="", IDictionary< string, string > options=null)
Shows the statuses of running or completed proc instances.
ShowTriggersResponse showTriggers(IList< string > trigger_ids, IDictionary< string, string > options=null)
Retrieves information regarding the specified triggers or all existing triggers currently active...
FilterByValueResponse filterByValue(string table_name, string view_name, bool is_string, double _value, string value_str, string column_name, IDictionary< string, string > options=null)
Calculates which objects from a table has a particular value for a particular column.
A set of parameters for 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,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.
A set of results returned by Kinetica.alterUser(string,string,string,IDictionary<string, string>).
Definition: AlterUser.cs:109
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.
VisualizeImageChartResponse visualizeImageChart(string table_name, string x_column_name, string y_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
Scatter plot is the only plot type currently supported.
A set of parameters for Kinetica.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>).
CreateTriggerByAreaResponse createTriggerByArea(string request_id, IList< string > table_names, string x_column_name, IList< double > x_vector, string y_column_name, IList< double > y_vector, IDictionary< string, string > options=null)
Sets up an area trigger mechanism for two column_names for one or more tables.
CreateJoinTableResponse createJoinTable(string join_table_name, IList< string > table_names=null, IList< string > column_names=null, IList< string > expressions=null, IDictionary< string, string > options=null)
Creates a table that is the result of a SQL JOIN.
RevokeRoleResponse revokeRole(string role, string member, IDictionary< string, string > options)
Revokes membership in a role from a user or role.
AdminOfflineResponse adminOffline(AdminOfflineRequest request_)
Take the system offline.
ShowSystemTimingResponse showSystemTiming(IDictionary< string, string > options=null)
Returns the last 100 database requests along with the request timing and internal job id...
GetRecordsResponse< T > getRecords< T >(GetRecordsRequest request_)
Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column...
A set of results returned by Kinetica.killProc(string,IDictionary<string, string>).
Definition: KillProc.cs:58
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:70
A set of parameters for Kinetica.showSystemProperties(IDictionary<string, string>).
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)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
CreateTableResponse createTable(string table_name, string type_id, IDictionary< string, string > options=null)
Creates a new table or collection.
AdminAlterConfigurationResponse adminAlterConfiguration(string config_string, IDictionary< string, string > options=null)
Update the system config file.
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:258
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:481
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:30
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:415
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:23
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>).
GrantPermissionTableResponse grantPermissionTable(string name, string permission, string table_name, string filter_expression, IDictionary< string, string > options)
Grants a table-level permission to a user or role.
RevokeRoleResponse revokeRole(RevokeRoleRequest request_)
Revokes membership in a role from a user or role.
A set of results returned by Kinetica.getRecordsBySeries<T>(string,string,int,int,IDictionary<string, string>).
IList< string > labels
Definition: ShowTypes.cs:71
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:54
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>).
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...
A set of parameters for Kinetica.createProjection(string,string,IList<string>,IDictionary<string, string>).
string type_definition
Value of .
Definition: CreateType.cs:989
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...
FilterByRangeResponse filterByRange(FilterByRangeRequest request_)
Calculates which objects from a table have a column that is within the given bounds.
AggregateUnpivotResponse aggregateUnpivot(string table_name, string variable_column_name, string value_column_name, IList< string > pivoted_columns, IDictionary< string, string > options=null)
Rotate the column values into rows values.
CreateTriggerByRangeResponse createTriggerByRange(CreateTriggerByRangeRequest request_)
Sets up a simple range trigger for a column_name for one or more tables.
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:58
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,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
AlterUserResponse alterUser(string name, string action, string _value, IDictionary< string, string > options)
Alters a user.
A set of results returned by Kinetica.filterByArea(string,string,string,IList<double>,string,IList<double>,IDictionary<string, string>).
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
CreateUserExternalResponse createUserExternal(string name, IDictionary< string, string > options)
Creates a new external user (a user whose credentials are managed by an external LDAP).
A set of parameters for 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:65
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:194
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:58
A set of results returned by Kinetica.revokePermissionTable(string,string,string,IDictionary<string, string>).
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 a table, view, or collection, specified in . ...
string type_schema
Avro schema of <member name="records_binary"> or <member name="records_json">
Definition: GetRecords.cs:468
bool has_more_records
Too many records. Returned a partial set.
A set of results returned by Kinetica.showSystemStatus(IDictionary<string, string>).
CreateUserInternalResponse createUserInternal(string name, string password, IDictionary< string, string > options)
Creates a new internal user (a user whose credentials are managed by the database system)...
RevokePermissionSystemResponse revokePermissionSystem(string name, string permission, IDictionary< string, string > options)
Revokes a system-level permission from a user or role.
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>).
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:246
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:35
A set of results returned by Kinetica.createProc(string,string,IDictionary<string, byte[]>,string,IList<string>,IDictionary<string, string>).
Definition: CreateProc.cs:202
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:484
FilterBySeriesResponse filterBySeries(FilterBySeriesRequest request_)
Filters objects matching all points of the given track (works only on track type data).
ShowTypesResponse showTypes(string type_id, string label, IDictionary< string, string > options=null)
Retrieves information for the specified data type.
A set of parameters for 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.
AdminAlterConfigurationResponse adminAlterConfiguration(AdminAlterConfigurationRequest request_)
Update the system config file.
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:58
A set of parameters for Kinetica.aggregateKMeans(string,IList<string>,int,double,IDictionary<string, string>).
string table_name
Value of .
Definition: GetRecords.cs:463
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:131
A set of results returned by Kinetica.showProc(string,IDictionary<string, string>).
Definition: ShowProc.cs:153
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).
A set of parameters for Kinetica.adminShowConfiguration(IDictionary<string, string>).
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.
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...
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:53
HasTableResponse hasTable(string table_name, IDictionary< string, string > options=null)
Checks for the existence of a table with the given name.
AdminShowConfigurationResponse adminShowConfiguration(AdminShowConfigurationRequest request_)
Show the current system configuration file.
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:652
A set of results returned by Kinetica.hasType(string,IDictionary<string, string>).
Definition: HasType.cs:54
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.
ShowSecurityResponse showSecurity(IList< string > names, IDictionary< string, string > options)
Shows security information relating to users and/or roles.
CreateRoleResponse createRole(CreateRoleRequest request_)
Creates a new role.
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>).
A set of results returned by Kinetica.adminShowConfiguration(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>).
A set of results returned by Kinetica.showSecurity(IList<string>,IDictionary<string, string>).
Definition: ShowSecurity.cs:59
A set of results returned by Kinetica.filter(string,string,string,IDictionary<string, string>).
Definition: Filter.cs:167
A set of results returned by Kinetica.createTable(string,string,IDictionary<string, string>).
Definition: CreateTable.cs:676
AdminShowConfigurationResponse adminShowConfiguration(IDictionary< string, string > options=null)
Show the current system configuration file.
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:993
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.
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.adminAlterConfiguration(string,IDictionary<string, string>).
A set of results returned by Kinetica.showProcStatus(string,IDictionary<string, string>).
A set of parameters for Kinetica.createUserInternal(string,string,IDictionary<string, string>).
A set of parameters for Kinetica.visualizeImageChart(string,string,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:187
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:938
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.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
GrantPermissionSystemResponse grantPermissionSystem(string name, string permission, IDictionary< string, string > options)
Grants a system-level permission to a user or role.
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:50
A set of results returned by Kinetica.createType(string,string,IDictionary<string, IList<string>>,IDictionary<string, string>).
Definition: CreateType.cs:980
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:67
A set of results returned by Kinetica.deleteUser(string,IDictionary<string, string>).
Definition: DeleteUser.cs:54
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:496
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 parameters for Kinetica.adminAlterConfiguration(string,IDictionary<string, string>).
A set of results returned by Kinetica.aggregateMinMaxGeometry(string,string,IDictionary<string, string>).
A set of parameters for Kinetica.hasTable(string,IDictionary<string, string>).
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).
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:55
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