You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@flink.apache.org by Andres Angel <in...@gmail.com> on 2019/07/24 14:53:48 UTC

sqlQuery split string

Hello everyone,

Following the current available functions
https://ci.apache.org/projects/flink/flink-docs-release-1.8/dev/table/functions.html,
how could I split a column string by a caracter?

example

column content : col =a,b,c
query: Select col from tenv
expected return : cola , colb, colc


thanks

Re:sqlQuery split string

Posted by Haibo Sun <su...@163.com>.

Hi Andres Angel,


At present, there seems to be no such built-in function, and you need to register a user-defined function to do that. You can look at the following document to see how to do.


https://ci.apache.org/projects/flink/flink-docs-master/dev/table/udfs.html#table-functions


Best,
Haibo


At 2019-07-25 06:00:53, "Andres Angel" <in...@gmail.com> wrote:

Hello everyone, 


Following the current available functions https://ci.apache.org/projects/flink/flink-docs-release-1.8/dev/table/functions.html, how could I split a column string by a caracter?


example 


column content : col =a,b,c
query: Select col from tenv
expected return : cola , colb, colc 




thanks