ClickHouse / ClickHouse/ClickHouse
Inconsistency in default quoting_character between toString and extractKeyValuePairs
Open
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
Assessment
This issue has not been assessed yet.