Kinetica C# API  Version 6.0.1.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
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.0.1.0";
20 
21 
22 
33  {
34  AdminDeleteNodeResponse actualResponse_ = SubmitRequest<AdminDeleteNodeResponse>("/admin/delete/node", request_, false);
35 
36  return actualResponse_;
37  }
38 
39 
51  string authorization,
52  IDictionary<string, string> options = null )
53  {
54  return adminDeleteNode( new AdminDeleteNodeRequest( rank, authorization,
55  options ) );
56  }
57 
58 
69  {
70  AdminGetShardAssignmentsResponse actualResponse_ = SubmitRequest<AdminGetShardAssignmentsResponse>("/admin/getshardassignments", request_, false);
71 
72  return actualResponse_;
73  }
74 
75 
84  public AdminGetShardAssignmentsResponse adminGetShardAssignments( IDictionary<string, string> options = null )
85  {
87  }
88 
89 
101  {
102  AdminOfflineResponse actualResponse_ = SubmitRequest<AdminOfflineResponse>("/admin/offline", request_, false);
103 
104  return actualResponse_;
105  }
106 
107 
120  public AdminOfflineResponse adminOffline( bool offline,
121  IDictionary<string, string> options = null )
122  {
123  return adminOffline( new AdminOfflineRequest( offline, options ) );
124  }
125 
126 
137  {
138  AdminRebalanceResponse actualResponse_ = SubmitRequest<AdminRebalanceResponse>("/admin/rebalance", request_, false);
139 
140  return actualResponse_;
141  }
142 
143 
153  public AdminRebalanceResponse adminRebalance( IList<string> table_names,
154  IDictionary<string, string> options = null )
155  {
156  return adminRebalance( new AdminRebalanceRequest( table_names, options ) );
157  }
158 
159 
170  {
171  AdminSetShardAssignmentsResponse actualResponse_ = SubmitRequest<AdminSetShardAssignmentsResponse>("/admin/setshardassignments", request_, false);
172 
173  return actualResponse_;
174  }
175 
176 
191  bool partial_reassignment,
192  IList<int> shard_assignments_rank,
193  IList<int> shard_assignments_tom,
194  IList<int> assignment_index,
195  IDictionary<string, string> options = null )
196  {
198  partial_reassignment,
199  shard_assignments_rank,
200  shard_assignments_tom,
201  assignment_index,
202  options ) );
203  }
204 
205 
215  {
216  AdminShutdownResponse actualResponse_ = SubmitRequest<AdminShutdownResponse>("/admin/shutdown", request_, false);
217 
218  return actualResponse_;
219  }
220 
221 
233  public AdminShutdownResponse adminShutdown( string exit_type,
234  string authorization,
235  IDictionary<string, string> options = null )
236  {
237  return adminShutdown( new AdminShutdownRequest( exit_type, authorization,
238  options ) );
239  }
240 
241 
254  {
255  AdminVerifyDbResponse actualResponse_ = SubmitRequest<AdminVerifyDbResponse>("/admin/verifydb", request_, false);
256 
257  return actualResponse_;
258  }
259 
260 
271  public AdminVerifyDbResponse adminVerifyDb( IDictionary<string, string> options = null )
272  {
273  return adminVerifyDb( new AdminVerifyDbRequest( options ) );
274  }
275 
276 
288  {
289  AggregateConvexHullResponse actualResponse_ = SubmitRequest<AggregateConvexHullResponse>("/aggregate/convexhull", request_, false);
290 
291  return actualResponse_;
292  }
293 
294 
313  string x_column_name,
314  string y_column_name,
315  IDictionary<string, string> options = null )
316  {
317  return aggregateConvexHull( new AggregateConvexHullRequest( table_name,
318  x_column_name,
319  y_column_name,
320  options ) );
321  }
322 
323 
386  {
387  RawAggregateGroupByResponse actualResponse_ = SubmitRequest<RawAggregateGroupByResponse>("/aggregate/groupby", request_, false);
388 
390  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
391  response_.total_number_of_records = actualResponse_.total_number_of_records;
392  response_.has_more_records = actualResponse_.has_more_records;
393  return response_;
394  }
395 
396 
531  public AggregateGroupByResponse aggregateGroupBy( string table_name,
532  IList<string> column_names,
533  long offset,
534  long limit = 1000,
535  IDictionary<string, string> options = null )
536  {
537  return aggregateGroupBy( new AggregateGroupByRequest( table_name,
538  column_names, offset,
539  limit, options ) );
540  }
541 
542 
563  {
564  AggregateHistogramResponse actualResponse_ = SubmitRequest<AggregateHistogramResponse>("/aggregate/histogram", request_, false);
565 
566  return actualResponse_;
567  }
568 
569 
609  string column_name,
610  double start,
611  double end,
612  double interval,
613  IDictionary<string, string> options = null )
614  {
615  return aggregateHistogram( new AggregateHistogramRequest( table_name,
616  column_name, start,
617  end, interval,
618  options ) );
619  }
620 
621 
640  {
641  AggregateKMeansResponse actualResponse_ = SubmitRequest<AggregateKMeansResponse>("/aggregate/kmeans", request_, false);
642 
643  return actualResponse_;
644  }
645 
646 
693  public AggregateKMeansResponse aggregateKMeans( string table_name,
694  IList<string> column_names,
695  int k,
696  double tolerance,
697  IDictionary<string, string> options = null )
698  {
699  return aggregateKMeans( new AggregateKMeansRequest( table_name, column_names,
700  k, tolerance, options ) );
701  }
702 
703 
714  {
715  AggregateMinMaxResponse actualResponse_ = SubmitRequest<AggregateMinMaxResponse>("/aggregate/minmax", request_, false);
716 
717  return actualResponse_;
718  }
719 
720 
733  public AggregateMinMaxResponse aggregateMinMax( string table_name,
734  string column_name,
735  IDictionary<string, string> options = null )
736  {
737  return aggregateMinMax( new AggregateMinMaxRequest( table_name, column_name,
738  options ) );
739  }
740 
741 
790  {
791  AggregateStatisticsResponse actualResponse_ = SubmitRequest<AggregateStatisticsResponse>("/aggregate/statistics", request_, false);
792 
793  return actualResponse_;
794  }
795 
796 
868  string column_name,
869  string stats,
870  IDictionary<string, string> options = null )
871  {
872  return aggregateStatistics( new AggregateStatisticsRequest( table_name,
873  column_name,
874  stats, options ) );
875  }
876 
877 
912  {
913  AggregateStatisticsByRangeResponse actualResponse_ = SubmitRequest<AggregateStatisticsByRangeResponse>("/aggregate/statistics/byrange", request_, false);
914 
915  return actualResponse_;
916  }
917 
918 
994  string select_expression,
995  string column_name,
996  string value_column_name,
997  string stats,
998  double start,
999  double end,
1000  double interval,
1001  IDictionary<string, string> options = null )
1002  {
1004  table_name,
1005  select_expression,
1006  column_name,
1007  value_column_name,
1008  stats,
1009  start,
1010  end,
1011  interval,
1012  options ) );
1013  }
1014 
1015 
1068  {
1069  RawAggregateUniqueResponse actualResponse_ = SubmitRequest<RawAggregateUniqueResponse>("/aggregate/unique", request_, false);
1070 
1072  response_.table_name = actualResponse_.table_name;
1073  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
1074  response_.has_more_records = actualResponse_.has_more_records;
1075  return response_;
1076  }
1077 
1078 
1183  public AggregateUniqueResponse aggregateUnique( string table_name,
1184  string column_name,
1185  long offset,
1186  long limit = 10000,
1187  IDictionary<string, string> options = null )
1188  {
1189  return aggregateUnique( new AggregateUniqueRequest( table_name, column_name,
1190  offset, limit, options ) );
1191  }
1192 
1193 
1211  {
1212  AlterSystemPropertiesResponse actualResponse_ = SubmitRequest<AlterSystemPropertiesResponse>("/alter/system/properties", request_, false);
1213 
1214  return actualResponse_;
1215  }
1216 
1217 
1318  public AlterSystemPropertiesResponse alterSystemProperties( IDictionary<string, string> property_updates_map,
1319  IDictionary<string, string> options = null )
1320  {
1322  property_updates_map,
1323  options ) );
1324  }
1325 
1326 
1360  {
1361  AlterTableResponse actualResponse_ = SubmitRequest<AlterTableResponse>("/alter/table", request_, false);
1362 
1363  return actualResponse_;
1364  }
1365 
1366 
1445  public AlterTableResponse alterTable( string table_name,
1446  string action,
1447  string _value,
1448  IDictionary<string, string> options = null )
1449  {
1450  return alterTable( new AlterTableRequest( table_name, action, _value, options ) );
1451  }
1452 
1453 
1467  {
1468  AlterTableMetadataResponse actualResponse_ = SubmitRequest<AlterTableMetadataResponse>("/alter/table/metadata", request_, false);
1469 
1470  return actualResponse_;
1471  }
1472 
1473 
1493  public AlterTableMetadataResponse alterTableMetadata( IList<string> table_names,
1494  IDictionary<string, string> metadata_map,
1495  IDictionary<string, string> options = null )
1496  {
1497  return alterTableMetadata( new AlterTableMetadataRequest( table_names,
1498  metadata_map,
1499  options ) );
1500  }
1501 
1502 
1512  {
1513  AlterUserResponse actualResponse_ = SubmitRequest<AlterUserResponse>("/alter/user", request_, false);
1514 
1515  return actualResponse_;
1516  }
1517 
1518 
1533  public AlterUserResponse alterUser( string name,
1534  string action,
1535  string _value,
1536  IDictionary<string, string> options )
1537  {
1538  return alterUser( new AlterUserRequest( name, action, _value, options ) );
1539  }
1540 
1541 
1555  {
1556  ClearTableResponse actualResponse_ = SubmitRequest<ClearTableResponse>("/clear/table", request_, false);
1557 
1558  return actualResponse_;
1559  }
1560 
1561 
1578  public ClearTableResponse clearTable( string table_name = "",
1579  string authorization = "",
1580  IDictionary<string, string> options = null )
1581  {
1582  return clearTable( new ClearTableRequest( table_name, authorization, options ) );
1583  }
1584 
1585 
1597  {
1598  ClearTableMonitorResponse actualResponse_ = SubmitRequest<ClearTableMonitorResponse>("/clear/tablemonitor", request_, false);
1599 
1600  return actualResponse_;
1601  }
1602 
1603 
1616  IDictionary<string, string> options = null )
1617  {
1618  return clearTableMonitor( new ClearTableMonitorRequest( topic_id, options ) );
1619  }
1620 
1621 
1634  {
1635  ClearTriggerResponse actualResponse_ = SubmitRequest<ClearTriggerResponse>("/clear/trigger", request_, false);
1636 
1637  return actualResponse_;
1638  }
1639 
1640 
1653  public ClearTriggerResponse clearTrigger( string trigger_id,
1654  IDictionary<string, string> options = null )
1655  {
1656  return clearTrigger( new ClearTriggerRequest( trigger_id, options ) );
1657  }
1658 
1659 
1671  {
1672  CreateJoinTableResponse actualResponse_ = SubmitRequest<CreateJoinTableResponse>("/create/jointable", request_, false);
1673 
1674  return actualResponse_;
1675  }
1676 
1677 
1749  public CreateJoinTableResponse createJoinTable( string join_table_name,
1750  IList<string> table_names = null,
1751  IList<string> column_names = null,
1752  IList<string> expressions = null,
1753  IDictionary<string, string> options = null )
1754  {
1755  return createJoinTable( new CreateJoinTableRequest( join_table_name,
1756  table_names, column_names,
1757  expressions, options ) );
1758  }
1759 
1760 
1774  {
1775  CreateProcResponse actualResponse_ = SubmitRequest<CreateProcResponse>("/create/proc", request_, false);
1776 
1777  return actualResponse_;
1778  }
1779 
1780 
1817  public CreateProcResponse createProc( string proc_name,
1818  string execution_mode = CreateProcRequest.ExecutionMode.DISTRIBUTED,
1819  IDictionary<string, byte[]> files = null,
1820  string command = "",
1821  IList<string> args = null,
1822  IDictionary<string, string> options = null )
1823  {
1824  return createProc( new CreateProcRequest( proc_name, execution_mode, files,
1825  command, args, options ) );
1826  }
1827 
1828 
1868  {
1869  CreateProjectionResponse actualResponse_ = SubmitRequest<CreateProjectionResponse>("/create/projection", request_, false);
1870 
1871  return actualResponse_;
1872  }
1873 
1874 
1982  public CreateProjectionResponse createProjection( string table_name,
1983  string projection_name,
1984  IList<string> column_names,
1985  IDictionary<string, string> options = null )
1986  {
1987  return createProjection( new CreateProjectionRequest( table_name,
1988  projection_name,
1989  column_names, options ) );
1990  }
1991 
1992 
2002  {
2003  CreateRoleResponse actualResponse_ = SubmitRequest<CreateRoleResponse>("/create/role", request_, false);
2004 
2005  return actualResponse_;
2006  }
2007 
2008 
2020  public CreateRoleResponse createRole( string name,
2021  IDictionary<string, string> options )
2022  {
2023  return createRole( new CreateRoleRequest( name, options ) );
2024  }
2025 
2026 
2048  {
2049  CreateTableResponse actualResponse_ = SubmitRequest<CreateTableResponse>("/create/table", request_, false);
2050 
2051  return actualResponse_;
2052  }
2053 
2054 
2151  public CreateTableResponse createTable( string table_name,
2152  string type_id,
2153  IDictionary<string, string> options = null )
2154  {
2155  return createTable( new CreateTableRequest( table_name, type_id, options ) );
2156  }
2157 
2158 
2180  {
2181  CreateTableMonitorResponse actualResponse_ = SubmitRequest<CreateTableMonitorResponse>("/create/tablemonitor", request_, false);
2182 
2183  return actualResponse_;
2184  }
2185 
2186 
2209  IDictionary<string, string> options = null )
2210  {
2211  return createTableMonitor( new CreateTableMonitorRequest( table_name, options ) );
2212  }
2213 
2214 
2240  {
2241  CreateTriggerByAreaResponse actualResponse_ = SubmitRequest<CreateTriggerByAreaResponse>("/create/trigger/byarea", request_, false);
2242 
2243  return actualResponse_;
2244  }
2245 
2246 
2291  IList<string> table_names,
2292  string x_column_name,
2293  IList<double> x_vector,
2294  string y_column_name,
2295  IList<double> y_vector,
2296  IDictionary<string, string> options = null )
2297  {
2298  return createTriggerByArea( new CreateTriggerByAreaRequest( request_id,
2299  table_names,
2300  x_column_name,
2301  x_vector,
2302  y_column_name,
2303  y_vector, options ) );
2304  }
2305 
2306 
2329  {
2330  CreateTriggerByRangeResponse actualResponse_ = SubmitRequest<CreateTriggerByRangeResponse>("/create/trigger/byrange", request_, false);
2331 
2332  return actualResponse_;
2333  }
2334 
2335 
2369  IList<string> table_names,
2370  string column_name,
2371  double min,
2372  double max,
2373  IDictionary<string, string> options = null )
2374  {
2375  return createTriggerByRange( new CreateTriggerByRangeRequest( request_id,
2376  table_names,
2377  column_name,
2378  min, max,
2379  options ) );
2380  }
2381 
2382 
2430  {
2431  CreateTypeResponse actualResponse_ = SubmitRequest<CreateTypeResponse>("/create/type", request_, false);
2432 
2433  SetDecoderIfMissing( actualResponse_.type_id,
2434  actualResponse_.label,
2435  actualResponse_.type_definition,
2436  actualResponse_.properties );
2437  return actualResponse_;
2438  }
2439 
2440 
2497  public CreateTypeResponse createType( string type_definition,
2498  string label,
2499  IDictionary<string, IList<string>> properties = null,
2500  IDictionary<string, string> options = null )
2501  {
2502  return createType( new CreateTypeRequest( type_definition, label, properties,
2503  options ) );
2504  }
2505 
2506 
2525  {
2526  CreateUnionResponse actualResponse_ = SubmitRequest<CreateUnionResponse>("/create/union", request_, false);
2527 
2528  return actualResponse_;
2529  }
2530 
2531 
2598  public CreateUnionResponse createUnion( string table_name,
2599  IList<string> table_names,
2600  IList<IList<string>> input_column_names,
2601  IList<string> output_column_names,
2602  IDictionary<string, string> options = null )
2603  {
2604  return createUnion( new CreateUnionRequest( table_name, table_names,
2605  input_column_names,
2606  output_column_names, options ) );
2607  }
2608 
2609 
2620  {
2621  CreateUserExternalResponse actualResponse_ = SubmitRequest<CreateUserExternalResponse>("/create/user/external", request_, false);
2622 
2623  return actualResponse_;
2624  }
2625 
2626 
2639  IDictionary<string, string> options )
2640  {
2641  return createUserExternal( new CreateUserExternalRequest( name, options ) );
2642  }
2643 
2644 
2655  {
2656  CreateUserInternalResponse actualResponse_ = SubmitRequest<CreateUserInternalResponse>("/create/user/internal", request_, false);
2657 
2658  return actualResponse_;
2659  }
2660 
2661 
2677  string password,
2678  IDictionary<string, string> options )
2679  {
2680  return createUserInternal( new CreateUserInternalRequest( name, password,
2681  options ) );
2682  }
2683 
2684 
2695  {
2696  DeleteProcResponse actualResponse_ = SubmitRequest<DeleteProcResponse>("/delete/proc", request_, false);
2697 
2698  return actualResponse_;
2699  }
2700 
2701 
2712  public DeleteProcResponse deleteProc( string proc_name,
2713  IDictionary<string, string> options = null )
2714  {
2715  return deleteProc( new DeleteProcRequest( proc_name, options ) );
2716  }
2717 
2718 
2736  {
2737  DeleteRecordsResponse actualResponse_ = SubmitRequest<DeleteRecordsResponse>("/delete/records", request_, false);
2738 
2739  return actualResponse_;
2740  }
2741 
2742 
2783  public DeleteRecordsResponse deleteRecords( string table_name,
2784  IList<string> expressions,
2785  IDictionary<string, string> options = null )
2786  {
2787  return deleteRecords( new DeleteRecordsRequest( table_name, expressions,
2788  options ) );
2789  }
2790 
2791 
2801  {
2802  DeleteRoleResponse actualResponse_ = SubmitRequest<DeleteRoleResponse>("/delete/role", request_, false);
2803 
2804  return actualResponse_;
2805  }
2806 
2807 
2817  public DeleteRoleResponse deleteRole( string name,
2818  IDictionary<string, string> options )
2819  {
2820  return deleteRole( new DeleteRoleRequest( name, options ) );
2821  }
2822 
2823 
2833  {
2834  DeleteUserResponse actualResponse_ = SubmitRequest<DeleteUserResponse>("/delete/user", request_, false);
2835 
2836  return actualResponse_;
2837  }
2838 
2839 
2849  public DeleteUserResponse deleteUser( string name,
2850  IDictionary<string, string> options )
2851  {
2852  return deleteUser( new DeleteUserRequest( name, options ) );
2853  }
2854 
2855 
2866  {
2867  ExecuteProcResponse actualResponse_ = SubmitRequest<ExecuteProcResponse>("/execute/proc", request_, false);
2868 
2869  return actualResponse_;
2870  }
2871 
2872 
2935  public ExecuteProcResponse executeProc( string proc_name,
2936  IDictionary<string, string> _params = null,
2937  IDictionary<string, byte[]> bin_params = null,
2938  IList<string> input_table_names = null,
2939  IDictionary<string, IList<string>> input_column_names = null,
2940  IList<string> output_table_names = null,
2941  IDictionary<string, string> options = null )
2942  {
2943  return executeProc( new ExecuteProcRequest( proc_name, _params, bin_params,
2944  input_table_names,
2945  input_column_names,
2946  output_table_names, options ) );
2947  }
2948 
2949 
2968  {
2969  FilterResponse actualResponse_ = SubmitRequest<FilterResponse>("/filter", request_, false);
2970 
2971  return actualResponse_;
2972  }
2973 
2974 
3020  public FilterResponse filter( string table_name,
3021  string view_name,
3022  string expression,
3023  IDictionary<string, string> options = null )
3024  {
3025  return filter( new FilterRequest( table_name, view_name, expression, options ) );
3026  }
3027 
3028 
3050  {
3051  FilterByAreaResponse actualResponse_ = SubmitRequest<FilterByAreaResponse>("/filter/byarea", request_, false);
3052 
3053  return actualResponse_;
3054  }
3055 
3056 
3092  public FilterByAreaResponse filterByArea( string table_name,
3093  string view_name,
3094  string x_column_name,
3095  IList<double> x_vector,
3096  string y_column_name,
3097  IList<double> y_vector,
3098  IDictionary<string, string> options = null )
3099  {
3100  return filterByArea( new FilterByAreaRequest( table_name, view_name,
3101  x_column_name, x_vector,
3102  y_column_name, y_vector, options ) );
3103  }
3104 
3105 
3122  {
3123  FilterByBoxResponse actualResponse_ = SubmitRequest<FilterByBoxResponse>("/filter/bybox", request_, false);
3124 
3125  return actualResponse_;
3126  }
3127 
3128 
3167  public FilterByBoxResponse filterByBox( string table_name,
3168  string view_name,
3169  string x_column_name,
3170  double min_x,
3171  double max_x,
3172  string y_column_name,
3173  double min_y,
3174  double max_y,
3175  IDictionary<string, string> options = null )
3176  {
3177  return filterByBox( new FilterByBoxRequest( table_name, view_name,
3178  x_column_name, min_x, max_x,
3179  y_column_name, min_y, max_y,
3180  options ) );
3181  }
3182 
3183 
3196  {
3197  FilterByGeometryResponse actualResponse_ = SubmitRequest<FilterByGeometryResponse>("/filter/bygeometry", request_, false);
3198 
3199  return actualResponse_;
3200  }
3201 
3202 
3228  public FilterByGeometryResponse filterByGeometry( string table_name,
3229  string view_name,
3230  string column_name,
3231  string input_wkt,
3232  string operation,
3233  IDictionary<string, string> options = null )
3234  {
3235  return filterByGeometry( new FilterByGeometryRequest( table_name, view_name,
3236  column_name, input_wkt,
3237  operation, options ) );
3238  }
3239 
3240 
3266  {
3267  FilterByListResponse actualResponse_ = SubmitRequest<FilterByListResponse>("/filter/bylist", request_, false);
3268 
3269  return actualResponse_;
3270  }
3271 
3272 
3314  public FilterByListResponse filterByList( string table_name,
3315  string view_name,
3316  IDictionary<string, IList<string>> column_values_map,
3317  IDictionary<string, string> options = null )
3318  {
3319  return filterByList( new FilterByListRequest( table_name, view_name,
3320  column_values_map, options ) );
3321  }
3322 
3323 
3348  {
3349  FilterByRadiusResponse actualResponse_ = SubmitRequest<FilterByRadiusResponse>("/filter/byradius", request_, false);
3350 
3351  return actualResponse_;
3352  }
3353 
3354 
3398  public FilterByRadiusResponse filterByRadius( string table_name,
3399  string view_name,
3400  string x_column_name,
3401  double x_center,
3402  string y_column_name,
3403  double y_center,
3404  double radius,
3405  IDictionary<string, string> options = null )
3406  {
3407  return filterByRadius( new FilterByRadiusRequest( table_name, view_name,
3408  x_column_name, x_center,
3409  y_column_name, y_center,
3410  radius, options ) );
3411  }
3412 
3413 
3436  {
3437  FilterByRangeResponse actualResponse_ = SubmitRequest<FilterByRangeResponse>("/filter/byrange", request_, false);
3438 
3439  return actualResponse_;
3440  }
3441 
3442 
3475  public FilterByRangeResponse filterByRange( string table_name,
3476  string view_name,
3477  string column_name,
3478  double lower_bound,
3479  double upper_bound,
3480  IDictionary<string, string> options = null )
3481  {
3482  return filterByRange( new FilterByRangeRequest( table_name, view_name,
3483  column_name, lower_bound,
3484  upper_bound, options ) );
3485  }
3486 
3487 
3511  {
3512  FilterBySeriesResponse actualResponse_ = SubmitRequest<FilterBySeriesResponse>("/filter/byseries", request_, false);
3513 
3514  return actualResponse_;
3515  }
3516 
3517 
3577  public FilterBySeriesResponse filterBySeries( string table_name,
3578  string view_name,
3579  string track_id,
3580  IList<string> target_track_ids,
3581  IDictionary<string, string> options = null )
3582  {
3583  return filterBySeries( new FilterBySeriesRequest( table_name, view_name,
3584  track_id, target_track_ids,
3585  options ) );
3586  }
3587 
3588 
3603  {
3604  FilterByStringResponse actualResponse_ = SubmitRequest<FilterByStringResponse>("/filter/bystring", request_, false);
3605 
3606  return actualResponse_;
3607  }
3608 
3609 
3645  public FilterByStringResponse filterByString( string table_name,
3646  string view_name,
3647  string expression,
3648  string mode,
3649  IList<string> column_names,
3650  IDictionary<string, string> options = null )
3651  {
3652  return filterByString( new FilterByStringRequest( table_name, view_name,
3653  expression, mode,
3654  column_names, options ) );
3655  }
3656 
3657 
3677  {
3678  FilterByTableResponse actualResponse_ = SubmitRequest<FilterByTableResponse>("/filter/bytable", request_, false);
3679 
3680  return actualResponse_;
3681  }
3682 
3683 
3765  public FilterByTableResponse filterByTable( string table_name,
3766  string view_name,
3767  string column_name,
3768  string source_table_name,
3769  string source_table_column_name,
3770  IDictionary<string, string> options = null )
3771  {
3772  return filterByTable( new FilterByTableRequest( table_name, view_name,
3773  column_name,
3774  source_table_name,
3775  source_table_column_name,
3776  options ) );
3777  }
3778 
3779 
3799  {
3800  FilterByValueResponse actualResponse_ = SubmitRequest<FilterByValueResponse>("/filter/byvalue", request_, false);
3801 
3802  return actualResponse_;
3803  }
3804 
3805 
3835  public FilterByValueResponse filterByValue( string table_name,
3836  string view_name,
3837  bool is_string,
3838  double _value,
3839  string value_str,
3840  string column_name,
3841  IDictionary<string, string> options = null )
3842  {
3843  return filterByValue( new FilterByValueRequest( table_name, view_name,
3844  is_string, _value, value_str,
3845  column_name, options ) );
3846  }
3847 
3848 
3871  public GetRecordsResponse<T> getRecords<T>( GetRecordsRequest request_ ) where T : new()
3872  {
3873  RawGetRecordsResponse actualResponse_ = SubmitRequest<RawGetRecordsResponse>("/get/records", request_, false);
3874 
3875  GetRecordsResponse<T> response_ = new GetRecordsResponse<T>();
3876  response_.table_name = actualResponse_.table_name;
3877  response_.type_name = actualResponse_.type_name;
3878  response_.type_schema = actualResponse_.type_schema;
3879  response_.data = new List<T>();
3880  this.DecodeRawBinaryDataUsingSchemaString<T>( response_.type_schema, actualResponse_.records_binary, response_.data );
3881  response_.total_number_of_records = actualResponse_.total_number_of_records;
3882  response_.has_more_records = actualResponse_.has_more_records;
3883  return response_;
3884  }
3885 
3886 
3947  public GetRecordsResponse<T> getRecords<T>( string table_name,
3948  long offset = 0,
3949  long limit = 10000,
3950  IDictionary<string, string> options = null ) where T : new()
3951  {
3952  return getRecords<T>( new GetRecordsRequest( table_name, offset, limit,
3953  options ) );
3954  }
3955 
3956 
3984  {
3985  RawGetRecordsByColumnResponse actualResponse_ = SubmitRequest<RawGetRecordsByColumnResponse>("/get/records/bycolumn", request_, false);
3986 
3988  response_.table_name = actualResponse_.table_name;
3989  response_.data = KineticaRecord.DecodeDynamicTableRecords( actualResponse_.response_schema_str, actualResponse_.binary_encoded_response );
3990  response_.total_number_of_records = actualResponse_.total_number_of_records;
3991  response_.has_more_records = actualResponse_.has_more_records;
3992  return response_;
3993  }
3994 
3995 
4064  IList<string> column_names,
4065  long offset,
4066  long limit,
4067  IDictionary<string, string> options = null )
4068  {
4069  return getRecordsByColumn( new GetRecordsByColumnRequest( table_name,
4070  column_names,
4071  offset, limit,
4072  options ) );
4073  }
4074 
4075 
4103  {
4104  RawGetRecordsBySeriesResponse actualResponse_ = SubmitRequest<RawGetRecordsBySeriesResponse>("/get/records/byseries", request_, false);
4105 
4107  response_.table_names = actualResponse_.table_names;
4108  response_.type_names = actualResponse_.type_names;
4109  response_.type_schemas = actualResponse_.type_schemas;
4110  response_.data = new List<IList<T>>();
4111  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.list_records_binary, response_.data );
4112  return response_;
4113  }
4114 
4115 
4156  string world_table_name,
4157  int offset = 0,
4158  int limit = 250,
4159  IDictionary<string, string> options = null ) where T : new()
4160  {
4161  return getRecordsBySeries<T>( new GetRecordsBySeriesRequest( table_name,
4162  world_table_name,
4163  offset, limit,
4164  options ) );
4165  }
4166 
4167 
4189  {
4190  RawGetRecordsFromCollectionResponse actualResponse_ = SubmitRequest<RawGetRecordsFromCollectionResponse>("/get/records/fromcollection", request_, false);
4191 
4193  response_.table_name = actualResponse_.table_name;
4194  response_.type_names = actualResponse_.type_names;
4195  response_.data = new List<T>();
4196  this.DecodeRawBinaryDataUsingTypeIDs<T>( response_.type_names, actualResponse_.records_binary, response_.data );
4197  response_.record_ids = actualResponse_.record_ids;
4198  return response_;
4199  }
4200 
4201 
4242  long offset = 0,
4243  long limit = 10000,
4244  IDictionary<string, string> options = null ) where T : new()
4245  {
4247  table_name,
4248  offset,
4249  limit,
4250  options ) );
4251  }
4252 
4253 
4264  {
4265  GrantPermissionSystemResponse actualResponse_ = SubmitRequest<GrantPermissionSystemResponse>("/grant/permission/system", request_, false);
4266 
4267  return actualResponse_;
4268  }
4269 
4270 
4285  string permission,
4286  IDictionary<string, string> options )
4287  {
4289  permission,
4290  options ) );
4291  }
4292 
4293 
4304  {
4305  GrantPermissionTableResponse actualResponse_ = SubmitRequest<GrantPermissionTableResponse>("/grant/permission/table", request_, false);
4306 
4307  return actualResponse_;
4308  }
4309 
4310 
4331  string permission,
4332  string table_name,
4333  string filter_expression,
4334  IDictionary<string, string> options )
4335  {
4337  permission,
4338  table_name,
4339  filter_expression,
4340  options ) );
4341  }
4342 
4343 
4353  {
4354  GrantRoleResponse actualResponse_ = SubmitRequest<GrantRoleResponse>("/grant/role", request_, false);
4355 
4356  return actualResponse_;
4357  }
4358 
4359 
4372  public GrantRoleResponse grantRole( string role,
4373  string member,
4374  IDictionary<string, string> options )
4375  {
4376  return grantRole( new GrantRoleRequest( role, member, options ) );
4377  }
4378 
4379 
4390  {
4391  HasProcResponse actualResponse_ = SubmitRequest<HasProcResponse>("/has/proc", request_, false);
4392 
4393  return actualResponse_;
4394  }
4395 
4396 
4407  public HasProcResponse hasProc( string proc_name,
4408  IDictionary<string, string> options = null )
4409  {
4410  return hasProc( new HasProcRequest( proc_name, options ) );
4411  }
4412 
4413 
4424  {
4425  HasTableResponse actualResponse_ = SubmitRequest<HasTableResponse>("/has/table", request_, false);
4426 
4427  return actualResponse_;
4428  }
4429 
4430 
4441  public HasTableResponse hasTable( string table_name,
4442  IDictionary<string, string> options = null )
4443  {
4444  return hasTable( new HasTableRequest( table_name, options ) );
4445  }
4446 
4447 
4457  {
4458  HasTypeResponse actualResponse_ = SubmitRequest<HasTypeResponse>("/has/type", request_, false);
4459 
4460  return actualResponse_;
4461  }
4462 
4463 
4473  public HasTypeResponse hasType( string type_id,
4474  IDictionary<string, string> options = null )
4475  {
4476  return hasType( new HasTypeRequest( type_id, options ) );
4477  }
4478 
4479 
4509  {
4510  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", request_, true);
4511 
4512  return actualResponse_;
4513  }
4514 
4515 
4547  {
4548  RawInsertRecordsRequest actualRequest_ = new RawInsertRecordsRequest();
4549  actualRequest_.table_name = request_.table_name;
4550  foreach (var thisObj in request_.data) actualRequest_.list.Add( AvroEncode( thisObj ) );
4551  actualRequest_.options = request_.options;
4552  InsertRecordsResponse actualResponse_ = SubmitRequest<InsertRecordsResponse>("/insert/records", actualRequest_, true);
4553 
4554  return actualResponse_;
4555  }
4556 
4557 
4622  public InsertRecordsResponse insertRecords<T>( string table_name,
4623  IList<T> data,
4624  IDictionary<string, string> options = null )
4625  {
4626  return insertRecords<T>( new InsertRecordsRequest<T>( table_name, data,
4627  options ) );
4628  }
4629 
4630 
4648  {
4649  InsertRecordsRandomResponse actualResponse_ = SubmitRequest<InsertRecordsRandomResponse>("/insert/records/random", request_, false);
4650 
4651  return actualResponse_;
4652  }
4653 
4654 
4861  long count,
4862  IDictionary<string, IDictionary<string, double>> options = null )
4863  {
4864  return insertRecordsRandom( new InsertRecordsRandomRequest( table_name, count,
4865  options ) );
4866  }
4867 
4868 
4888  {
4889  InsertSymbolResponse actualResponse_ = SubmitRequest<InsertSymbolResponse>("/insert/symbol", request_, false);
4890 
4891  return actualResponse_;
4892  }
4893 
4894 
4937  public InsertSymbolResponse insertSymbol( string symbol_id,
4938  string symbol_format,
4939  byte[] symbol_data,
4940  IDictionary<string, string> options = null )
4941  {
4942  return insertSymbol( new InsertSymbolRequest( symbol_id, symbol_format,
4943  symbol_data, options ) );
4944  }
4945 
4946 
4956  {
4957  KillProcResponse actualResponse_ = SubmitRequest<KillProcResponse>("/kill/proc", request_, false);
4958 
4959  return actualResponse_;
4960  }
4961 
4962 
4974  public KillProcResponse killProc( string run_id = "",
4975  IDictionary<string, string> options = null )
4976  {
4977  return killProc( new KillProcRequest( run_id, options ) );
4978  }
4979 
4980 
4999  {
5000  LockTableResponse actualResponse_ = SubmitRequest<LockTableResponse>("/lock/table", request_, false);
5001 
5002  return actualResponse_;
5003  }
5004 
5005 
5028  public LockTableResponse lockTable( string table_name,
5029  string lock_type = LockTableRequest.LockType.STATUS,
5030  IDictionary<string, string> options = null )
5031  {
5032  return lockTable( new LockTableRequest( table_name, lock_type, options ) );
5033  }
5034 
5035 
5046  {
5047  RevokePermissionSystemResponse actualResponse_ = SubmitRequest<RevokePermissionSystemResponse>("/revoke/permission/system", request_, false);
5048 
5049  return actualResponse_;
5050  }
5051 
5052 
5068  string permission,
5069  IDictionary<string, string> options )
5070  {
5072  permission,
5073  options ) );
5074  }
5075 
5076 
5087  {
5088  RevokePermissionTableResponse actualResponse_ = SubmitRequest<RevokePermissionTableResponse>("/revoke/permission/table", request_, false);
5089 
5090  return actualResponse_;
5091  }
5092 
5093 
5113  string permission,
5114  string table_name,
5115  IDictionary<string, string> options )
5116  {
5118  permission,
5119  table_name,
5120  options ) );
5121  }
5122 
5123 
5134  {
5135  RevokeRoleResponse actualResponse_ = SubmitRequest<RevokeRoleResponse>("/revoke/role", request_, false);
5136 
5137  return actualResponse_;
5138  }
5139 
5140 
5154  public RevokeRoleResponse revokeRole( string role,
5155  string member,
5156  IDictionary<string, string> options )
5157  {
5158  return revokeRole( new RevokeRoleRequest( role, member, options ) );
5159  }
5160 
5161 
5171  {
5172  ShowProcResponse actualResponse_ = SubmitRequest<ShowProcResponse>("/show/proc", request_, false);
5173 
5174  return actualResponse_;
5175  }
5176 
5177 
5198  public ShowProcResponse showProc( string proc_name = "",
5199  IDictionary<string, string> options = null )
5200  {
5201  return showProc( new ShowProcRequest( proc_name, options ) );
5202  }
5203 
5204 
5218  {
5219  ShowProcStatusResponse actualResponse_ = SubmitRequest<ShowProcStatusResponse>("/show/proc/status", request_, false);
5220 
5221  return actualResponse_;
5222  }
5223 
5224 
5252  public ShowProcStatusResponse showProcStatus( string run_id = "",
5253  IDictionary<string, string> options = null )
5254  {
5255  return showProcStatus( new ShowProcStatusRequest( run_id, options ) );
5256  }
5257 
5258 
5270  {
5271  ShowSecurityResponse actualResponse_ = SubmitRequest<ShowSecurityResponse>("/show/security", request_, false);
5272 
5273  return actualResponse_;
5274  }
5275 
5276 
5289  public ShowSecurityResponse showSecurity( IList<string> names,
5290  IDictionary<string, string> options )
5291  {
5292  return showSecurity( new ShowSecurityRequest( names, options ) );
5293  }
5294 
5295 
5307  {
5308  ShowSystemPropertiesResponse actualResponse_ = SubmitRequest<ShowSystemPropertiesResponse>("/show/system/properties", request_, false);
5309 
5310  return actualResponse_;
5311  }
5312 
5313 
5332  public ShowSystemPropertiesResponse showSystemProperties( IDictionary<string, string> options = null )
5333  {
5334  return showSystemProperties( new ShowSystemPropertiesRequest( options ) );
5335  }
5336 
5337 
5349  {
5350  ShowSystemStatusResponse actualResponse_ = SubmitRequest<ShowSystemStatusResponse>("/show/system/status", request_, false);
5351 
5352  return actualResponse_;
5353  }
5354 
5355 
5366  public ShowSystemStatusResponse showSystemStatus( IDictionary<string, string> options = null )
5367  {
5368  return showSystemStatus( new ShowSystemStatusRequest( options ) );
5369  }
5370 
5371 
5383  {
5384  ShowSystemTimingResponse actualResponse_ = SubmitRequest<ShowSystemTimingResponse>("/show/system/timing", request_, false);
5385 
5386  return actualResponse_;
5387  }
5388 
5389 
5400  public ShowSystemTimingResponse showSystemTiming( IDictionary<string, string> options = null )
5401  {
5402  return showSystemTiming( new ShowSystemTimingRequest( options ) );
5403  }
5404 
5405 
5437  {
5438  ShowTableResponse actualResponse_ = SubmitRequest<ShowTableResponse>("/show/table", request_, false);
5439 
5440 
5441  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
5442  {
5443  SetDecoderIfMissing( actualResponse_.type_ids[i_],
5444  actualResponse_.type_labels[i_],
5445  actualResponse_.type_schemas[i_],
5446  actualResponse_.properties[i_] );
5447  }
5448 
5449  return actualResponse_;
5450  }
5451 
5452 
5513  public ShowTableResponse showTable( string table_name,
5514  IDictionary<string, string> options = null )
5515  {
5516  return showTable( new ShowTableRequest( table_name, options ) );
5517  }
5518 
5519 
5530  {
5531  ShowTableMetadataResponse actualResponse_ = SubmitRequest<ShowTableMetadataResponse>("/show/table/metadata", request_, false);
5532 
5533  return actualResponse_;
5534  }
5535 
5536 
5547  public ShowTableMetadataResponse showTableMetadata( IList<string> table_names,
5548  IDictionary<string, string> options = null )
5549  {
5550  return showTableMetadata( new ShowTableMetadataRequest( table_names, options ) );
5551  }
5552 
5553 
5568  {
5569  ShowTablesByTypeResponse actualResponse_ = SubmitRequest<ShowTablesByTypeResponse>("/show/tables/bytype", request_, false);
5570 
5571  return actualResponse_;
5572  }
5573 
5574 
5593  string label,
5594  IDictionary<string, string> options = null )
5595  {
5596  return showTablesByType( new ShowTablesByTypeRequest( type_id, label, options ) );
5597  }
5598 
5599 
5610  {
5611  ShowTriggersResponse actualResponse_ = SubmitRequest<ShowTriggersResponse>("/show/triggers", request_, false);
5612 
5613  return actualResponse_;
5614  }
5615 
5616 
5628  public ShowTriggersResponse showTriggers( IList<string> trigger_ids,
5629  IDictionary<string, string> options = null )
5630  {
5631  return showTriggers( new ShowTriggersRequest( trigger_ids, options ) );
5632  }
5633 
5634 
5649  {
5650  ShowTypesResponse actualResponse_ = SubmitRequest<ShowTypesResponse>("/show/types", request_, false);
5651 
5652 
5653  for ( int i_ = 0; i_ < actualResponse_.type_ids.Count; ++i_ )
5654  {
5655  SetDecoderIfMissing( actualResponse_.type_ids[i_],
5656  actualResponse_.labels[i_],
5657  actualResponse_.type_schemas[i_],
5658  actualResponse_.properties[i_] );
5659  }
5660 
5661  return actualResponse_;
5662  }
5663 
5664 
5681  public ShowTypesResponse showTypes( string type_id,
5682  string label,
5683  IDictionary<string, string> options = null )
5684  {
5685  return showTypes( new ShowTypesRequest( type_id, label, options ) );
5686  }
5687 
5688 
5721  {
5722  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", request_, true);
5723 
5724  return actualResponse_;
5725  }
5726 
5727 
5762  {
5763  RawUpdateRecordsRequest actualRequest_ = new RawUpdateRecordsRequest();
5764  actualRequest_.table_name = request_.table_name;
5765  actualRequest_.expressions = request_.expressions;
5766  actualRequest_.new_values_maps = request_.new_values_maps;
5767  foreach (var thisObj in request_.data) actualRequest_.records_to_insert.Add( AvroEncode( thisObj ) );
5768  actualRequest_.options = request_.options;
5769  UpdateRecordsResponse actualResponse_ = SubmitRequest<UpdateRecordsResponse>("/update/records", actualRequest_, true);
5770 
5771  return actualResponse_;
5772  }
5773 
5774 
5853  public UpdateRecordsResponse updateRecords<T>( string table_name,
5854  IList<string> expressions,
5855  IList<IDictionary<string, string>> new_values_maps,
5856  IList<T> data = null,
5857  IDictionary<string, string> options = null )
5858  {
5859  return updateRecords<T>( new UpdateRecordsRequest<T>( table_name, expressions,
5860  new_values_maps, data,
5861  options ) );
5862  }
5863 
5864 
5879  {
5880  UpdateRecordsBySeriesResponse actualResponse_ = SubmitRequest<UpdateRecordsBySeriesResponse>("/update/records/byseries", request_, false);
5881 
5882  return actualResponse_;
5883  }
5884 
5885 
5904  string world_table_name,
5905  string view_name = "",
5906  IList<string> reserved = null,
5907  IDictionary<string, string> options = null )
5908  {
5909  return updateRecordsBySeries( new UpdateRecordsBySeriesRequest( table_name,
5910  world_table_name,
5911  view_name,
5912  reserved,
5913  options ) );
5914  }
5915 
5916 
5927  {
5928  VisualizeImageResponse actualResponse_ = SubmitRequest<VisualizeImageResponse>("/visualize/image", request_, false);
5929 
5930  return actualResponse_;
5931  }
5932 
5933 
6043  public VisualizeImageResponse visualizeImage( IList<string> table_names,
6044  IList<string> world_table_names,
6045  string x_column_name,
6046  string y_column_name,
6047  IList<IList<string>> track_ids,
6048  double min_x,
6049  double max_x,
6050  double min_y,
6051  double max_y,
6052  int width,
6053  int height,
6054  string projection,
6055  long bg_color,
6056  IDictionary<string, IList<string>> style_options,
6057  IDictionary<string, string> options = null )
6058  {
6059  return visualizeImage( new VisualizeImageRequest( table_names,
6060  world_table_names,
6061  x_column_name,
6062  y_column_name, track_ids,
6063  min_x, max_x, min_y, max_y,
6064  width, height, projection,
6065  bg_color, style_options,
6066  options ) );
6067  }
6068 
6069 
6080  {
6081  VisualizeImageClassbreakResponse actualResponse_ = SubmitRequest<VisualizeImageClassbreakResponse>("/visualize/image/classbreak", request_, false);
6082 
6083  return actualResponse_;
6084  }
6085 
6086 
6201  IList<string> world_table_names,
6202  string x_column_name,
6203  string y_column_name,
6204  IList<IList<string>> track_ids,
6205  string cb_column_name1,
6206  IList<string> cb_vals1,
6207  IList<string> cb_column_name2,
6208  IList<IList<string>> cb_vals2,
6209  double min_x,
6210  double max_x,
6211  double min_y,
6212  double max_y,
6213  int width,
6214  int height,
6215  string projection,
6216  long bg_color,
6217  IDictionary<string, IList<string>> style_options,
6218  IDictionary<string, string> options = null )
6219  {
6221  table_names,
6222  world_table_names,
6223  x_column_name,
6224  y_column_name,
6225  track_ids,
6226  cb_column_name1,
6227  cb_vals1,
6228  cb_column_name2,
6229  cb_vals2,
6230  min_x,
6231  max_x,
6232  min_y,
6233  max_y,
6234  width,
6235  height,
6236  projection,
6237  bg_color,
6238  style_options,
6239  options ) );
6240  }
6241 
6242 
6253  {
6254  VisualizeImageHeatmapResponse actualResponse_ = SubmitRequest<VisualizeImageHeatmapResponse>("/visualize/image/heatmap", request_, false);
6255 
6256  return actualResponse_;
6257  }
6258 
6259 
6307  public VisualizeImageHeatmapResponse visualizeImageHeatmap( IList<string> table_names,
6308  string x_column_name,
6309  string y_column_name,
6310  string value_column_name,
6311  double min_x,
6312  double max_x,
6313  double min_y,
6314  double max_y,
6315  int width,
6316  int height,
6317  string projection,
6318  IDictionary<string, string> style_options,
6319  IDictionary<string, string> options = null )
6320  {
6321  return visualizeImageHeatmap( new VisualizeImageHeatmapRequest( table_names,
6322  x_column_name,
6323  y_column_name,
6324  value_column_name,
6325  min_x, max_x,
6326  min_y, max_y,
6327  width, height,
6328  projection,
6329  style_options,
6330  options ) );
6331  }
6332 
6333 
6344  {
6345  VisualizeImageLabelsResponse actualResponse_ = SubmitRequest<VisualizeImageLabelsResponse>("/visualize/image/labels", request_, false);
6346 
6347  return actualResponse_;
6348  }
6349 
6350 
6386  string x_column_name,
6387  string y_column_name,
6388  string x_offset,
6389  string y_offset,
6390  string text_string,
6391  string font,
6392  string text_color,
6393  string text_angle,
6394  string text_scale,
6395  string draw_box,
6396  string draw_leader,
6397  string line_width,
6398  string line_color,
6399  string fill_color,
6400  string leader_x_column_name,
6401  string leader_y_column_name,
6402  double min_x,
6403  double max_x,
6404  double min_y,
6405  double max_y,
6406  int width,
6407  int height,
6408  string projection = VisualizeImageLabelsRequest.Projection.PLATE_CARREE,
6409  IDictionary<string, string> options = null )
6410  {
6411  return visualizeImageLabels( new VisualizeImageLabelsRequest( table_name,
6412  x_column_name,
6413  y_column_name,
6414  x_offset,
6415  y_offset,
6416  text_string,
6417  font,
6418  text_color,
6419  text_angle,
6420  text_scale,
6421  draw_box,
6422  draw_leader,
6423  line_width,
6424  line_color,
6425  fill_color,
6426  leader_x_column_name,
6427  leader_y_column_name,
6428  min_x, max_x,
6429  min_y, max_y,
6430  width, height,
6431  projection,
6432  options ) );
6433  }
6434 
6435 
6480  {
6481  VisualizeVideoResponse actualResponse_ = SubmitRequest<VisualizeVideoResponse>("/visualize/video", request_, false);
6482 
6483  return actualResponse_;
6484  }
6485 
6486 
6649  public VisualizeVideoResponse visualizeVideo( IList<string> table_names,
6650  IList<string> world_table_names,
6651  IList<IList<string>> track_ids,
6652  string x_column_name,
6653  string y_column_name,
6654  double min_x,
6655  double max_x,
6656  double min_y,
6657  double max_y,
6658  int width,
6659  int height,
6660  string projection,
6661  long bg_color,
6662  IList<IList<double>> time_intervals,
6663  string video_style,
6664  string session_key,
6665  IDictionary<string, IList<string>> style_options,
6666  IDictionary<string, string> options = null )
6667  {
6668  return visualizeVideo( new VisualizeVideoRequest( table_names,
6669  world_table_names,
6670  track_ids, x_column_name,
6671  y_column_name, min_x, max_x,
6672  min_y, max_y, width, height,
6673  projection, bg_color,
6674  time_intervals, video_style,
6675  session_key, style_options,
6676  options ) );
6677  }
6678 
6679 
6690  {
6691  VisualizeVideoHeatmapResponse actualResponse_ = SubmitRequest<VisualizeVideoHeatmapResponse>("/visualize/video/heatmap", request_, false);
6692 
6693  return actualResponse_;
6694  }
6695 
6696 
6746  public VisualizeVideoHeatmapResponse visualizeVideoHeatmap( IList<string> table_names,
6747  string x_column_name,
6748  string y_column_name,
6749  double min_x,
6750  double max_x,
6751  double min_y,
6752  double max_y,
6753  IList<IList<double>> time_intervals,
6754  int width,
6755  int height,
6756  string projection,
6757  string video_style,
6758  string session_key,
6759  IDictionary<string, string> style_options,
6760  IDictionary<string, string> options = null )
6761  {
6762  return visualizeVideoHeatmap( new VisualizeVideoHeatmapRequest( table_names,
6763  x_column_name,
6764  y_column_name,
6765  min_x, max_x,
6766  min_y, max_y,
6767  time_intervals,
6768  width, height,
6769  projection,
6770  video_style,
6771  session_key,
6772  style_options,
6773  options ) );
6774  }
6775 
6776 
6777  } // end class Kinetica
6778 } // end namespace kinetica
6779 
A set of parameters for /aggregate/minmax.
A set of results returned by /create/union.
Definition: CreateUnion.cs:275
A set of results returned by /grant/role.
Definition: GrantRole.cs:61
A set of results returned by /aggregate/convexhull.
UpdateRecordsResponse updateRecords< T >(UpdateRecordsRequest< T > request_)
Runs multiple predicate-based updates in a single call.
A set of results returned by /get/records/fromcollection.
DeleteUserResponse deleteUser(string name, IDictionary< string, string > options)
Deletes an existing user.
FilterByTableResponse filterByTable(string table_name, string view_name, string column_name, string source_table_name, string source_table_column_name, IDictionary< string, string > options=null)
Filters objects in one table based on objects in another table.
CreateProcResponse createProc(string proc_name, string execution_mode=CreateProcRequest.ExecutionMode.DISTRIBUTED, IDictionary< string, byte[]> files=null, string command="", IList< string > args=null, IDictionary< string, string > options=null)
Creates an instance (proc) of the user-defined function (UDF) specified by the given command...
FilterByStringResponse filterByString(FilterByStringRequest request_)
Calculates which objects from a table, collection, or view match a string expression for the given st...
CreateTriggerByRangeResponse createTriggerByRange(string request_id, IList< string > table_names, string column_name, double min, double max, IDictionary< string, string > options=null)
Sets up a simple range trigger for a column_name for one or more tables.
HasTableResponse hasTable(HasTableRequest request_)
Checks for the existence of a table with the given name.
A set of results returned by /aggregate/kmeans.
UpdateRecordsBySeriesResponse updateRecordsBySeries(string table_name, string world_table_name, string view_name="", IList< string > reserved=null, IDictionary< string, string > options=null)
Updates the view specified by table_name to include full series (track) information from the world_t...
VisualizeImageClassbreakResponse visualizeImageClassbreak(IList< string > table_names, IList< string > world_table_names, string x_column_name, string y_column_name, IList< IList< string >> track_ids, string cb_column_name1, IList< string > cb_vals1, IList< string > cb_column_name2, IList< IList< string >> cb_vals2, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
A set of parameters for /get/records/byseries.
ShowProcStatusResponse showProcStatus(ShowProcStatusRequest request_)
Shows the statuses of running or completed proc instances.
A set of results returned by /admin/rebalance.
A set of results returned by /show/system/properties.
VisualizeVideoHeatmapResponse visualizeVideoHeatmap(IList< string > table_names, string x_column_name, string y_column_name, double min_x, double max_x, double min_y, double max_y, IList< IList< double >> time_intervals, int width, int height, string projection, string video_style, string session_key, IDictionary< string, string > style_options, IDictionary< string, string > options=null)
A set of results returned by /get/records/bycolumn.
A set of parameters for /visualize/video.
A set of results returned by /insert/records/random.
A set of results returned by /aggregate/groupby.
IList< string > type_ids
Definition: ShowTypes.cs:65
VisualizeImageResponse visualizeImage(VisualizeImageRequest request_)
A set of results returned by /grant/permission/system.
DeleteRecordsResponse deleteRecords(DeleteRecordsRequest request_)
Deletes record(s) matching the provided criteria from the given table.
AlterTableMetadataResponse alterTableMetadata(AlterTableMetadataRequest request_)
Updates (adds or changes) metadata for tables.
A set of results returned by /revoke/permission/system.
AggregateConvexHullResponse aggregateConvexHull(AggregateConvexHullRequest request_)
Calculates and returns the convex hull for the values in a table specified by .
AdminRebalanceResponse adminRebalance(IList< string > table_names, IDictionary< string, string > options=null)
A set of results returned by /visualize/image/labels.
HasTypeResponse hasType(HasTypeRequest request_)
Check for the existence of a type.
ShowTableResponse showTable(string table_name, IDictionary< string, string > options=null)
Retrieves detailed information about a table, view, or collection, specified in table_name ...
FilterByListResponse filterByList(string table_name, string view_name, IDictionary< string, IList< string >> column_values_map, IDictionary< string, string > options=null)
Calculates which records from a table have values in the given list for the corresponding column...
HasTypeResponse hasType(string type_id, IDictionary< string, string > options=null)
Check for the existence of a type.
A set of parameters for /create/type.
Definition: CreateType.cs:53
A set of parameters for /update/records/byseries.
A set of results returned by /create/user/internal.
GrantRoleResponse grantRole(string role, string member, IDictionary< string, string > options)
Grants membership in a role to a user or role.
AdminRebalanceResponse adminRebalance(AdminRebalanceRequest request_)
CreateUnionResponse createUnion(CreateUnionRequest request_)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
FilterByTableResponse filterByTable(FilterByTableRequest request_)
Filters objects in one table based on objects in another table.
A set of results returned by /create/tablemonitor.
AdminSetShardAssignmentsResponse adminSetShardAssignments(long version, bool partial_reassignment, IList< int > shard_assignments_rank, IList< int > shard_assignments_tom, IList< int > assignment_index, IDictionary< string, string > options=null)
A set of results returned by /show/system/timing.
IDictionary< string, IList< string > > properties
Value of .
Definition: CreateType.cs:286
ShowTriggersResponse showTriggers(ShowTriggersRequest request_)
Retrieves information regarding the specified triggers or all existing triggers currently active...
A set of results returned by /alter/system/properties.
A set of results returned by /visualize/video.
GrantRoleResponse grantRole(GrantRoleRequest request_)
Grants membership in a role to a user or role.
AdminDeleteNodeResponse adminDeleteNode(AdminDeleteNodeRequest request_)
LockTableResponse lockTable(string table_name, string lock_type=LockTableRequest.LockType.STATUS, IDictionary< string, string > options=null)
Manages global access to a table&#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 /clear/table.
Definition: ClearTable.cs:62
A set of results returned by /clear/tablemonitor.
VisualizeImageResponse visualizeImage(IList< string > table_names, IList< string > world_table_names, string x_column_name, string y_column_name, IList< IList< string >> track_ids, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
A set of results returned by /show/table/metadata.
AlterSystemPropertiesResponse alterSystemProperties(AlterSystemPropertiesRequest request_)
The Kinetica.alterSystemProperties(AlterSystemPropertiesRequest) endpoint is primarily used to simpli...
A set of parameters for /alter/table.
Definition: AlterTable.cs:37
A set of results returned by /filter/byseries.
A set of parameters for /create/proc.
Definition: CreateProc.cs:21
A set of parameters for /insert/records.
InsertRecordsRandomResponse insertRecordsRandom(string table_name, long count, IDictionary< string, IDictionary< string, double >> options=null)
Generates a specified number of random records and adds them to the given table.
HasProcResponse hasProc(string proc_name, IDictionary< string, string > options=null)
Checks the existence of a proc with the given name.
A set of parameters for /admin/setshardassignments.
AggregateMinMaxResponse aggregateMinMax(AggregateMinMaxRequest request_)
Calculates and returns the minimum and maximum values of a particular column in a table...
A set of results returned by /insert/symbol.
FilterByAreaResponse filterByArea(FilterByAreaRequest request_)
Calculates which objects from a table are within a named area of interest (NAI/polygon).
IList< IDictionary< string, IList< string > > > properties
Definition: ShowTypes.cs:68
KillProcResponse killProc(KillProcRequest request_)
Kills a running proc instance.
IList< string > type_schemas
Type schemas of the respective tables in &lt;member name=&quot;table_names&quot;&gt;.
Definition: ShowTable.cs:289
A set of results returned by /admin/getshardassignments.
A set of parameters for /aggregate/histogram.
A set of results returned by /get/records.
Definition: GetRecords.cs:287
A set of results returned by /create/trigger/byrange.
CreateTableResponse createTable(CreateTableRequest request_)
Creates a new table or collection.
A set of parameters for /delete/records.
AggregateUniqueResponse aggregateUnique(string table_name, string column_name, long offset, long limit=10000, IDictionary< string, string > options=null)
Returns all the unique values from a particular column (specified by column_name ) of a particular ta...
A set of parameters for /lock/table.
Definition: LockTable.cs:24
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in &lt;member name=&quot;table_names&quot;&gt;.
Definition: ShowTable.cs:297
A set of parameters for /delete/role.
Definition: DeleteRole.cs:17
A set of parameters for /show/proc/status.
A set of parameters for /visualize/video/heatmap.
A set of parameters for /aggregate/statistics/byrange.
IList< string > type_ids
Type ids of the respective tables in &lt;member name=&quot;table_names&quot;&gt;.
Definition: ShowTable.cs:285
CreateRoleResponse createRole(string name, IDictionary< string, string > options)
Creates a new role.
A set of parameters for /create/tablemonitor.
A set of results returned by /aggregate/minmax.
string type_id
An identifier representing the created type.
Definition: CreateType.cs:274
A set of results returned by /filter/byradius.
AggregateStatisticsResponse aggregateStatistics(AggregateStatisticsRequest request_)
Calculates the requested statistics of the given column(s) in a given table.
A set of parameters for /clear/table.
Definition: ClearTable.cs:20
A set of parameters for /create/union.
Definition: CreateUnion.cs:26
A set of results returned by /create/trigger/byarea.
A set of parameters for /show/system/timing.
A set of results returned by /get/records.
Definition: GetRecords.cs:323
VisualizeImageLabelsResponse visualizeImageLabels(string table_name, string x_column_name, string y_column_name, string x_offset, string y_offset, string text_string, string font, string text_color, string text_angle, string text_scale, string draw_box, string draw_leader, string line_width, string line_color, string fill_color, string leader_x_column_name, string leader_y_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection=VisualizeImageLabelsRequest.Projection.PLATE_CARREE, IDictionary< string, string > options=null)
A set of results returned by /visualize/image/classbreak.
VisualizeImageHeatmapResponse visualizeImageHeatmap(IList< string > table_names, string x_column_name, string y_column_name, string value_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, IDictionary< string, string > style_options, IDictionary< string, string > options=null)
AdminShutdownResponse adminShutdown(AdminShutdownRequest request_)
Exits the database server application.
AdminGetShardAssignmentsResponse adminGetShardAssignments(AdminGetShardAssignmentsRequest request_)
ShowSecurityResponse showSecurity(ShowSecurityRequest request_)
Shows security information relating to users and/or roles.
A set of results returned by /admin/setshardassignments.
A set of results returned by /clear/trigger.
Definition: ClearTrigger.cs:52
ShowTablesByTypeResponse showTablesByType(ShowTablesByTypeRequest request_)
Gets names of the tables whose type matches the given criteria.
A set of parameters for /update/records.
A set of results returned by /visualize/image.
CreateJoinTableResponse createJoinTable(CreateJoinTableRequest request_)
Creates a table that is the result of a SQL JOIN.
DeleteRoleResponse deleteRole(string name, IDictionary< string, string > options)
Deletes an existing role.
GrantPermissionSystemResponse grantPermissionSystem(GrantPermissionSystemRequest request_)
Grants a system-level permission to a user or role.
A set of parameters for /filter/byradius.
A set of results returned by /has/table.
Definition: HasTable.cs:50
ShowProcStatusResponse showProcStatus(string run_id="", IDictionary< string, string > options=null)
Shows the statuses of running or completed proc instances.
ShowTriggersResponse showTriggers(IList< string > trigger_ids, IDictionary< string, string > options=null)
Retrieves information regarding the specified triggers or all existing triggers currently active...
FilterByValueResponse filterByValue(string table_name, string view_name, bool is_string, double _value, string value_str, string column_name, IDictionary< string, string > options=null)
Calculates which objects from a table has a particular value for a particular column.
A set of parameters for /create/user/external.
DeleteProcResponse deleteProc(string proc_name, IDictionary< string, string > options=null)
Deletes a proc.
VisualizeImageLabelsResponse visualizeImageLabels(VisualizeImageLabelsRequest request_)
A set of parameters for /admin/shutdown.
A set of results returned by /filter/byvalue.
A set of results returned by /filter/bystring.
A set of parameters for /update/records.
GetRecordsBySeriesResponse< T > getRecordsBySeries< T >(GetRecordsBySeriesRequest request_)
Retrieves the complete series/track records from the given based on the partial track information co...
DeleteRoleResponse deleteRole(DeleteRoleRequest request_)
Deletes an existing role.
ClearTableMonitorResponse clearTableMonitor(string topic_id, IDictionary< string, string > options=null)
Deactivates a table monitor previously created with Kinetica.createTableMonitor(string,IDictionary{string, string}).
ShowSystemStatusResponse showSystemStatus(ShowSystemStatusRequest request_)
Provides server configuration and health related status to the caller.
A set of results returned by /alter/user.
Definition: AlterUser.cs:83
A set of results returned by /update/records.
A set of parameters for /get/records/bycolumn.
A set of parameters for /revoke/permission/system.
AdminVerifyDbResponse adminVerifyDb(IDictionary< string, string > options=null)
Verify database is in a consistent state.
InsertSymbolResponse insertSymbol(string symbol_id, string symbol_format, byte[] symbol_data, IDictionary< string, string > options=null)
Adds a symbol or icon (i.e.
CreateTriggerByAreaResponse createTriggerByArea(string request_id, IList< string > table_names, string x_column_name, IList< double > x_vector, string y_column_name, IList< double > y_vector, IDictionary< string, string > options=null)
Sets up an area trigger mechanism for two column_names for one or more tables.
CreateJoinTableResponse createJoinTable(string join_table_name, IList< string > table_names=null, IList< string > column_names=null, IList< string > expressions=null, IDictionary< string, string > options=null)
Creates a table that is the result of a SQL JOIN.
RevokeRoleResponse revokeRole(string role, string member, IDictionary< string, string > options)
Revokes membership in a role from a user or role.
AdminOfflineResponse adminOffline(AdminOfflineRequest request_)
Take the system offline.
ShowSystemTimingResponse showSystemTiming(IDictionary< string, string > options=null)
Returns the last 100 database requests along with the request timing and internal job id...
GetRecordsResponse< T > getRecords< T >(GetRecordsRequest request_)
Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column...
A set of results returned by /kill/proc.
Definition: KillProc.cs:55
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:66
A set of parameters for /show/system/properties.
A set of results returned by /create/projection.
CreateUnionResponse createUnion(string table_name, IList< string > table_names, IList< IList< string >> input_column_names, IList< string > output_column_names, IDictionary< string, string > options=null)
Performs a union (concatenation) of one or more existing tables or views, the results of which are st...
CreateTableResponse createTable(string table_name, string type_id, IDictionary< string, string > options=null)
Creates a new table or collection.
FilterByRadiusResponse filterByRadius(FilterByRadiusRequest request_)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
A set of results returned by /update/records/byseries.
AdminGetShardAssignmentsResponse adminGetShardAssignments(IDictionary< string, string > options=null)
A set of parameters for /delete/proc.
Definition: DeleteProc.cs:18
A set of parameters for /has/proc.
Definition: HasProc.cs:17
A set of parameters for /filter/byseries.
A set of results returned by /admin/shutdown.
A set of parameters for /grant/permission/table.
A set of results returned by /grant/permission/table.
A set of results returned by /show/table.
Definition: ShowTable.cs:189
A set of results returned by /aggregate/histogram.
HasProcResponse hasProc(HasProcRequest request_)
Checks the existence of a proc with the given name.
VisualizeVideoResponse visualizeVideo(IList< string > table_names, IList< string > world_table_names, IList< IList< string >> track_ids, string x_column_name, string y_column_name, double min_x, double max_x, double min_y, double max_y, int width, int height, string projection, long bg_color, IList< IList< double >> time_intervals, string video_style, string session_key, IDictionary< string, IList< string >> style_options, IDictionary< string, string > options=null)
Creates raster images of data in the given table based on provided input parameters.
AlterUserResponse alterUser(AlterUserRequest request_)
Alters a user.
ShowSystemTimingResponse showSystemTiming(ShowSystemTimingRequest request_)
Returns the last 100 database requests along with the request timing and internal job id...
A set of results returned by /admin/delete/node.
AlterSystemPropertiesResponse alterSystemProperties(IDictionary< string, string > property_updates_map, IDictionary< string, string > options=null)
The Kinetica.alterSystemProperties(IDictionary{string, string},IDictionary{string, string}) endpoint is primarily used to simplify the testing of the system and is not expected to be used during normal execution.
A set of results returned by /aggregate/unique.
AdminDeleteNodeResponse adminDeleteNode(int rank, string authorization, IDictionary< string, string > options=null)
A set of parameters for /show/types.
Definition: ShowTypes.cs:21
A set of parameters for /filter/byarea.
Definition: FilterByArea.cs:27
VisualizeVideoHeatmapResponse visualizeVideoHeatmap(VisualizeVideoHeatmapRequest request_)
A set of results returned by /delete/records.
A set of parameters for /show/table/metadata.
AggregateGroupByResponse aggregateGroupBy(AggregateGroupByRequest request_)
Calculates unique combinations (groups) of values for the given columns in a given table/view/collect...
A set of parameters for /grant/permission/system.
GrantPermissionTableResponse grantPermissionTable(string name, string permission, string table_name, string filter_expression, IDictionary< string, string > options)
Grants a table-level permission to a user or role.
RevokeRoleResponse revokeRole(RevokeRoleRequest request_)
Revokes membership in a role from a user or role.
A set of results returned by /get/records/byseries.
IList< string > labels
Definition: ShowTypes.cs:67
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 /grant/role.
Definition: GrantRole.cs:17
A set of results returned by /delete/role.
Definition: DeleteRole.cs:51
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 /alter/table/metadata.
A set of parameters for /filter/bylist.
Definition: FilterByList.cs:32
GetRecordsFromCollectionResponse< T > getRecordsFromCollection< T >(GetRecordsFromCollectionRequest request_)
Retrieves records from a collection.
A set of parameters for /filter/byvalue.
A set of results returned by /filter/bytable.
CreateProcResponse createProc(CreateProcRequest request_)
Creates an instance (proc) of the user-defined function (UDF) specified by the given command...
AggregateStatisticsByRangeResponse aggregateStatisticsByRange(AggregateStatisticsByRangeRequest request_)
Divides the given set into bins and calculates statistics of the values of a value-column in each bin...
A set of parameters for /create/projection.
string type_definition
Value of .
Definition: CreateType.cs:278
A set of parameters for /create/trigger/byrange.
FilterByBoxResponse filterByBox(string table_name, string view_name, string x_column_name, double min_x, double max_x, string y_column_name, double min_y, double max_y, IDictionary< string, string > options=null)
Calculates how many objects within the given table lie in a rectangular box.
FilterByGeometryResponse filterByGeometry(string table_name, string view_name, string column_name, string input_wkt, string operation, IDictionary< string, string > options=null)
Applies a geometry filter against a spatial column named WKT in a given table, collection or view...
FilterByRangeResponse filterByRange(FilterByRangeRequest request_)
Calculates which objects from a table have a column that is within the given bounds.
A set of parameters for /visualize/image.
CreateTriggerByRangeResponse createTriggerByRange(CreateTriggerByRangeRequest request_)
Sets up a simple range trigger for a column_name for one or more tables.
A set of results returned by /visualize/video/heatmap.
A set of results returned by /visualize/image/heatmap.
AdminShutdownResponse adminShutdown(string exit_type, string authorization, IDictionary< string, string > options=null)
Exits the database server application.
A set of results returned by /create/role.
Definition: CreateRole.cs:55
FilterByRadiusResponse filterByRadius(string table_name, string view_name, string x_column_name, double x_center, string y_column_name, double y_center, double radius, IDictionary< string, string > options=null)
Calculates which objects from a table lie within a circle with the given radius and center point (i...
A set of results returned by /get/records/bycolumn.
A set of parameters for /alter/user.
Definition: AlterUser.cs:17
AlterUserResponse alterUser(string name, string action, string _value, IDictionary< string, string > options)
Alters a user.
A set of results returned by /filter/byarea.
VisualizeImageHeatmapResponse visualizeImageHeatmap(VisualizeImageHeatmapRequest request_)
FilterBySeriesResponse filterBySeries(string table_name, string view_name, string track_id, IList< string > target_track_ids, IDictionary< string, string > options=null)
Filters objects matching all points of the given track (works only on track type data).
A set of parameters for /create/table.
Definition: CreateTable.cs:26
CreateUserExternalResponse createUserExternal(string name, IDictionary< string, string > options)
Creates a new external user (a user whose credentials are managed by an external LDAP).
A set of parameters for /get/records.
Definition: GetRecords.cs:28
const string API_VERSION
A set of results returned by /revoke/role.
Definition: RevokeRole.cs:61
A set of results returned by /create/jointable.
ShowProcResponse showProc(string proc_name="", IDictionary< string, string > options=null)
Shows information about a proc.
ClearTableMonitorResponse clearTableMonitor(ClearTableMonitorRequest request_)
Deactivates a table monitor previously created with Kinetica.createTableMonitor(CreateTableMonitorReq...
AggregateHistogramResponse aggregateHistogram(AggregateHistogramRequest request_)
Performs a histogram calculation given a table, a column, and an interval function.
ExecuteProcResponse executeProc(string proc_name, IDictionary< string, string > _params=null, IDictionary< string, byte[]> bin_params=null, IList< string > input_table_names=null, IDictionary< string, IList< string >> input_column_names=null, IList< string > output_table_names=null, IDictionary< string, string > options=null)
Executes a proc.
FilterByGeometryResponse filterByGeometry(FilterByGeometryRequest request_)
Applies a geometry filter against a spatial column named WKT in a given table, collection or view...
A set of results returned by /show/tables/bytype.
CreateTypeResponse createType(CreateTypeRequest request_)
Creates a new type describing the layout or schema of a table.
AlterTableMetadataResponse alterTableMetadata(IList< string > table_names, IDictionary< string, string > metadata_map, IDictionary< string, string > options=null)
Updates (adds or changes) metadata for tables.
A set of parameters for /insert/symbol.
Definition: InsertSymbol.cs:27
A set of results returned by /revoke/permission/table.
CreateUserInternalResponse createUserInternal(CreateUserInternalRequest request_)
Creates a new internal user (a user whose credentials are managed by the database system)...
A set of parameters for /get/records/fromcollection.
A set of parameters for /admin/rebalance.
ClearTableResponse clearTable(ClearTableRequest request_)
Clears (drops) one or all tables in the database cluster.
ShowTableResponse showTable(ShowTableRequest request_)
Retrieves detailed information about a table, view, or collection, specified in . ...
A set of results returned by /show/system/status.
CreateUserInternalResponse createUserInternal(string name, string password, IDictionary< string, string > options)
Creates a new internal user (a user whose credentials are managed by the database system)...
RevokePermissionSystemResponse revokePermissionSystem(string name, string permission, IDictionary< string, string > options)
Revokes a system-level permission from a user or role.
ShowSystemPropertiesResponse showSystemProperties(IDictionary< string, string > options=null)
Returns server configuration and version related information to the caller.
A set of results returned by /aggregate/unique.
AggregateStatisticsResponse aggregateStatistics(string table_name, string column_name, string stats, IDictionary< string, string > options=null)
Calculates the requested statistics of the given column(s) in a given table.
DeleteUserResponse deleteUser(DeleteUserRequest request_)
Deletes an existing user.
A set of parameters for /has/type.
Definition: HasType.cs:17
A set of parameters for /filter/bygeometry.
ClearTriggerResponse clearTrigger(string trigger_id, IDictionary< string, string > options=null)
Clears or cancels the trigger identified by the specified handle.
AdminSetShardAssignmentsResponse adminSetShardAssignments(AdminSetShardAssignmentsRequest request_)
A set of results returned by /execute/proc.
Definition: ExecuteProc.cs:231
A set of parameters for /admin/delete/node.
FilterByAreaResponse filterByArea(string table_name, string view_name, string x_column_name, IList< double > x_vector, string y_column_name, IList< double > y_vector, IDictionary< string, string > options=null)
Calculates which objects from a table are within a named area of interest (NAI/polygon).
A set of parameters for /visualize/image/heatmap.
CreateProjectionResponse createProjection(string table_name, string projection_name, IList< string > column_names, IDictionary< string, string > options=null)
Creates a new projection of an existing table.
A set of parameters for /aggregate/convexhull.
A set of parameters for /show/table.
Definition: ShowTable.cs:35
A set of results returned by /create/proc.
Definition: CreateProc.cs:139
A set of parameters for /alter/system/properties.
ShowSystemPropertiesResponse showSystemProperties(ShowSystemPropertiesRequest request_)
Returns server configuration and version related information to the caller.
A set of parameters for /filter/byrange.
VisualizeImageClassbreakResponse visualizeImageClassbreak(VisualizeImageClassbreakRequest request_)
AggregateStatisticsByRangeResponse aggregateStatisticsByRange(string table_name, string select_expression, string column_name, string value_column_name, string stats, double start, double end, double interval, IDictionary< string, string > options=null)
Divides the given set into bins and calculates statistics of the values of a value-column in each bin...
AggregateHistogramResponse aggregateHistogram(string table_name, string column_name, double start, double end, double interval, IDictionary< string, string > options=null)
Performs a histogram calculation given a table, a column, and an interval function.
A set of parameters for /revoke/role.
Definition: RevokeRole.cs:17
FilterBySeriesResponse filterBySeries(FilterBySeriesRequest request_)
Filters objects matching all points of the given track (works only on track type data).
ShowTypesResponse showTypes(string type_id, string label, IDictionary< string, string > options=null)
Retrieves information for the specified data type.
A set of parameters for /show/proc.
Definition: ShowProc.cs:17
A set of results returned by /aggregate/groupby.
ExecuteProcResponse executeProc(ExecuteProcRequest request_)
Executes a proc.
FilterByRangeResponse filterByRange(string table_name, string view_name, string column_name, double lower_bound, double upper_bound, IDictionary< string, string > options=null)
Calculates which objects from a table have a column that is within the given bounds.
A set of parameters for /insert/records.
AggregateMinMaxResponse aggregateMinMax(string table_name, string column_name, IDictionary< string, string > options=null)
Calculates and returns the minimum and maximum values of a particular column in a table...
InsertRecordsResponse insertRecords< T >(InsertRecordsRequest< T > request_)
Adds multiple records to the specified table.
AlterTableResponse alterTable(AlterTableRequest request_)
Apply various modifications to a table or collection.
A set of results returned by /show/triggers.
Definition: ShowTriggers.cs:54
A set of parameters for /aggregate/kmeans.
A set of parameters for /visualize/image/labels.
A set of parameters for /visualize/image/classbreak.
CreateTriggerByAreaResponse createTriggerByArea(CreateTriggerByAreaRequest request_)
Sets up an area trigger mechanism for two column_names for one or more tables.
GrantPermissionTableResponse grantPermissionTable(GrantPermissionTableRequest request_)
Grants a table-level permission to a user or role.
A set of results returned by /filter/bybox.
Definition: FilterByBox.cs:131
A set of results returned by /show/proc.
Definition: ShowProc.cs:99
AlterTableResponse alterTable(string table_name, string action, string _value, IDictionary< string, string > options=null)
Apply various modifications to a table or collection.
A set of results returned by /create/user/external.
InsertSymbolResponse insertSymbol(InsertSymbolRequest request_)
Adds a symbol or icon (i.e.
CreateUserExternalResponse createUserExternal(CreateUserExternalRequest request_)
Creates a new external user (a user whose credentials are managed by an external LDAP).
AggregateKMeansResponse aggregateKMeans(AggregateKMeansRequest request_)
This endpoint runs the k-means algorithm - a heuristic algorithm that attempts to do k-means clusteri...
VisualizeVideoResponse visualizeVideo(VisualizeVideoRequest request_)
Creates raster images of data in the given table based on provided input parameters.
ShowTableMetadataResponse showTableMetadata(ShowTableMetadataRequest request_)
Retrieves the user provided metadata for the specified tables.
A set of results returned by /admin/verifydb.
FilterByValueResponse filterByValue(FilterByValueRequest request_)
Calculates which objects from a table has a particular value for a particular column.
A set of parameters for /show/security.
Definition: ShowSecurity.cs:19
FilterByListResponse filterByList(FilterByListRequest request_)
Calculates which records from a table have values in the given list for the corresponding column...
FilterResponse filter(string table_name, string view_name, string expression, IDictionary< string, string > options=null)
Filters data based on the specified expression.
A set of parameters for /kill/proc.
Definition: KillProc.cs:17
A set of parameters for /filter/bystring.
A set of parameters for /filter.
Definition: Filter.cs:25
A set of results returned by /has/proc.
Definition: HasProc.cs:50
HasTableResponse hasTable(string table_name, IDictionary< string, string > options=null)
Checks for the existence of a table with the given name.
A set of parameters for /create/trigger/byarea.
IList< string > type_labels
Type labels of the respective tables in &lt;member name=&quot;table_names&quot;&gt;.
Definition: ShowTable.cs:293
A set of results returned by /has/type.
Definition: HasType.cs:51
ShowTablesByTypeResponse showTablesByType(string type_id, string label, IDictionary< string, string > options=null)
Gets names of the tables whose type matches the given criteria.
FilterResponse filter(FilterRequest request_)
Filters data based on the specified expression.
ShowSecurityResponse showSecurity(IList< string > names, IDictionary< string, string > options)
Shows security information relating to users and/or roles.
CreateRoleResponse createRole(CreateRoleRequest request_)
Creates a new role.
ClearTriggerResponse clearTrigger(ClearTriggerRequest request_)
Clears or cancels the trigger identified by the specified handle.
A set of results returned by /filter/bygeometry.
UpdateRecordsResponse updateRecordsRaw(RawUpdateRecordsRequest request_)
Runs multiple predicate-based updates in a single call.
A set of results returned by /filter/byrange.
A set of parameters for /clear/tablemonitor.
ShowTableMetadataResponse showTableMetadata(IList< string > table_names, IDictionary< string, string > options=null)
Retrieves the user provided metadata for the specified tables.
A set of results returned by /get/records/fromcollection.
ShowProcResponse showProc(ShowProcRequest request_)
Shows information about a proc.
A set of parameters for /delete/user.
Definition: DeleteUser.cs:17
A set of parameters for /show/tables/bytype.
A set of results returned by /show/security.
Definition: ShowSecurity.cs:55
A set of results returned by /filter.
Definition: Filter.cs:157
A set of results returned by /create/table.
Definition: CreateTable.cs:350
InsertRecordsRandomResponse insertRecordsRandom(InsertRecordsRandomRequest request_)
Generates a specified number of random records and adds them to the given table.
ShowSystemStatusResponse showSystemStatus(IDictionary< string, string > options=null)
Provides server configuration and health related status to the caller.
AggregateUniqueResponse aggregateUnique(AggregateUniqueRequest request_)
Returns all the unique values from a particular column (specified by ) of a particular table (specifi...
string label
Value of .
Definition: CreateType.cs:282
A set of parameters for /clear/trigger.
Definition: ClearTrigger.cs:19
A set of parameters for /aggregate/statistics.
ShowTypesResponse showTypes(ShowTypesRequest request_)
Retrieves information for the specified data type.
RevokePermissionSystemResponse revokePermissionSystem(RevokePermissionSystemRequest request_)
Revokes a system-level permission from a user or role.
A set of results returned by /insert/records.
A set of parameters for /insert/records/random.
A set of parameters for /admin/verifydb.
GetRecordsByColumnResponse getRecordsByColumn(GetRecordsByColumnRequest request_)
For a given table, retrieves the values of the given columns within a given range.
A set of results returned by /get/records/byseries.
A set of parameters for /filter/bytable.
A set of results returned by /aggregate/statistics/byrange.
FilterByBoxResponse filterByBox(FilterByBoxRequest request_)
Calculates how many objects within the given table lie in a rectangular box.
A set of results returned by /show/proc/status.
A set of parameters for /create/user/internal.
ClearTableResponse clearTable(string table_name="", string authorization="", IDictionary< string, string > options=null)
Clears (drops) one or all tables in the database cluster.
A set of results returned by /lock/table.
Definition: LockTable.cs:99
A set of results returned by /aggregate/statistics.
UpdateRecordsBySeriesResponse updateRecordsBySeries(UpdateRecordsBySeriesRequest request_)
Updates the view specified by to include full series (track) information from the for the series (t...
A set of results returned by /alter/table.
Definition: AlterTable.cs:295
CreateProjectionResponse createProjection(CreateProjectionRequest request_)
Creates a new projection of an existing table.
InsertRecordsResponse insertRecordsRaw(RawInsertRecordsRequest request_)
Adds multiple records to the specified table.
AdminVerifyDbResponse adminVerifyDb(AdminVerifyDbRequest request_)
Verify database is in a consistent state.
A set of parameters for /create/jointable.
A set of parameters for /show/system/status.
A set of parameters for /execute/proc.
Definition: ExecuteProc.cs:18
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 /alter/table/metadata.
A set of parameters for /create/role.
Definition: CreateRole.cs:17
A set of results returned by /create/type.
Definition: CreateType.cs:269
A set of parameters for /aggregate/unique.
AggregateGroupByResponse aggregateGroupBy(string table_name, IList< string > column_names, long offset, long limit=1000, IDictionary< string, string > options=null)
Calculates unique combinations (groups) of values for the given columns in a given table/view/collect...
A set of results returned by /show/types.
Definition: ShowTypes.cs:63
A set of results returned by /delete/user.
Definition: DeleteUser.cs:51
AggregateKMeansResponse aggregateKMeans(string table_name, IList< string > column_names, int k, double tolerance, IDictionary< string, string > options=null)
This endpoint runs the k-means algorithm - a heuristic algorithm that attempts to do k-means clusteri...
A set of results returned by /admin/offline.
Definition: AdminOffline.cs:66
DeleteProcResponse deleteProc(DeleteProcRequest request_)
Deletes a proc.
A set of results returned by /filter/bylist.
DeleteRecordsResponse deleteRecords(string table_name, IList< string > expressions, IDictionary< string, string > options=null)
Deletes record(s) matching the provided criteria from the given table.
CreateTableMonitorResponse createTableMonitor(string table_name, IDictionary< string, string > options=null)
Creates a monitor that watches for new records inserted into a particular table (identified by table_...
A set of parameters for /admin/offline.
Definition: AdminOffline.cs:18
A set of parameters for /has/table.
Definition: HasTable.cs:17
AggregateConvexHullResponse aggregateConvexHull(string table_name, string x_column_name, string y_column_name, IDictionary< string, string > options=null)
Calculates and returns the convex hull for the values in a table specified by table_name ...
GetRecordsByColumnResponse getRecordsByColumn(string table_name, IList< string > column_names, long offset, long limit, IDictionary< string, string > options=null)
For a given table, retrieves the values of the given columns within a given range.
A set of parameters for /aggregate/groupby.
A set of parameters for /admin/getshardassignments.
A set of results returned by /delete/proc.
Definition: DeleteProc.cs:52
A set of parameters for /revoke/permission/table.
A set of parameters for /filter/bybox.
Definition: FilterByBox.cs:23
A set of parameters for /show/triggers.
Definition: ShowTriggers.cs:18