I am using sparksql. Below is a sample query, which keeps running for long because of huge volume of data. I want to add user prompt for the query instead of hardcoding. Query should run for the value entered by user for these two prompts$-$ AL$1.$oha$\_$serial$\_$number$=\text{'}122345\text{'}$

AL$1.$order$\_$number$=\text{'}$A$123\text{'}$

How can I add prompts for these two.

SELECT

$($Trim$($AL$1.$mtype$)||$ Trim$($AL$1.$order$\_$number$))$ as ord$\_$nbr$,$

AL$1.$m$\_$type as Mod$\_$Typ$,$

AL$4.$serial$\_$num as Func$\_$Ser$\_$Nbr$,$

AL$4.$part$\_$number,

AL$5.$accum$\_$quantity as TSN$,$

AL$6.$accum$\_$quantity as CSN$,$

AL$9.$accum$\_$quantity as TSDPI,

FROM

ems$\_$module$\_$serial$\_$history AL$1$

JOIN module$\_$description AL$3$ ON trim$($AL$1.$m$\_$type$)=$ trim$($AL$3.$m$\_$type$)$ AND trim$($AL$1.$eng$\_$type$)=$ trim$($AL$3.$eng$\_$type$)$

JOIN Eng$\_$description AL$8$ ON trim$($AL$1.$e$\_$type$)=$ trim$($AL$8.$e$\_$type$)$

JOIN function$\_$description AL$2$ ON trim$($AL$1.$e$\_$type$)=$ trim$($AL$2.$bom$\_$e$\_$type$)$ AND trim$($AL$1.$m$\_$type$)=$ trim$($AL$2.$bom$\_$m$\_$type$)$

WHERE

$($

trim$($AL$1.$e$\_$type$)=\text{'}$A$\text{'}$

AND Trim$($AL$1.$oha$\_$serial$\_$number$)=\text{'}122345\text{'}$

AND trim$($AL$1.$order$\_$number$)=\text{'}$A$123\text{'}$

AND $($

LEFT$($trim$($AL$1.$eff$\_$end$\_$dtml$),4)>\text{'}2010\text{'}$

$)$

$)$