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 of the specification); but I am wondering if I can delimit strings in Hive with single quotes instead of double. Ideally just for that table, since, if I do it globally, I could imagine another situation coming up where my data already heavily uses single quotes.
Thanks!
