AFAIK, Phoenix does support support variables.
In this case, you'll need to break apart your queries. Step 1: execute a statement to get your variable value Step 2: prepare a new query and replace the variable with value you've retrieved from step 1 Regards, Will ________________________________ From: Cheyenne Forbes <cheyenne.osanu.for...@gmail.com> Sent: Thursday, March 23, 2017 7:01 PM To: user@phoenix.apache.org Subject: Re: Define parameters in queries or should I say "declare variables in Phoenix" instead of "defining variables in Phoenix"?