Hi Forward, Thanks for bringing this discussion and preparing the nice design. I think it's nice to have the JSON functions in the next release. We have received some requirements for this feature.
I can help to shepherd this JSON functions effort and will leave comments in the design doc in the next days. Hi Danny, The new introduced JSON functions are from SQL:2016, not from MySQL. So there no JSON type is needed. According to the SQL:2016, the representation of JSON data can be "character string" which is also the current implementation in Calcite[1]. Best, Jark [1]: https://calcite.apache.org/docs/reference.html#json-functions On Wed, 4 Sep 2019 at 21:22, Xu Forward <forwardxu...@gmail.com> wrote: > hi Danny Chan ,Thank you very much for your reply, your help can help me > further improve this discussion. > Best > forward > > Danny Chan <yuzhao....@gmail.com> 于2019年9月4日周三 下午8:50写道： > > > Thanks Xu Forward for bring up this topic, I think the JSON functions are > > very useful especially for those MySQL users. > > > > I saw that you have done some work within the Apache Calcite, that’s a > > good start, but this is one concern from me, Flink doesn’t support JSON > > type internal, so how to represent a JSON object in Flink maybe a key > point > > we need to resolve. In Calcite, we use ANY type to represent as the JSON, > > but I don’t think it is the right way to go, maybe we can have a > discussion > > here. > > > > Best, > > Danny Chan > > 在 2019年9月4日 +0800 PM8:34，Xu Forward <forwardxu...@gmail.com>，写道： > > > Hi everybody, > > > > > > I'd like to kick off a discussion on Support JSON functions in Flink > SQL. > > > > > > The entire plan is divided into two steps: > > > 1. Implement Support SQL 2016-2017 JSON functions in Flink SQL[1]. > > > 2. Implement non-Support SQL 2016-2017 JSON functions in Flink SQL, > such > > as > > > JSON_TYPE in Mysql, JSON_LENGTH, etc. Very useful JSON functions. > > > > > > Would love to hear your thoughts. > > > > > > [1] > > > > > > https://docs.google.com/document/d/1JfaFYIFOAY8P2pFhOYNCQ9RTzwF4l85_bnTvImOLKMk/edit#heading=h.76mb88ca6yjp > > > > > > Best, > > > ForwardXu > > >
