I am using Hive for json storage. Then, I have created a table with only one string column containing all the json. I have tested the get_json_object function that Hive offers but I am not able to create a query that iterates all the subdocuments in a list and finds a value in a specific field.

In MongoDB, this problem can be solved by using $elemMatch as the documentation says.

Is there any way to do something like this in Hive?

0 Answers