isHypertableQueryTemplate incorrect for docker image timescale/timescaledb:2.0.0-pg12

[rafaelrpinto]

Hi, While migrating the data from influxdb I can transfer the schema correctly using outflux schema-transfer but outflux migrate using the schema strategy CreateIfMissing fails with the following error:

2021/01/26 23:57:39 pipe_post: pipe_post: could not prepare ingestor
could not check if table post is hypertable

Since the table post is a hypertable I digged into the code and found that the failed validation uses the query isHypertableQueryTemplate which is :

SELECT EXISTS (
                                    SELECT 1
                                    FROM timescaledb_information.hypertable
                                     WHERE  table_schema = 'public' AND table_name='post')

However the hypertable table is not on timescaledb_information schema, but it is on _timescaledb_catalog.

So currently the only option for us to use outflux is to use the schema strategy DropAndCreate.

Thanks.

[gubbin]

I have a fork with your query fix at https://github.com/hatchdata/outflux but it only works with newer TimescaleDB versions. It would need some version logic before it would be ready for a PR.

[wiebeytec]

I run into the same issue with outlux version 0.2.0. Timescaledb version 2 uses timescaledb_information.hypertables and hypertable_name).

There is a blocked pull request: https://github.com/timescale/outflux/pull/89

[JamesGuthrie]

Fixed in #89