How to Convert a Lateral View to a Table Reference

BennyBoyW · ‎03-30-2026

Hi All

I have a view creation script in DataBricks which uses a lateral view to access columns in a structure held within an array field.

It is working fine but I have noted that the LATERAL VIEW is now depracated and that I should be using a TABLE REFERENCE instead.

I just cannot get the command to work however, so my question is - how do I convert the following to a TABLE REFERENCE ?

CREATE OR REPLACE VIEW newview

AS

SELECT

t1.field1

, structureitem.field2

, structureitem.field3

FROM table1 AS t1, table2 AS t2

LATERAL VIEW EXPLODE(t1.structure) AS structureitem

where t1.id = t2.id;