Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2023 03:10 AM
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."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2023 05:03 PM
Thanks for sharing this with the Databricks community.