We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
I faced an issue while trying to read from string array. Selected string elements are wrapped in single quotes
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'
foo
'foo'
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I faced an issue while trying to read from string array. Selected string elements are wrapped in single quotes
Reproducing
Clickhouse
insert into example_ch (array_of_strings_field) values (['foo', 'bar']);
Postgres
select array_of_strings_field[1] from example_pg;
Expected output:
foo
Actual output:
'foo'
The text was updated successfully, but these errors were encountered: