title: finding an element in json using get_json_object or json_tuple in hql
body: <p>Below is the sample json element in my table. i want to only get typ SSN and typ TIN and their respective Id's in my output. I am using below code but i am traversing manually to each iteration and getting all the typ one by one which i want to avoid, instead go through each element and get me only typ as SSN or TIN</p>
  <p>select get_json_object(get_json_object(b.gov_doc_id, '$.[0]') ,'$.typ')),'') as char(15)) as idtyp1</p>
  <p>'''
  [{&quot;lst_updt_src&quot;:&quot;yyyyyyy&quot;,&quot;processed&quot;:{&quot;typ&quot;:&quot;SSN&quot;,&quot;id&quot;:&quot;XXXXXXXXX&quot;,&quot;std_ind&quot;:&quot;Y&quot;},&quot;issue_ctry_cd&quot;:&quot;CC&quot;,&quot;typ&quot;:&quot;SSN&quot;,&quot;id&quot;:&quot; XXXXXXXXX &quot;,&quot;lst_updt_ts&quot;:&quot;2015-09-21T12:16:43.587610&quot;,&quot;id_last4&quot;:&quot;XXXX&quot;}, {&quot;lst_updt_src&quot;:&quot;xxxxxx&quot;,&quot;processed&quot;:{&quot;typ&quot;:&quot;DRIVERSLICENSE&quot;,&quot;id&quot;:&quot;XXXXXXXXX&quot;,&quot;std_ind&quot;:&quot;Y&quot;},&quot;typ&quot;:&quot;DRIVERS_LICENSE&quot;,&quot;id&quot;:&quot; XXXXXXXXX &quot;,&quot;lst_updt_ts&quot;:&quot;2015-09-21T12:16:43.587710&quot;,&quot;id_last4&quot;:&quot;XXXX&quot;}, {&quot;lst_updt_src&quot;:&quot;xxxxxx&quot;,&quot;processed&quot;:{&quot;typ&quot;:&quot;TIN&quot;,&quot;id&quot;:&quot;XXXXXXXXX&quot;,&quot;std_ind&quot;:&quot;Y&quot;},&quot;typ&quot;:&quot;TIN&quot;,&quot;id&quot;:&quot;XXXXXXXXX &quot;,&quot;lst_updt_ts&quot;:&quot;2015-09-21T12:16:43.587689&quot;,&quot;id_last4&quot;:&quot;XXXX&quot;}]
  '''</p>