clickhouse_driver.errors.UnknownTypeError: Code: 50. Unknown type Object('json')

[mike-luabase]

driver doesn't support new JSON type added in 22.3 (I'm using 22.3.3.44 )

[mike-luabase]

Looks like I should be able to add something like this, but unclear which create_ is best to start as a base

elif spec.startswith('Object'):
        print('Object.....', spec)
        return create_tuple_column(spec, column_options)

[xzkostyan]

Hi.

You've figured out an "entrypoint" for new columns. Usually new column is the combination of an existing columns. But this is not always true. Some columns are tough nuts to crack.

If you're not scared of C++/reversing you should inspect ClickHouse server sources or use wireshark / tcpdump to see what's going on "the wire".

A brief how to is placed here: https://github.com/mymarilyn/clickhouse-driver/blob/master/clickhouse_driver/columns/base.py#L139

[matheosz1]

+1 for this feature request.

[konnectr]

Now there is official docs https://clickhouse.com/docs/en/native-protocol

[hauthorn]

@konnectr do you see JSON listed there yet? I was unable to locate documentation for JSON as of right now.

(not really sure if I would be able to implement it even if it was documented, but I am curious to try)

[acmeguy]

+1 for this - does anyone have a workaround?

[rejochandran]

+1 for this

[rejochandran]

Has anyone used any workarounds for this?

[MeteHanC]

I used clickhouse-connect library instead and it worked fine @rejochandran

[xzkostyan]

Version 0.2.6 has json support