To dump the content of a database table maintained by a persisting resource, use the following rhino-console command or related MBean operation.

Console command: dumppersistingresourcetable

Command

dumppersistingresourcetable <resource-type> <variant> <keyspace> <table> [-name
name] [-maxrows maxrows] [-timeout timeout] [-notrim]
  Description
    Dump the content of a persisting resource database table. The -name option is
    only required if multiple resources of the same type and variant have been
    configured in Rhino. The -notrim option prevents the truncation of column width.
    By default up to 100 rows are output; use the -maxrows option to change this. If
    -maxrows is given any value less than 1 then all rows found will be returned.

Example

This example outputs the content of the heartbeat table maintained by the Pool Maintenance resource:

$ ./rhino-console dumppersistingresourcetable poolmaintenance cassandra rhino_pool_maintenance heartbeat
Dump of database table: rhino_pool_maintenance.heartbeat
node_id   partition_id   heartbeat_update_time   metadata_update_time
--------  -------------  ----------------------  ---------------------
101                   6       20221122 16:53:44      20221122 16:15:22
102                   7       20221122 16:53:44      20221122 16:53:30
2 rows

MBean operation: dumpTable

MBean

Rhino operation

public TabularData dumpTable(String keyspaceName, String tableName, long timeout, int maxRows)
    throws NullPointerException, InvalidArgumentException,
           UnrecognizedKeyspaceException, UnrecognizedTableNameException,
           TableDumpException, ManagementException;
Previous page Next page
Rhino Version 3.2