flinkStreamSQL icon indicating copy to clipboard operation
flinkStreamSQL copied to clipboard

kudu维表join 出来的数据会有重复

Open toratto opened this issue 4 years ago • 3 comments

---kudu维表语句 CREATE TABLE side_rt_d_spu_sku_relation( spu_id int, sku_ids varchar, PRIMARY KEY(spu_id), PERIOD FOR SYSTEM_TIME )WITH( type ='kudu', master ='xxxxxx' tableName='d_goods_wlm_sku_rel', cache ='LRU', cacheSize ='10000', cacheTTLMs ='60000', parallelism ='1', partitionedJoin='false' );

toratto avatar Aug 14 '20 06:08 toratto

还需要更详细的描述,提供最小复现SQL。

a49a avatar Aug 21 '20 08:08 a49a

还需要更详细的描述,提供最小复现SQL。

有具体例子吗

aptx4869hrj avatar Aug 24 '20 03:08 aptx4869hrj

如果你的维度表或者事实表本身有重复的话 需要先去重 然后在join

Rowen110 avatar Sep 15 '20 08:09 Rowen110