Hive SQL 变量的疑问

[X615769472]

请教一个Hive sql 变量的问题， 请帮忙看一下

第一种，运行正常
set hivevar：curr_date ='2017-03-11';
select * from mytable where dt = ${curr_date};


第二种，运行正常，但是不理解为什么将Select语句赋予变量，在后续调用这个变量的时候要这样写。
set hivevar：curr_date = Select Max(dt) from tb_date;
select * from mytable where dt in (${curr_date});


第三种，下面两种写法都报错了，想达到的目的是，从mytable 中取出 curr_date 与 Last_date 之间的数据
set hivevar：curr_date = '2017-03-11';
set hivevar：Last_date = Select Max(dt) from tb_date;

select * from mytable where dt >= ${curr_date} and dt <= (${Last_date});
select * from mytable where dt between ${curr_date} and (${Last_date});

[飞向海洋的猪]

错误日志呢，能否发过来看看。

[chongchongone]

去掉小括号就正确了 select * from mytable where dt >= ${curr_date} and dt <= ${Last_date}; select * from mytable where dt between ${curr_date} and ${Last_date};