https://community.cloudera.com/t5/Support-Questions/Impala-to-query-Hive-table-built-from-JSON/m-p/84962#M11606 LATERAL VIEW is not available in Impala yet, see below link:<BR /><A href="https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html#langref_hiveql_unsupported" target="_blank">https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html#langref_hiveql_unsupported</A><BR /><BR />Currently only Hive supports it. Wed, 16 Jan 2019 06:27:31 GMT EricL 2019-01-16T06:27:31Z