topic Re: Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined... in Data Engineering

Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...

Hubert-Dudek — Mon, 06 Mar 2023 11:12:08 GMT

Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined earlier in the same SELECT list, thus avoiding repetition of the same calculation.

For instance, in a SELECT statement with expressions like:

SELECT

'John' AS name,

'Smith' AS surname,

Concat(name, ' ', surname) AS full_name

the Concat(name, ' ', surname) can be resolved using previously defined 'John' AS name and 'Smith' AS surname.

This makes writing SQL queries easier and more efficient, as you can reference expressions that have already been defined without needing to repeat them."

Re: Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...

Tayyab_Vohra — Mon, 06 Mar 2023 11:45:36 GMT

@Hubert Dudek , I guess this has been updated in recent update right ?

https://docs.databricks.com/release-notes/runtime/12.2.html

Re: Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...

daniel_sahal — Mon, 06 Mar 2023 13:09:49 GMT

Thanks @Hubert Dudek for the info. Now 50% of my subselects can go to the trash 🙂

Re: Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...

Ajay-Pandey — Mon, 06 Mar 2023 13:17:54 GMT

Informative

Thanks for sharing.