Re: Re: dimention table join not work under sql-client fink-1.10.0

2020-03-12 Thread Zhenghua Gao
er > *Subject:* Re: dimention table join not work under sql-client fink-1.10.0 > We don't support 'PROCTIME()' in a temporal table join. Please use a left > table's proctime field. [1] > > [1] > https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/t

Re: Re: dimention table join not work under sql-client fink-1.10.0

2020-03-12 Thread wangl...@geekplus.com.cn
Thanks, works now. Seems the open source version is different from alibaba cloud: https://www.alibabacloud.com/help/doc-detail/62506.htm wangl...@geekplus.com.cn From: Zhenghua Gao Date: 2020-03-13 12:12 To: wangl...@geekplus.com.cn CC: user Subject: Re: dimention table join not work

Re: dimention table join not work under sql-client fink-1.10.0

2020-03-12 Thread Zhenghua Gao
We don't support 'PROCTIME()' in a temporal table join. Please use a left table's proctime field. [1] [1] https://ci.apache.org/projects/flink/flink-docs-release-1.10/dev/table/streaming/joins.html#usage-1 *Best Regards,* *Zhenghua Gao* On Fri, Mar 13, 2020 at 11:57 AM wangl...@geekplus.com.cn

dimention table join not work under sql-client fink-1.10.0

2020-03-12 Thread wangl...@geekplus.com.cn
Kafka source table: CREATE TABLE out_order ( out_order_code VARCHAR, intput_date BIGINT, owner_code VARCHAR ) WITH ( 'connector.type' = 'kafka',MySQL dimention table: CREATE TABLE dim_owner ( owner_code VARCHAR, owner_name VARCHAR ) WITH ( 'connector.t