列转行unnest无法使用别名

[ookkkkk]

StarRocks > SELECT unnest FROM hits_10m, unnest(split(SearchPhrase, ' '));
Empty set (0.02 sec)

StarRocks > SELECT unnest FROM hits_10m, unnest(split(SearchPhrase, ' ')) as unnest;
Empty set (0.02 sec)

StarRocks > SELECT word FROM hits_10m, unnest(split(SearchPhrase, ' ')) as word;
ERROR 1064 (HY000): Getting analyzing error. Detail message: Column 'word' cannot be resolved.

be、fe version：Version: 3.2.6-2585333

似乎只能as unnest，无法as其他别名，这个是defect还是设计意图？

[liutao]

@ookkkkk

SELECT word FROM hits_10m, unnest(split(SearchPhrase, ' ')) as word;

我都是这么写:

SELECT unnest.word FROM hits_10m, unnest(split(SearchPhrase, ’ ')) as unnest(word);