[
https://issues.apache.org/jira/browse/FLINK-29113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
godfrey he updated FLINK-29113:
-------------------------------
Component/s: Table SQL / Planner
> 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
> Components: Table SQL / Planner
> Reporter: lincoln lee
> Assignee: xuyang
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.16.0, 1.17.0
>
> 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)
