...
The available hint options for each mode:
option type |
---|
'output-mode'='ordere|allow-unordered'
'capacity'='100'
'timeout'='180s'
option name | optional | value type | default value | description | |
---|---|---|---|---|---|
table name | table | N | string | N/A | the table name of the lookup source |
async | async | Y | boolean | N/A | value can be 'true' or 'false' to suggest the planner choose the corresponding lookup function. If the backend lookup source does not support the suggested lookup mode, it will take no effect. |
output-mode | Y | string | ordered | value can be 'ordered' or 'allow-unordered'. 'allow-unordered' means if users allow unordered result, it will attempt to use AsyncDataStream.OutputMode.UNORDERED when it does not affect the correctness of the result, otherwise ORDERED will be still used. | |
capacity | Y | integer | 100 | the buffer capacity for the backend asyncWaitOperator of the lookup join operator. | |
timeout | Y | duration | 300s | timeout from first invoke to final completion of asynchronous operation, may include multiple retries, and will be reset in case of failover | |
retry | retry-predicate | Y | string | N/A | can be 'lookup-miss' which will enable retry if lookup result is empty. |
retry-strategy | Y | string | N/A | can be 'fixed-delay' | |
fixed-delay | Y | duration | N/A | delay time for the 'fixed-delay' strategy | |
max-attempts | Y | integer | N/A | max attempt number of the 'fixed-delay' strategy |
'retry-strategy'='fixed-delay'
'delay'='10s'
'max-attempts'='3'
For these connectors which can have both capabilities of async and sync lookup, our advice for the connector developers are implementing both sync and async interfaces if both capabilities have suitable use cases, the planner will prefer the async one by default, and users can give different option value 'async'='true|false' via the LOOKUP query hint to suggest the planner, otherwise choose one interface to implement.
...