I have a table with a column contain JSON. I run a query that aggregates on a
different column and uses collect_set to create an array of the JSON data. The
output includes lots of escaped quotes because both JSON and Hive use double
quotes. There is not much I can do about JSON (it is part o
imestamp, subtract an hour, convert back to string).
But I can't seem to find a way to do this dynamically in Hive. Am I missing
something?
Sincerely,
Matt VonKip
Shoot, I meant to reply to the group, not respond to Mark directly. (Mark
replied offline to me; not sure the etiquette in pasting that response in here
as well!)
Hi Mark, thanks for the response! I tried using the
memory-intensive boostrap action and got a different error; however,
I'm not
a reference and happy to summarize
what I learn here. Or, if you simply have an answer ... well, any help would
be most appreciated!
Sincerely,
Matt Vonkip
