search

timescale / tsbs

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

data file in invalid format #85

Closed neucloudzouaodi closed 5 years ago

neucloudzouaodi commented 5 years ago

tsbs_load_timescaledb -batch-size 15000 -db-name benchmark -host 1 27.0.0.1 -port 5432 -user postgres -pass 123456 -file E:/tmp/timescaledb-data2.g z -force-text-format false

data file in invalid format; got �7(t��=j expected tags

atanasovskib commented 5 years ago

You can't feed a gzip file directly to the loaders (tsbsload* commands) with the --file flag. They expect it extracted. But without the --file flag tsbs_load_timescale will expect the data on STDIN. So you can execute something like this on mac and linux cat timescle_data.gz | gunzip | ./tsbs_load_timescaledb --user=postgres --pass=123456 ...other-flags-here On Windows I think you'll need PowerShell for the pipes