Presto: how to pass dynamical parameter value to presto query in command line

[kiranps11]

how to pass dynamical parameter value to presto query in command line

[mbasmanova]

@kiranps11 I don't understand the question. Could you explain a bit more?

[kiranps11]

Hello @mbasmanova ,
My query is like : select * from table_a where dat='${date_value}' and the date_value will be a variable .
I need to pass the $date_value to presto in command line .

[kokosing]

Is:

cat << EOF | presto-cli
select * from table_a where dat='${date_value}';
EOF

Good enough for you?