Databricks Community

Sudeshna · 03-29-2022

For eg - CREATE OR REPLACE TABLE table2(a INT, b INT);INSERT INTO table2 VALUES (100, 200);CREATE OR REPLACE FUNCTION func1() RETURNS TABLE(a INT, b INT) RETURN (SELECT a+b, a*b from table2);create or replace function calc(p DOUBLE) RETURNS TABLE(val...

Sudeshna · 03-15-2022

I was trying to create a variable and i got the following error -command - SET a = 5;Error -Error running queryConfiguration a is not available.

Sudeshna · 03-30-2022

@Hubert Dudek , How will it work if func_multiply() also returns a table? Can i write such a select statement in that case?

Sudeshna · 03-21-2022

Got your point. Thank you very much for the help

Sudeshna · 03-21-2022

Using curly braces means it will create parameters. but i don't need a parameter. There is no way other than creating a parameter?

Databricks Community

User Stats

User Activity

How can i pass one of the values from one function to another as an argument in Databricks SQL?

I am new to Databricks SQL and want to create a variable which can hold calculations either from static values or from select queries similar to SQL Server. Is there a way to do so?

Re: How can i pass one of the values from one function to another as an argument in Databricks SQL?

Re: I am new to Databricks SQL and want to create a variable which can hold calculations either from static values or from select queries similar to SQL Server. Is there a way to do so?

Re: I am new to Databricks SQL and want to create a variable which can hold calculations either from static values or from select queries similar to SQL Server. Is there a way to do so?