just a public service announcement.
I had a case where i had a nested json array in a string and i needed that
to act like a first class array in hive. natively, you can pull it out but
it'll just a string. woe is me.
I searched around the web and found this:http://stackoverflow.com/questions/19867155/array-contains-equivalent-for-json-in-hiveql
follow the link for the brickhouse libs in the above url and you'll find a
veritable treasure trove of useful functions.
PS I have zero affiliation to brickhouse.