Re: SQL Lookup join on nested field

2022-10-18 Thread yuxia
AFAK,there's no any plan/ticket for it. If you think it's needed to be supported, you can create a tiket in jira[1] for it. [1] https://issues.apache.org/jira/projects/FLINK/summary Best regards, Yuxia 发件人: "Krzysztof Chmielewski" 收件人: "User" 发送时间: 星期二, 2022年 10 月 18日 下午 3:28:26 主题: SQ

Re: [E] Re: Presto S3 filesystem access issue - checkpointing - EKS

2022-10-18 Thread Vignesh Kumar Kathiresan via user
Hi Yanfei, Thanks for the reply. I wanted to specifically try out using the IRSA role of the EKS pods. Apparently I needed permissions for S3 managed KMS keys. So for future reference to make checkpointing to s3 using presto s3 filesystem plugin work, 1. configs to set - presto.s3.use-instan

SQL Lookup join on nested field

2022-10-18 Thread Krzysztof Chmielewski
Hi all, I have found an old thread [1] where there was a question about SQL joins on nested fields. The conclusion was that (quote): *"temporal table join doesn't support join on a nested join.In blink planner, a temporal table join will be translated into lookup joinwhich will use the equality