Re: Re: FlinkSQL query error when specify json-schema.

2020-04-16 Thread Benchao Li
Hi wanglei, Yes, your observation is correct. Currently the type derivation relies on legacy types, which only support (38, 18) as decimal precisions. wangl...@geekplus.com.cn 于2020年4月16日周四 下午6:54写道: > > Thanks, I have tried. > > 'format.derive-schema' = 'true' will work. > > But if i insist t

Re: Re: FlinkSQL query error when specify json-schema.

2020-04-16 Thread wangl...@geekplus.com.cn
Thanks, I have tried. 'format.derive-schema' = 'true' will work. But if i insist to use format.json-schema, the CREATE TABLE must be writtten as: `id` DECIMAL(38,18), `timestamp` DECIMAL(38,18) wangl...@geekplus.com.cn From: Benchao Li Date: 2020-04-16 16:56 To: wangl...@gee