Kinetica C# API  Version 7.0.19.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
kinetica.ShowTableRequest Class Reference

A set of parameters for Kinetica.showTable(string,IDictionary{string, string}). More...

+ Inheritance diagram for kinetica.ShowTableRequest:
+ Collaboration diagram for kinetica.ShowTableRequest:

Classes

struct  Options
 Optional parameters. More...
 

Public Member Functions

 ShowTableRequest ()
 Constructs a ShowTableRequest object with default parameters. More...
 
 ShowTableRequest (string table_name, IDictionary< string, string > options=null)
 Constructs a ShowTableRequest object with the specified parameters. More...
 
- Public Member Functions inherited from kinetica.KineticaData
 KineticaData (KineticaType type)
 Constructor from Kinetica Type More...
 
 KineticaData (System.Type type=null)
 Default constructor, with optional System.Type More...
 
object Get (int fieldPos)
 Retrieve a specific property from this object More...
 
void Put (int fieldPos, object fieldValue)
 Write a specific property to this object More...
 

Properties

string table_name [get, set]
 Name of the table for which to retrieve the information. More...
 
IDictionary< string, string > options [get, set]
 Optional parameters. More...
 
- Properties inherited from kinetica.KineticaData
Schema Schema [get]
 Avro Schema for this class More...
 

Additional Inherited Members

- Static Public Member Functions inherited from kinetica.KineticaData
static RecordSchema SchemaFromType (System.Type t, KineticaType ktype=null)
 Create an Avro Schema from a System.Type and a KineticaType. More...
 

Detailed Description

A set of parameters for Kinetica.showTable(string,IDictionary{string, string}).


Retrieves detailed information about a table, view, or collection, specified in table_name. If the supplied table_name is a collection, the call can return information about either the collection itself or the tables and views it contains. If table_name is empty, information about all collections and top-level tables and views can be returned.
If the option get_sizes is set to true, then the number of records in each table is returned (in <member name="sizes"> and <member name="full_sizes">), along with the total number of objects across all requested tables (in <member name="total_size"> and <member name="total_full_size">).
For a collection, setting the show_children option to false returns only information about the collection itself; setting show_children to true returns a list of tables and views contained in the collection, along with their corresponding detail.
To retrieve a list of every table, view, and collection in the database, set table_name to '*' and show_children to true.

Definition at line 41 of file ShowTable.cs.

Constructor & Destructor Documentation

kinetica.ShowTableRequest.ShowTableRequest ( )
inline

Constructs a ShowTableRequest object with default parameters.

Definition at line 369 of file ShowTable.cs.

kinetica.ShowTableRequest.ShowTableRequest ( string  table_name,
IDictionary< string, string >  options = null 
)
inline

Constructs a ShowTableRequest object with the specified parameters.

Parameters
table_nameName of the table for which to retrieve the information. If blank, then information about all collections and top-level tables and views is returned.
optionsOptional parameters.
  • FORCE_SYNCHRONOUS: If true then the table sizes will wait for read lock before returning. Supported values: The default value is TRUE.
  • GET_SIZES: If true then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values: The default value is FALSE.
  • SHOW_CHILDREN: If is a collection, then true will return information about the children of the collection, and false will return information about the collection itself. If is a table or view, show_children must be false. If is empty, then show_children must be true. Supported values: The default value is TRUE.
  • NO_ERROR_IF_NOT_EXISTS: If false will return an error if the provided does not exist. If true then it will return an empty result. Supported values: The default value is FALSE.
  • GET_COLUMN_INFO: If true then column info (memory usage, etc) will be returned. Supported values: The default value is FALSE.
The default value is an empty Dictionary.

Definition at line 485 of file ShowTable.cs.

Property Documentation

IDictionary<string, string> kinetica.ShowTableRequest.options
getset

Optional parameters.

  • FORCE_SYNCHRONOUS: If true then the table sizes will wait for read lock before returning. Supported values: The default value is TRUE.
  • GET_SIZES: If true then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values: The default value is FALSE.
  • SHOW_CHILDREN: If is a collection, then true will return information about the children of the collection, and false will return information about the collection itself. If is a table or view, show_children must be false. If is empty, then show_children must be true. Supported values: The default value is TRUE.
  • NO_ERROR_IF_NOT_EXISTS: If false will return an error if the provided does not exist. If true then it will return an empty result. Supported values: The default value is FALSE.
  • GET_COLUMN_INFO: If true then column info (memory usage, etc) will be returned. Supported values: The default value is FALSE.

The default value is an empty Dictionary.

Definition at line 364 of file ShowTable.cs.

string kinetica.ShowTableRequest.table_name
getset

Name of the table for which to retrieve the information.

If blank, then information about all collections and top-level tables and views is returned.

Definition at line 255 of file ShowTable.cs.


The documentation for this class was generated from the following file: