Databricks上的SQL编程信息安全资料.pdfVIP

SQL

PROGRAMMINGIN

DATABRICKS

SergeRielauMilanStefanovic

June2024

©2024DatabricksInc.—Allrightsreserved1

Agenda

•Sorting-yourway

•SortingpointsbydistanceusingLAMBDAandSQLUDF

•Sortingstrings,properly(Sneakpeek!)

•Shorthands

•GROUPBY,ORDERBY

•SELECT*-unleashed

•Variables

•SQLSessionVariables

•Whataboutidentifiers?

•Scripting

•EXECUTEIMMEDIATE

•SQL/PSM:ItslikeSQL,butscripted(Sneakpeek!)