flink sql how to do explode(array)=== if we use array to pase a json how to do explode () in flinksql---does flink support explode

Question

see example : create table conv ( SM ROW(objectType STRING, verb string, actor ROW(orgId string), object ROW(contentCategory string, links ARRAY<ROW(ecmType STRING)>)), timestamp string

) WITH ( 'connector' = 'kafka', -- using kafka connector 'topic' = 'sj1_spark_conv_hdfs', )

how to use explode on SM.object.ecmType instead of using ecmType[1]

question from:https://stackoverflow.com/questions/65837521/flink-sql-how-to-do-explodearray-if-we-use-array-to-pase-a-json-how-to-do-e

Answer 1

Waitting for answers