Tuple Insert from JSONEachRow not working about clickhouse

[Algunenano]

You are declaring an array, not a tuple.

The correct way would be:

INSERT INTO http (`@timestamp`, clientip, request, status, size) FORMAT JSONEachRow
    {"@timestamp":893964617,"clientip":"40.135.0.0","request":{"method":"GET", "path":"/images/hm_bg.jpg", "version":"HTTP/1.0"},"status":200,"size":24736}

[DJRickyB]

I copied the example directly from the documentation. This was working for us until an attempted upgrade.

…

On Thu, May 23, 2024, 6:00 AM Raúl Marín ***@***.***> wrote: You are declaring an array, not a tuple. The correct way would be: INSERT INTO http ***@***.***`, clientip, request, status, size) FORMAT JSONEachRow ***@***.***":893964617,"clientip":"40.135.0.0","request":{"method":"GET", "path":"/images/hm_bg.jpg", "version":"HTTP/1.0"},"status":200,"size":24736} — Reply to this email directly, view it on GitHub <#64242 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABZBUUNYF75ZUOPBUDWZWWTZDW44DAVCNFSM6AAAAABIEQOQMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRWG4YTAMZSG4> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Algunenano]

It seems the documentation is wrong. Which version did you check that it was working?

https://fiddle.clickhouse.com/e60fbefc-150e-4248-ab87-78d9a0005a29

[DJRickyB]

It was working up to 22.5

…

On Thu, May 23, 2024, 6:45 AM Raúl Marín ***@***.***> wrote: It seems the documentation is wrong. Which version did you check that it was working? https://fiddle.clickhouse.com/e60fbefc-150e-4248-ab87-78d9a0005a29 — Reply to this email directly, view it on GitHub <#64242 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABZBUUMOBFG5HZ3VK2NARF3ZDXCFPAVCNFSM6AAAAABIEQOQMKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRWG44TOOJYGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Algunenano]

It doesn't work in 22.5: https://fiddle.clickhouse.com/ad77fdc9-cf61-4cf0-b5a3-2279700116d7

[DJRickyB]

Error on processing query: Code: 26. DB::ParsingException: Cannot parse JSON string: expected opening quote:

Apologies, it looks like the copy from the documentation included a newline character. It does work in 22.5: https://fiddle.clickhouse.com/227d593c-10ad-4be6-ab8c-13c6f781c707

[DJRickyB]

I have updated the description with the fiddle, the fixed query copy, and the last working version