How do you parse a multi-valued field from Solr using Hive? If I define a Solr field as:
<field name="groups" type="string" indexed="true" stored="true" multiValued="true"/> and insert the groups: "US", "Sales" then it is stored in Cassandra and seen in Hive as solrjson:["US","Sales"]. How do I parse this in Hive and turn it into an array?
I tried...
SELECT row_key, get_json_object(TestTable.groups, '$.solrjson') FROM TestTable;
...along with other combinations of the solrjson argument, but it always returns null for the groups.