select

NODE_DATA,

case

when NODE_DATA like '{"follow%' then 'follow'

when NODE_DATA like '{"comment%' then 'comment'

when NODE_DATA like '{"like%' then 'like'

when NODE_DATA like '{"post%' then 'post'

else null end as action

from near.social.fact_decoded_actions

select action, NODE_DATA:follow as acount

from actions

where action = 'follow'

limit 5