20,808
社区成员
发帖
与我相关
我的任务
分享
use XXX_DB;
drop view if exists xxx_test;
create view xxx_test (
OS comment '订单系统',
OrderID comment '订单号'
)
comment 'XXX'
as
select
'shanghai' as OS,
OrderID
from 订单表1
where d = from_unixTime(unix_Timestamp(),'yyyy-MM-dd')
union all
select
'beijing' as OS,
OrderID
from 订单表2
where d = from_unixTime(unix_Timestamp(),'yyyy-MM-dd')
set hive.mapred.mode = nonstrict;
case when OrderID > 0 then 'shanghai' else 'shanghai' end as OS,
case when 1 = 1 then 'shanghai' else OrderID end as OS,
case when OrderID > 0 then 'shanghai' else OrderID end as OS,