Does Presto have the equivalent of Hive's SET command

Question

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?

score 18 · Answer 1 · answered Dec 02 '20 at 11:45

18

You can do this

WITH VARIABLES AS (SELECT VALUE AS VAR1, VALUE AS VAR2)
SELECT * 
FROM TABLE CROSS JOIN VARIABLES 
WHERE COLUMN = VAR1

answered Dec 02 '20 at 11:45

Mahmoud Alhyari

221
2
3

score 14 · Accepted Answer · answered Dec 16 '15 at 03:01

14

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.

answered Dec 16 '15 at 03:01

袁安峰

652
6
5

2

But this seems not difficult, I can try to add this when I have time. – 袁安峰 Dec 16 '15 at 03:14
1

Did you end up having time to add this @袁安峰 ? – Gregology Oct 14 '16 at 17:46
5

Sorry but I didn't add this, there is an issue about this https://github.com/prestodb/presto/issues/5918 – 袁安峰 Nov 10 '16 at 10:52

score 1 · Answer 3 · answered Jul 19 '22 at 08:43

1

Not quite a script variable per say; but some UIs like DataGrip (probably DBeaver as well) emulate passing variables; e.g.:

where date = ${start_date}

answered Jul 19 '22 at 08:43

Neil

7,482
6
50
56

Does Presto have the equivalent of Hive's SET command

3 Answers3