How do I manually delete user tables?

Usually, you delete the user tables using the API. But if you get a user table into a state that workers cannot handle via errors or a sequence of definition changes, you can manually reset the state by removing the schema and data files from the command line on a Deephaven server.

Step 1: Delete the schema

Run this command to delete a user table schema:

sudo -u irisadmin /usr/illumon/latest/bin/dhconfig schemas delete UserNamespace.TableName --force

If this is the last table from the namespace, run this command to delete the namespace:

sudo -u irisadmin /usr/illumon/latest/bin/dhconfig schemas delete --operate-on-namespace UserNamespace --force

Step 2: Delete the data files

Depending on the table type, one of the following commands will delete your data. You can find more details about internal partitions and column partitions in the table storage guide.

Delete unpartitioned user table's data:

sudo rm -rf /db/Users/UserNamespace/Tables/TableName/

Delete direct partitioned user table's data:

Delete all the data files under every internal partition and column partition value.

ls -d /db/Users/UserNamespace/Partitions/*/*/TableName | sudo xargs rm -rf

Consider deleting empty directories after this operation.

Delete live partitioned user table's data:

ls -d /db/IntradayUser/UserNamespace/Partitions/*/*/TableName | sudo xargs rm -rf

These files can be found on the same host as the DIS that ingests live user data, which by default is the DIS provided upon installation.