Could not map type <'json')>

[iosifnicolae2]

• Clickhouse table:

  CREATE TABLE default.unit_records
  (
  `unit_id` String,
  `timestamp` DateTime,
  `data` Object('json')
  )
  ENGINE = MergeTree
  PRIMARY KEY (unit_id, timestamp)
  ORDER BY (unit_id, timestamp)
  SETTINGS index_granularity = 8192

• trying to run:

  IMPORT FOREIGN SCHEMA "default" FROM SERVER clickhouse_svr INTO clickhouse;

• we're getting:

  ERROR:  clickhouse_fdw: could not map type <'json')>
  SQL state: XX000

@ildus how can i implement proper mapping for json type?

Many thanks!

EDIT I will try to add the mapping here, hope it solves the problem :) https://github.com/adjust/clickhouse_fdw/blob/fd1f3ec585b73ed61afcd3334db535e79969fb83/src/pglink.c#L735

[iosifnicolae2]

I've implemented a quick fix here: https://github.com/adjust/clickhouse_fdw/pull/88 (this PR must be checked also on an instance without allow_experimental_object_type option enabled)

After merging this PR you will be able to query json fields as below:

SELECT "data.field" FROM clickhouse.unit_records;