I am backfilling a table with a date dimension. I observed that if there is a unique date in the input data, insert fails. No chunk can be found, and zero rows are moved.
Worth to mention that I start from an empty hypertable, maybe this is the source of the problems? If there are several dates in the data, behaviour is as expected. A new chunk is created successfully.
Workaround is to insert more input data into the temporary staging table, making sure there are several dates in there.