You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "lincoln lee (Jira)" <ji...@apache.org> on 2022/08/26 07:28:00 UTC
[jira] [Created] (FLINK-29113) Join hint with invalid table name mixed with valid names will not raise an error
lincoln lee created FLINK-29113:
-----------------------------------
Summary: Join hint with invalid table name mixed with valid names will not raise an error
Key: FLINK-29113
URL: https://issues.apache.org/jira/browse/FLINK-29113
Project: Flink
Issue Type: Bug
Reporter: lincoln lee
Attachments: image-2022-08-26-15-26-33-305.png
add a BROADCAST hint to tpch q2 with a non exists table 'supp' works fine, while a single invalid table name 'supp' will raise an error
```sql
explain SELECT /*+ BROADCAST(partsupp,supp) */
s_acctbal,
s_name,
n_name,
p_partkey,
p_mfgr,
s_address,
s_phone,
s_comment
FROM
part,
supplier,
partsupp,
nation,
region
WHERE
p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND p_size = 15
AND p_type LIKE '%BRASS'
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'EUROPE'
AND ps_supplycost = (
SELECT min(ps_supplycost)
FROM
partsupp, supplier,
nation, region
WHERE
p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'EUROPE'
)
ORDER BY
s_acctbal DESC,
n_name,
s_name,
p_partkey
LIMIT 100
```
!image-2022-08-26-15-26-33-305.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)