/  Yamcs CLI  /  yamcs tables

yamcs tables

Synopsis

yamcs tables list
yamcs tables describe <TABLE>
yamcs tables dump [-d <DIR>, --dir <DIR>] [--gzip]
[-q <QUERY>, --query <QUERY> ] [--query-file <FILE>]
<TABLE>...
yamcs tables load [-d <DIR>, --dir <DIR>] [--gzip] <TABLE>...
yamcs tables rebuild-histogram [-s <DATE>, --since <DATE>]
[-u <DATE>, --until <DATE>] <TABLE>...

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