ClickHouse / ClickHouse/ClickHouse
JOIN with direct dictionary: Function tuple requires at least one argument error
- 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
Assessment
This issue has not been assessed yet.