Enabling Input Tables

For users in your enterprise to create Input Tables, a system administrator must deploy the table definition and create the Tables table, a user table that the system uses to keep track of Input Tables.

1. Deploy table definition

First you need to create a schema named DbConfig.Tables.schema, with the following content:

<Table name="Tables" namespace="DbConfig" storageType="NestedPartitionedOnDisk" >
   <Partitions keyFormula="__WRITABLE_PARTITIONS__[abs((__NS_TN__ + Sym).hashCode() + __DAY_OF_YEAR__) % __NUM_WRITABLE_PARTITIONS__]"/>
   <Column name="Date" dataType="String" columnType="Partitioning" /> 
   <Column name="Namespace" dataType="String" columnType="Normal" />
   <Column name="TableName" dataType="String" columnType="Normal" />
   <Column name="TableInputHandlerBlob" dataType="byte[]" columnType="Normal" /> 
   <Column name="_WorkerName" dataType="String" columnType="Normal" />
   <Column name="_ServerHostName" dataType="String" columnType="Normal" />
   <Column name="_ClientHostName" dataType="String" columnType="Normal" />
   <Column name="_ChangeTime" dataType="DateTime" columnType="Normal" />
   <Column name="_Deleted" dataType="Boolean" columnType="Normal" />
</Table>

Note: the namespace here is DbConfig.

Place the file in /etc/sysconfig/illumon.d/schema (or the desired path if the file is being configured differently).

Deploy the schema:

sudo service iris deploy_schema -f <fully qualified schema file name>

2. Create a user table using the definition:

tableDef = db.getTableDefinition("DbConfig", "Tables")
db.addPartitionedTableDefinition("__DbConfig", "Tables", "Date", tableDef)

Note: the namespace here is __DbConfig.
Users must still be granted write access to Input tables via the ACL Editor before they will be able to create or edit Input Tables.

Once this is accomplished, it is possible to add and edit Input Tables in the Deephaven console.

See Input Tables in the User Guide for more information.

Last Updated: 25 February 2020 08:26 -05:00 UTC Deephaven v.1.20200121 (See other versions)