Tuple Insert from JSONEachRow not working

[DJRickyB]

Describe what's wrong

Using Clickhouse 24.3.3.102, I cannot follow the following from the documentation:

Does it reproduce on the most recent release?

The list of releases

How to reproduce

DROP TABLE IF EXISTS http;

CREATE table http
(
    `@timestamp` Int32 EPHEMERAL 0,
    clientip     IPv4,
    request Tuple(method LowCardinality(String), path String, version LowCardinality(String)),
    status       UInt16,
    size         UInt32,
    timestamp    DateTime DEFAULT toDateTime(`@timestamp`)
) ENGINE = MergeTree() ORDER BY (status, timestamp);

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

Error:

Expected behavior

Success

Error message and/or stacktrace

Ok.
Exception on client:
Code: 27. DB::Exception: Cannot parse input: expected '{' before: '["GET", "/images/hm_bg.jpg", "HTTP/1.0"],\n    "status":200,"size":24736}': (while reading the value of key request): (at row 1)
: While executing ParallelParsingBlockInputFormat: data for INSERT was parsed from query. (CANNOT_PARSE_INPUT_ASSERTION_FAILED)

Seems it is asking for Tuples to have their field names included in this input format.

This is working in 22.5 : https://fiddle.clickhouse.com/227d593c-10ad-4be6-ab8c-13c6f781c707 but not past that

[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