I want to store current\_day - 1 in a variable in `Hive`. I know there are already previous threads on this topic but the solutions provided there first recommends defining the variable outside hive in a shell environment and then using that variable inside Hive.

[Storing result of query in hive variable](https://stackoverflow.com/questions/42887401/storing-result-of-query-in-hive-variable)

I first got the current\_Date - 1 using

```
 select date_sub(FROM_UNIXTIME(UNIX_TIMESTAMP(),'yyyy-MM-dd'),1);

```

Then i tried two approaches:

```
1. set date1 = ( select date_sub(FROM_UNIXTIME(UNIX_TIMESTAMP(),'yyyy-MM-dd'),1);

and 

2. set hivevar:date1 = ( select date_sub(FROM_UNIXTIME(UNIX_TIMESTAMP(),'yyyy-MM-dd'),1);

```

Both the approaches are throwing an error:

```
"ParseException line 1:82 cannot recognize input near 'select' 'date_sub' '(' in expression specification"

```

When I printed (1) in place of yesterday's date the select query is saved in the variable. The (2) approach throws "{hivevar:dt\_chk} is undefined
".

I am new to Hive, would appreciate any help. Thanks.