title: array_contains equivalent for JSON in HiveQL
body: <p>HiveQL offers an array_contains() function for its array datatype, and also offers json support.  </p>
  
  <p>However, the get_json_object() function does not return an array datatype when fetching a json array, meaning the array_contains() function cannot be used on the resulting json_array.</p>
  
  <p>What is the best way to mimic the array_contains() functionality for a json array in HiveQL?</p>
  
  <p>As a concrete example, I want the following to return true:</p>
  
  <p>array_contains_mimic(get_json_object({"array":["one", "two"]}, '$.array'), "one")</p>