Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Elements of string array are wrapped in single quotes #77

Open
konovalov-maksim opened this issue Nov 16, 2021 · 0 comments
Open

Elements of string array are wrapped in single quotes #77

konovalov-maksim opened this issue Nov 16, 2021 · 0 comments

Comments

@konovalov-maksim
Copy link

I faced an issue while trying to read from string array. Selected string elements are wrapped in single quotes

Reproducing

Clickhouse

create table example_ch
(
    array_of_strings_field Array(String)
)
engine = MergeTree PRIMARY KEY array_of_strings_field;

insert into example_ch (array_of_strings_field) values (['foo', 'bar']);

Postgres

create foreign table example_pg
    (
        array_of_strings_field text[]
     )
server clickhouse_server
options (database 'clickhouse_db', table_name 'example_ch', engine 'MergeTree');

select array_of_strings_field[1] from example_pg;

Expected output:
foo
Actual output:
'foo'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant