Is there a split string functionality which can split comma separated string in teiid query?
We have to split the comma separated string and use the individual sub string to loop and perform some functionality?
Any suggestion or alternate as well works?
You can use TEXTTABLE for that for ex:
select x.* from TEXTTABLE('one,two,three' COLUMNS col string ROW DELIMITER ',' DELIMITER ':') as x
Since you are saying looping, I think you may be wanting to use this in a virtual stored procedure. Check the procedure language on how to cursor through results of select in a loop.
Retrieving data ...