You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@flink.apache.org by Paul Lam <pa...@gmail.com> on 2021/08/12 04:09:45 UTC

Questions on usage of SQL hints

Hi community,

I’m trying out SQL hints on DML, but there’s not very much about the supported SQL hints on the docs. 

Are the SQL hints limited to source/sink tables only at the moment? And where can I find the full list of 
supported SQL hints?

Thanks in advance!

Best,
Paul Lam

Re: Questions on usage of SQL hints

Posted by JING ZHANG <be...@gmail.com>.

Hi Paul,
I'm very happy to hear that.😀,

Paul Lam <pa...@gmail.com> 于2021年8月12日周四 下午3:17写道：

> Hi JING,
>
> Thanks for your inputs! It helps a lot.
>
> Best,
> Paul Lam
>
> 2021年8月12日 13:13，JING ZHANG <be...@gmail.com> 写道：
>
> Hi Paul,
> There are Table hints and Query hints.
> Query hints are on the way, there is a JIRA to track this issue [3].
> AFAIK, the issue is almost close to submit a pull request now.
>
> Table hints[1][2] are already supported since Flink 1.11. You could find
> more detail information in [1][2].
> For table hints, you could define any valid connector properties in
> OPTIONS hint, framework would merge those properties defined in OPTIONS
> hint with properties defined in DDL, then try to find a table factory.
>
> [1]
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL
> [2]
> https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/
> [3] https://issues.apache.org/jira/browse/FLINK-20670
>
> Best,
> JING ZHANG
>
> Paul Lam <pa...@gmail.com> 于2021年8月12日周四 下午12:10写道：
>
>> Hi community,
>>
>> I’m trying out SQL hints on DML, but there’s not very much about the
>> supported SQL hints on the docs.
>>
>> Are the SQL hints limited to source/sink tables only at the moment? And
>> where can I find the full list of
>> supported SQL hints?
>>
>> Thanks in advance!
>>
>> Best,
>> Paul Lam
>>
>>
>

Re: Questions on usage of SQL hints

Posted by Paul Lam <pa...@gmail.com>.

Hi JING,

Thanks for your inputs! It helps a lot.

Best,
Paul Lam

> 2021年8月12日 13:13，JING ZHANG <be...@gmail.com> 写道：
> 
> Hi Paul,
> There are Table hints and Query hints. 
> Query hints are on the way, there is a JIRA to track this issue [3]. AFAIK, the issue is almost close to submit a pull request now.
> 
> Table hints[1][2] are already supported since Flink 1.11. You could find more detail information in [1][2].
> For table hints, you could define any valid connector properties in OPTIONS hint, framework would merge those properties defined in OPTIONS hint with properties defined in DDL, then try to find a table factory.
> 
> [1] https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL <https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL>
> [2] https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/ <https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/>
> [3] https://issues.apache.org/jira/browse/FLINK-20670 <https://issues.apache.org/jira/browse/FLINK-20670>
> 
> Best,
> JING ZHANG
> 
> Paul Lam <paullin3280@gmail.com <ma...@gmail.com>> 于2021年8月12日周四 下午12:10写道：
> Hi community,
> 
> I’m trying out SQL hints on DML, but there’s not very much about the supported SQL hints on the docs. 
> 
> Are the SQL hints limited to source/sink tables only at the moment? And where can I find the full list of 
> supported SQL hints?
> 
> Thanks in advance!
> 
> Best,
> Paul Lam
>

Re: Questions on usage of SQL hints

Posted by JING ZHANG <be...@gmail.com>.

Hi Paul,
There are Table hints and Query hints.
Query hints are on the way, there is a JIRA to track this issue [3]. AFAIK,
the issue is almost close to submit a pull request now.

Table hints[1][2] are already supported since Flink 1.11. You could find
more detail information in [1][2].
For table hints, you could define any valid connector properties in OPTIONS
hint, framework would merge those properties defined in OPTIONS hint with
properties defined in DDL, then try to find a table factory.

[1]
https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL
[2]
https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/
[3] https://issues.apache.org/jira/browse/FLINK-20670

Best,
JING ZHANG

Paul Lam <pa...@gmail.com> 于2021年8月12日周四 下午12:10写道：

> Hi community,
>
> I’m trying out SQL hints on DML, but there’s not very much about the
> supported SQL hints on the docs.
>
> Are the SQL hints limited to source/sink tables only at the moment? And
> where can I find the full list of
> supported SQL hints?
>
> Thanks in advance!
>
> Best,
> Paul Lam
>
>