timescale / tsbs

Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
MIT License
1.28k stars 300 forks source link

tsbs_load_influx: parse error #95

Open juliaabra opened 5 years ago

juliaabra commented 5 years ago

Hello guys,

data and query generation works fine, but by using the tsbs_load_influx binary, following error occurs: data_queries_gen Even with supplying all arguments, the error remains: parse_error Obviously, a database is created (here seen in chronograf): chronograf_db But no results can be shown: db_query_result The .csv file is also empty, showing only the row names but no measurement values. When processing as described in the documentation, the file is correctly written, but this does not apply to the binary.

mikkelangaju commented 4 years ago

This happens because you are trying to load a gzipped file and tsbs_load_influx doesn't expect zipped data- If you take a look in /scripts/load_influx.sh you can see that it runs cat ${DATA_FILE} | gunzip | $EXE_FILE_NAME \ --db-name=${DATABASE_NAME} \ --backoff=${BACKOFF_SECS} \ --workers=${NUM_WORKERS} \ --batch-size=${BATCH_SIZE} \ --reporting-period=${REPORTING_PERIOD} \ --urls=http://${DATABASE_HOST}:${DATABASE_PORT} Where gunzip is the missing step in what you are running.

The docs could definitely be updated to show this as we also ran into this issue.