Is it possible to pass a parameter to a SQL UDF to another SQL UDF that is called by the first SQL UDF?
Below is an example where I would like to call tbl_filter() from tbl_func() by passing the tbl_func.a_val parameter to tbl_filter().
Obviously, I could just implement the logic in one function, but in my use case that means repeating the "tbl_filter()" part of the query over and over in different versions of "tbl_func()", which defeats the purpose of packaging code in functions. Ideally, there would be a single version of "tbl_filter()" to maintain that could be called from a variety of different versions of "tbl_func()".
CREATE OR REPLACE TEMPORARY VIEW test_tbl AS
WITH a AS
(SELECT explode(sequence(1, 10)) AS a),
b AS
(SELECT explode(sequence(50, 60)) AS b)
SELECT * FROM a CROSS JOIN b;
CREATE OR REPLACE TEMPORARY FUNCTION tbl_filter(a_val INT)
RETURNS TABLE(a INT, b INT)
RETURN
SELECT * FROM test_tbl tf
WHERE tf.a = tbl_filter.a_val;
CREATE OR REPLACE TEMPORARY FUNCTION tbl_func(a_val INT, b_val INT)
RETURNS TABLE(a INT, b INT)
RETURN
SELECT * FROM tbl_filter(tbl_func.a_val) tf
WHERE tf.b = tbl_func.b_val;
-- This executes
-- select * from tbl_filter(1);
-- This does not: Error in SQL statement: AnalysisException: could not resolve `tbl_filter` to a table-valued function.
select * from tbl_func(1, 60);
