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
