topic Re: Keywords and Functions supported in SQL but not in Databricks SQL. in Data Engineering

Keywords and Functions supported in SQL but not in Databricks SQL.

RishabhGarg — Fri, 26 Jul 2024 12:38:54 GMT

Actually, I have around 2000 SQL queries. I have to convert them in Databricks supported SQLs, so that I can run them in databricks environment. So I want to know the list of all keywords, functions or anything that is different in databricks SQL. Please help.

Re: Keywords and Functions supported in SQL but not in Databricks SQL.

RishabhGarg — Fri, 26 Jul 2024 12:41:16 GMT

Actually, If I know about keywords and functions which are not supported in databricks SQL, I will get their alternatives in databricks SQL and create a pyspark Script to automate it. Please help, If anybody knows.

Re: Keywords and Functions supported in SQL but not in Databricks SQL.

szymon_dybczak — Fri, 26 Jul 2024 12:42:33 GMT

Hi @RishabhGarg ,

You're saying SQL, but which dialect? Because every provider has its own extension to ANSI SQL standard. So for example, if you're using SQL Server for example, there is a TOP keyword to limit the rows.