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



-h, --help

display help


display information about the parsers


display the build version and date


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


specify the offset between each line’s timestamp


add dummy column names in the first line


use tabulations to separate values

5.9.3. Program Options

-h, --help

Displays help about the program’s options.


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


Displays the build version and date.


Displays additional information at runtime.

-f, --file=<path_to_file>

Specifies the generated CSV file.


The file’s name.

-s, --size=<file_size>

Specifies the file’s maximum size.


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.


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.


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.


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


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


Use tabulations instead of commas to separate the values.

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