Table Of Contents

5.9. quasardb CSV generator tool

5.9.1. Introduction

qdb_csv_generator generates CSV files with random values. The timestamp used can be steady in order to have a file that can be realistically imported (with qdb_import).

For example, this command generated a file of 50 megabytes with three columns (one timestamp, on int and one blob) in which the consecutive timestamps are separated by 250 milliseconds:

qdb_csv_generator --file generated_data.csv --size 50MB --parsers 'datetime int64 blob' --ts-offset 250ms

5.9.2. Quick Reference

Option Usage
-h, --help display help
--help-parsers display information about the parsers
--version display the build version and date
--verbose display additional information at runtime
-f, --file specify the generated file
-s, --size specify the file’s size in KB, MB or GB
-p, --parsers specify the parsers corresponding to each column
--ts-offset specify the offset between each line’s timestamp
--add-header add dummy column names in the first line
--tsv use tabulations to separate values

5.9.3. Program Options

-h, --help

Displays help about the program’s options.

--help-parsers

Displays information about the available parsers (described in quasardb insertion tool).

--version

Displays the build version and date.

--verbose

Displays additional information at runtime.

-f, --file=<path_to_file>

Specifies the generated CSV file.

Argument
The file’s name.
-s, --size=<file_size>

Specifies the file’s maximum size.

Argument
The file’s maximum size. Available units: b, Kb, Mb, Gb, Kib, Mib, Gib, B, KB, MB, GB, KiB, MiB and GiB.
-p, --parsers=<parsers_list>

Specifies the values format for each column by giving the corresponding parsers.

Argument
The parsers used for each column’s value, separated by spaces. Available parsers: datetime, iso_8601, date, time, epoch, epoch_ms, epoch_ns, int64, double, blob and quoted_blob.
--ts-offset=<time_offset>

Specifies the offset between consecutive timestamps. The timestamp values correspond to the first timestamp parser given: if “–parsers ‘int64 iso_8601 blob’” is given, then the timestamps are the values of the second column.

Argument
The consecutive timestamps’s offset. Available units: ns, ms, s, min, h, d, w, mon and y.
--add-header

Add dummy column names in the first line, such as “col-0,col-1,…”.

--tsv

Use tabulations instead of commas to separate the values.

arrow_backPrevious
5.8. quasardb export tool
Next arrow_forward
5.10. quasardb configuration generator