SQL queries

[thuylevn]

https://github.com/ThuyLeVn/druid-docker/importHello,

SQL quries on druid is limited, for example
SELECT LEFT("bbbbb-aaaa", LOCATE("-", bbbbb-aaaa")-1) AS lef, RIGHT("bbbbb-aaaa", LOCATE("-", "bbbbb-aaaa")) AS rig;
SELECT LEFT("bbbbb-aaaa", POSITION("-" IN "bbbbb-aaaa")-1) AS lef, RIGHT("bbbbb-aaaa", POSITION("-" IN "bbbbb-aaaa")) AS rig;

How to use split column to multi columns in druid?
Thanks you so much
ThuyLe