Does Presto have the equivalent of Hive's SET command

presto
Kevin Morris picture Kevin Morris · Dec 16, 2015 · Viewed 13.8k times · Source

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?

Answer

袁安峰 picture 袁安峰 · Dec 16, 2015

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.

Related questions

Presto SQL - Converting a date string to date format

I'm on presto and have a date formatted as varchar that looks like - 7/14/2015 8:22:39 AM I've looked the presto docs and tried various things(cast, date_format, using split_part to parse and then cast) and am not getting this …

Read More
Presto - static date and timestamp in where clause

I'm pretty sure the following query used to work for me on Presto: select segment, sum(count) from modeling_trends where segment='2557172' and date = '2016-06-23' and count_time between '2016-06-23 14:00:00.000' and '2016…

Read More
Presto check if NULL and return default (NVL analog)

Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE my_field …

Read More