How do I use hints in a windowing query on Confluent Flink?
Example of a hint:
/*+ OPTIONS('scan.startup.mode'='latest-offset') */
I would like to use it in a query like below:
INSERT INTO topic2(id, name, avgValue)
SELECT id, name, AVG(value) as avgValue
FROM TABLE(TUMBLE(TABLE topic1, DESCRIPTOR(messageTimestamp), INTERVAL '30' SECONDS))
GROUP BY window_start, window_end, id, name;