question Impala to query Hive table built from JSON in Support Questions

question Impala to query Hive table built from JSON in Support Questions https://community.cloudera.com/t5/Support-Questions/Impala-to-query-Hive-table-built-from-JSON/m-p/84912#M11605 Trying to understand if this use case is possible. I have a json file that I want to build a hive table with. Here is an example of what I could use to do that - <A href="https://pkghosh.wordpress.com/2012/05/06/hive-plays-well-with-json/" target="_blank">https://pkghosh.wordpress.com/2012/05/06/hive-plays-well-with-json/</A> . However, once built, I would like to query using impala as below or am I restricted to using Hive queries for sushc tables?  <PRE>SELECT b.blogID, c.email FROM comments a LATERAL VIEW json_tuple(a.value, 'blogID', 'contact') b AS blogID, contact LATERAL VIEW json_tuple(b.contact, 'email', 'website') c AS email, website WHERE b.blogID='64FY4D0B28'; </PRE>  Fri, 16 Sep 2022 14:03:54 GMT AbhiBasu 2022-09-16T14:03:54Z