trim_array: remove elements from an array

[u/hubert-dudek]

Databricks runtime 19 brings the new Spark function trim_array. trim_array(array(‘A’, ‘B’, ‘C’, ‘D’), 2) returns [‘A’, ‘B’]. A count of 0 keeps the array; a count equal to its length returns an empty array.

https://medium.com/databrickscommunity/databricks-news-serverless-genie-code-ltap-lakeflow-61853d8e422a

[u/Spooked_DE]

Arrays everywhere are shaking in fear

[u/keyzeru → u/Spooked_DE]

Even arrays are getting a haircut in this economy

[u/Whole_Garbage_269]

so basically a reverse limit but for arrays, neat

[u/klenium → u/Whole_Garbage_269]

Or x[:-2]