Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

Name	Description
CreateTable	Creates the specified table in Apache HBase.
DeleteTable	Deletes the specified table from Apache HBase.
UpdateTable	Updates (adds or modifies the column family) the specified table in Apache HBase.

Creates the specified table in Apache HBase.

Name	Type	Description
TableName	String	The name of the table you wish to create. If the table already exists in Apache HBase, the existing schema will be replaced with the one specified by ColumnFamily.
ColumnFamily#	String	The name of the column family to add to the table. At least one is required.

Name	Type	Description
Success	String	Returns true if the operation is successful, else an exception is returned.

Deletes the specified table from Apache HBase.

Name	Type	Description
Success	String	Returns true if the operation is successful, else an exception is returned.

Updates (adds or modifies the column family) the specified table in Apache HBase.

Name	Type	Description
TableName	String	The name of the table you wish to update. If the table does not exist, it will be created.
ColumnFamily#	String	The name of the column family to add or modify in the table. At least one is required.

Name	Type	Description
Success	String	Returns true if the operation is successful, else an exception is returned.