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

Strange error for distributed table engine #15898

Closed
chang0391 opened this issue Oct 13, 2020 · 1 comment
Closed

Strange error for distributed table engine #15898

chang0391 opened this issue Oct 13, 2020 · 1 comment
Labels
bug Confirmed user-visible misbehaviour in official release comp-joins JOINs duplicate

Comments

@chang0391
Copy link

Describe the bug
I got error "Table default.test_all_2 doesn't exist.. " when I executed tables join with distributed table engine
I already entered database credit_ga, but it report the table doesn't exist in database default, so it's strange
but when I use global join instead of join, I got the result as below.
additional, by my testing, result for global join and join is same for two tables of distributed table engine,
only one table with distributed table engine joins another table with no distributed table engine, which need global join.
so can you explain?thanks

How to reproduce
test-1-118.raipeng.com :) use credit_ga
USE credit_ga
Ok.
0 rows in set. Elapsed: 0.001 sec.
test-1-118.raipeng.com :) select count(1) from test_all a join test_all_2 b on a.name=b.name
SELECT count(1)
FROM test_all AS a
INNER JOIN test_all_2 AS b ON a.name = b.name
↖ Progress: 20.00 rows, 201.00 B (180.34 rows/s., 1.81 KB/s.) 0%
Received exception from server (version 20.9.3):
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Received from 192.168.1.187:9000. DB::Exception: Table default.test_all_2 doesn't exist..
0 rows in set. Elapsed: 0.112 sec.

test-1-118.raipeng.com :) select count(1) from test_all a global join test_all_2 b on a.name=b.name
SELECT count(1)
FROM test_all AS a
GLOBAL INNER JOIN test_all_2 AS b ON a.name = b.name
┌─count(1)─┐
│ 21 │
└──────────┘
1 rows in set. Elapsed: 0.024 sec.

@chang0391 chang0391 added the bug Confirmed user-visible misbehaviour in official release label Oct 13, 2020
@den-crane
Copy link
Contributor

den-crane commented Oct 13, 2020

duplicate: #10471

as a workaround, specify a database in from db.table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Confirmed user-visible misbehaviour in official release comp-joins JOINs duplicate
Projects
None yet
Development

No branches or pull requests

2 participants