The error message show the json type is not supported

[gangtao]

the query from front end returns following error:

proton-client works fine:

show create jsonstream

SHOW CREATE TABLE jsonstream

Query id: 5de49d3e-c632-46dd-9b30-4294a7b1e9fb

┌─statement──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ CREATE STREAM default.jsonstream
(`c1` json, `_tp_time` datetime64(3, 'UTC') DEFAULT now64(3, 'UTC') CODEC(DoubleDelta, LZ4), `_tp_index_time` datetime64(3, 'UTC') CODEC(DoubleDelta, LZ4)
)
ENGINE = Stream(1, 1, rand())
PARTITION BY to_YYYYMM(_tp_time)
ORDER BY to_YYYYMMDD(_tp_time)
SETTINGS subtype = 'tabular', index_granularity = 8192 │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.005 sec. 

select * from table(jsonstream);

SELECT
  *
FROM
 table(jsonstream)

Query id: 6c8785aa-9cd4-4ece-827a-888c64a8c959

┌─c1────────────┬────────────────_tp_time─┬──────────_tp_index_time─┐
│ {"a":1,"b":0} │ 2022-06-09 17:51:14.499 │ 2022-06-09 17:51:16.499 │
│ {"a":2,"b":1} │ 2022-06-09 17:51:14.499 │ 2022-06-09 17:51:16.499 │
└───────────────┴─────────────────────────┴─────────────────────────┘

2 rows in set. Elapsed: 0.004 sec. 

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

is this resolved? @qijun-niu-timeplus , @chenziliang ?

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.

[jovezhong]

(Jove Github Bot) assuming it is not done, deferred this ticket to the next sprint.