Hive 测试case when 语句

hive> set a = "2021-04-23 00:00:00";
hive> select case when ${hiveconf:a} is not null then ${hiveconf:a} end;
2021-04-23

关于${hiveconf:变量名}这个语法,可以参考https://blog.csdn.net/mostermoonsky/article/details/111273157

原文地址:https://www.cnblogs.com/144823836yj/p/14694774.html