Events.EventParameters JSON is invalid

yandexmobile / appmetrica-logsapi-loader

A tool for automatic data loading from AppMetrica LogsAPI into (local) ClickHouse

https://hub.docker.com/r/yandex/appmetrica-logsapi-loader/

22 stars 11 forks source link

Events.EventParameters JSON is invalid #2

Open crazyproger opened 6 years ago

crazyproger commented 6 years ago

ELECT EventParameters
FROM events_all
LIMIT 1

┌─EventParameters────────────────────────────────────┐
│ "{""GroupID"":""Default"",""PlayerID"":""...

It is inserted with escaped quotes(by quotes). Clickhouse JSON functions can't parse this JSON, only this workaround is working replaceAll(EventParameters, \'""\', \'"\').