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; |