Dale McDiarmid
Dale McDiarmid
```create table test_json (col JSON) ENGINE=MergeTree PRIMARY KEY(col)``` is not valid ```Code: 549. DB::Exception: Received from oudbme6scf.us-east-2.aws.clickhouse.cloud:9440. DB::Exception: Column `col` with type Object('json') is not allowed in key expression, it's...
Added to above. welcome contributions otherwise this will be v3 I suspect.
Should be fixed in 2.0 beta. Can you test @Alan01252 ?
@Alan01252 2.0 is out, please test
thanks @Alan01252 not quite sure how you want this data returned - you can use transformations in Grafana to unfold the array if needed. Are you looking for a row...
@Alan01252 sorry was ooto.  I'm still not clear how you want this to render. Are you expecting a separate series for each entry of the array e.g. all position...
ok now i understand the intention i think we can do something. thank you @Alan01252 and sorry for the delay.
@bossinc please change title to "Support for derived fields for cross datasource linking"
We will support JSON type properly and avoid JSONEachRow - the driver uses native format. See https://github.com/grafana/clickhouse-datasource/issues/129
Format controls the response format from ClickHouse. The [driver](https://github.com/ClickHouse/clickhouse-go) uses the native format for performance reasons - Grafana uses this for communication. Introducing support in the driver for JSONEachRow just...