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

多表关联查询执行异常(超过两个表)。 #405

Open
zhangtiegang2014 opened this issue Nov 22, 2024 · 0 comments
Open

多表关联查询执行异常(超过两个表)。 #405

zhangtiegang2014 opened this issue Nov 22, 2024 · 0 comments

Comments

@zhangtiegang2014
Copy link

./brokerctl run "select min(ps_supplycost) from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'BRAZIL';" --project-id "demo" --host http://localhost:8071 --timeout 30

Error: run query: DoQuery response: {
"status": {
"code": 320,
"message": "RunExecutionPlan run jobs(586ff267-a894-11ef-922a-0242ac120006) failed, catch std::exception=[engine/datasource/odbc_adaptor.cc:44] catch unexpected Poco::Data::DataException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error\t[mysql_stmt_error]: Unknown column 'supplier.S_NATIONKEY' in 'on clause'\t[mysql_stmt_errno]: 1054\t[mysql_stmt_sqlstate]: 42S22\t[statemnt]: select min(partsupp.PS_SUPPLYCOST) as expr_17 from alice.partsupp join (select nation.N_NAME,nation.N_NATIONKEY from alice.nation where nation.N_NAME='BRAZIL') as t_1 on supplier.S_NATIONKEY=t_1.N_NATIONKEY"
}
}
超过两个表关联查询时都会报错,即使所有表都在同一方,求解答。

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