timescale / outflux

Export data from InfluxDB to TimescaleDB
Apache License 2.0
90 stars 22 forks source link

migrate command fails on tables with ~ 1300 columns #74

Open lazzarello opened 4 years ago

lazzarello commented 4 years ago

I manage many influxdb databases with scientific data. Some measurements have thousands of fields. I migrated the schema for a measurement with 1335 fields successfully. When I did the data migration, the default procedure threw this error

# 2019/10/25 14:56:23 pipe_lunch.gse_ext:Pulling chunks with size 15000
# 2019/10/25 14:56:23 'pipe_lunch.gse_ext': extractor 'pipe_lunch.gse_ext' could not execute a chunked query.
# expected json response, got "text/html", with status: 414 and response body: "<html>\r\n<head><title>414 Request-URI Too Large</title></head>\r\n<body bgcolor=\"white\">\r\n<center><h1>414 Request-URI Too Large</h1></center>\r\n</body>\r\n</html>\r\n"

Is there a different way to migrate a measurement like mine?