ClickHouse / ClickHouse/ClickHouse

JOIN with direct dictionary: Function tuple requires at least one argument error

Open
#47,568 1 comment 1 reaction 0 assignees View on GitHub
comp-dictionary comp-joins
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

```sql
create table foo (id UInt64, name String, value String) ENGINE = MergeTree ORDER BY id;

insert into foo SELECT number, 'key' || toString(number), 'val' || toString(number) from numbers(100);

create table bar (key String, value String) ENGINE = MergeTree ORDER BY key;

insert into bar SELECT 'key' || toString(number), 'val' || toString(number) from numbers(10, 150);

CREATE DICTIONARY dict_bar ( key String, value String )
PRIMARY KEY key
SOURCE(CLICKHOUSE(DATABASE currentDatabase() TABLE 'bar'))
LAYOUT(COMPLEX_KEY_DIRECT())
;

select * from foo join dict_bar AS t ON foo.name = t.key SETTINGS join_algorithm = 'direct';

Received exception from server (version 23.3.1):
Code: 42. DB::Exception: Received from localhost:9000. DB::Exception: Function tuple requires at least one argument.: While processing tuple(). (NUMBER_OF_ARGUMENTS_DOESNT_MATCH)

```

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.