[
https://issues.apache.org/jira/browse/CALCITE-4899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17453760#comment-17453760
]
tartarus commented on CALCITE-4899:
-----------------------------------
[~danny0405] thanks for your reply.
In our use of flink SQL, users often need to access external systems, such as
redis and hbase; or other business systems.
For flexible development, users will choose flink udtf.
However, the record-by-record processing method of flink sql is very
inefficient;
So I want to support SQL hints for Correlate, then I can use hints to tell the
engine that this udtf should turn on Mini-batch mode, reduce IO, and prompt
performance.
Do you have any advice?
> Support hint for lateral table syntax
> -------------------------------------
>
> Key: CALCITE-4899
> URL: https://issues.apache.org/jira/browse/CALCITE-4899
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: tartarus
> Priority: Major
>
> I want to add hint for lateral table syntax,
> like this
> {code:java}
> select * from product, lateral table /*+ HINT_NAME(key='value')
> */(RAMP(product.product_id))
> {code}
> then we can pass more information to specific tableFunction
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
