ClickHouse / ClickHouse/ClickHouse

Inconsistency in default quoting_character between toString and extractKeyValuePairs

Open
#68,642 1 comment 0 reactions 0 assignees View on GitHub
comp-regular-function external unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

**Describe the unexpected behaviour**

If a column of type 'Map( String, String)' is converted to a string a ' is used as quoting character.
On the other hand the default quoting character for extractKeyValuePars is ".

In order to copy column entries of type map, with external tools a consistent use of quoting characters is needed, otherwise wrong data is imported.

A small example can be found here:
https://fiddle.clickhouse.com/daee178b-d29e-4aab-ae78-ed82d5a3d494

It would be great if there is either a way to change the default quoting_charater for toString or extractKeyValuePairs.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.