如何在HIVE脚本中设置变量；How to set variables in HIVE scripts

• 用hiveconf

hive> set CURRENT_DATE='2012-09-16';
hive> select * from foo where day >= ${hiveconf:CURRENT_DATE}


  

 

  
1
  
2
  
3
 

• 用hivevars

set hivevar:USER_NAME='FOO';
hive> select * from foobar where NAME = '${USER_NAME}';
hive> select * from foobar where NAME = '${hivevar:USER_NAME}';


  

 

  
1
  
2
  
3
  
4
 

文章来源: hiszm.blog.csdn.net，作者：孙中明，版权归原作者所有，如需转载，请联系作者。

原文链接：hiszm.blog.csdn.net/article/details/118900199