yamcs tables¶

Synopsis¶

Description¶

Read and manipulate tables.

Commands¶

list

List tables

describe <TABLE>

Describe a table

dump [-d <DIR>, --dir <DIR>] [-q <QUERY>, --query <QUERY>] [--query-file FILE] [--gzip] <TABLE>...

Dump table data

load [-d <DIR>, --dir <DIR>] [--gzip] <TABLE>...

Load data into a table

rebuild-histogram [-s <DATE>, --since <DATE>] [-u <DATE>, --until <DATE>] <TABLE>...

Rebuilds the histogram for a table. This may be necessary for example after bulk loading data.

Options¶

-d <DIR>, --dir <DIR>¶

Specifies the directory where to locate dump files. Defaults to current directory.

--gzip¶

With dump, compress the output.

With load, decompress the dump.

-q <QUERY>, --query <QUERY>¶

With dump, provide a SQL WHERE search condition to limit the rows included in the output.

--query-file <FILE>¶

With dump, specify the path to a file containing a SQL WHERE search condition to limit the rows included in the output.

-s <DATE>, --since <DATE>¶

With rebuild-histogram, include records not older than the specified date.

The date should be specified in ISO format or as detailed under Timestamps.

-u <DATE>, --until <DATE>¶

With rebuild-histogram, include records not newer than the specified date.

The date should be specified in ISO format or as detailed under Timestamps.

Timestamps¶

When parsing timestamps, yamcs-cli accepts a specification in ISO format. The following special patterns are also recognised:

• now: current time

• now UTC: current UTC time

• today: 00:00:00 of the current day

• today UTC: 00:00:00 UTC of the current day

• yesterday: 00:00:00 of the day before

• yesterday UTC: 00:00:00 UTC of the day before

• tomorrow: 00:00:00 of the next day

• tomorrow UTC: 00:00:00 UTC of the next day