CREATE table array_of_json (
id Int32,
details JSON
)
ENGINE = Memory;
INSERT INTO array_of_json VALUES
(1, '{"offers": [{"bundle_id":"bundle_2","currency":"PHP","offer_name":"offer2","place":"2"},{"bundle_id":"bundle_1","currency":"PHP","offer_name":"offer1","place":"1"}], "value": 100}'),
(2, '{"offers": [{"bundle_id":"bundle_3","currency":"PHP","offer_name":"offer3","place":"3"},{"bundle_id":"bundle_4","currency":"PHP","offer_name":"offer4","place":"4"}], "value": 100}');
SELECT *
FROM array_of_json;
Description
There is an exception in clickhouse driver 0.9.2
[HY000] Failed to read value for column details Unsupported data type with tag 101Probably because of Array of JSONs
Steps to reproduce
Run this queries in DataGrip:
Error Log or Exception StackTrace
Expected Behaviour
Code Example
Configuration
Client Configuration
Environment
ClickHouse Server