Hi All, I'm trying to split words of a record in Apache Phoenix and count its occurrences. I do not see a split() function in Phoenix so I'm using REGEXP_SPLIT(line,' ') which returns an Array. How do I group words further and count how many times a word occurs? select REGEXP_SPLIT(line,' ') from twitter_feed; OutPut: [@Tea,best,is] [@Jimmy,should,get,over,it] ... View more