pipelinedb unrecognized node type: 5009

Question

I have a problem creating Continuous Transform from any client but psql.

Reproduce:

1. OS: OSX EL Capitan 10.11.6
2. Docker version 17.09.0-ce, build afdb6d4
3. docker run -d -p 5432:5432 pipelinedb/pipelinedb

Now, I connect to DB via PHPStorm 2017.2, it is OK.

I create some streams with query:

CREATE STREAM some_stream (id INT, amount INT).

It is also OK.

Then I try to create CONTINUOUS TRANSFORM with query:

CREATE CONTINUOUS TRANSFORM my_transform AS SELECT id, amount FROM some_stream

And there I get an error: "unrecognized node type: 5009".

But! I tried this query with psql:

psql -h localhost -p 5432 -d pipeline -Upipeline -c "CREATE CONTINUOUS TRANSFORM my_transform AS SELECT id, amount FROM some_stream"

And it works! No error! That's the problem.

I tried to execute this query via php-doctrine-migration, via php-adminer, and there I have the same error.

Does anybody know, what is it? Why it works only with psql?

Answer 1

Can you try using the 0.9.8 version? e.g.,

docker run -d -p 5432:5432 pipelinedb/pipelinedb:0.9.8