It's very convenient to be able to set script variables. For example,
SET start_date = 20151201;
SELECT * FROM some_table where date = {$hiveconf:start_date};
Does Presto have this capability?
If you want to run a query through a path, select Query Path from the drop-down list, then specify the cloud storage path that contains the Presto query file.
Not yet. Presto only have set session command for setting some presto properties during current session. For example SET SESSION distributed_join=true;
But presto can not set a variable and use it in following sql like hive does.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With