- 980 Views
- 3 replies
- 0 kudos
Issue withpassing parameters to the queries in spark sql temporary function
I have created a function like belowcreate function test(location STRING, designation STRING, name STRING)RETURNS TABLE (cnt INT)RETURN(SELECT CASE WHEN location = 'INDIA' THEN (SELECT COUNT(*) FROM tbl_customers where job_role = design...
- 980 Views
- 3 replies
- 0 kudos
Latest Reply
- 0 kudos
@Raghu Dandu​ :The error message suggests that the column "designation" does not exist in the table "tbl_customers". There could be several reasons for this error, such as a typo in the column name, a missing or deleted column, or a difference in the...
- 0 kudos