[Postgres Sink] Using Wrong datatype while cerating table

[dominikriemer]

Starting the default ISS adapter and using th postgres sink together with the internal docker container.

I get following error:

org.apache.streampipes.commons.exceptions.SpRuntimeException: ERROR: type "double" does not exist

 Position: 56

This happens during creating the table.

Following create statement is used:

CREATE TABLE "tabler" ( "timestamp" FLOAT, "longitude" DOUBLE, "latitude" DOUBLE );

but instead of double, float should be used like in timestamp.
But don't know why double is used only in this case. This happens in the

statement.append(extractEventProperties(eventProperties))

Method in the JdbcClient.class

The generel error is:

org.apache.streampipes.commons.exceptions.SpRuntimeException: ERROR: type "double" does not exist

 Position: 55
	at org.apache.streampipes.sinks.databases.jvm.jdbcclient.JdbcClient.createTable(JdbcClient.java:446)
	at
org.apache.streampipes.sinks.databases.jvm.jdbcclient.JdbcClient.ensureTableExists(JdbcClient.java:258)
	at
org.apache.streampipes.sinks.databases.jvm.jdbcclient.JdbcClient.connect(JdbcClient.java:212)
	at org.apache.streampipes.sinks.databases.jvm.jdbcclient.JdbcClient.initializeJdbc(JdbcClient.java:196)
	at
org.apache.streampipes.sinks.databases.jvm.postgresql.PostgreSql.onInvocation(PostgreSql.java:39)
	at
org.apache.streampipes.sinks.databases.jvm.postgresql.PostgreSql.onInvocation(PostgreSql.java:28)
...

Imported from Jira STREAMPIPES-127. Original Jira may contain additional context.
Reported by: micklich.