文档上是在 create table 的时候, 设置 lookup.join.cache.ttl 但是我现在想用 streaming kafka 的数据,join 一张已经存在的 Hive 表,怎么设置TTL?
CREATE TABLE dimension_table ( product_id STRING, product_name STRING, unit_price DECIMAL(10, 4), pv_count BIGINT, like_count BIGINT, comment_count BIGINT, update_time TIMESTAMP(3), update_user STRING, ...) TBLPROPERTIES ( 'streaming-source.enable' = 'false', -- option with default value, can be ignored. 'streaming-source.partition.include' = 'all', -- option with default value, can be ignored. 'lookup.join.cache.ttl' = '12 h');