由于没有update语句,因此只能另想办法!odps只能通过新建表的形式来更改数据!(哥哥就是没有update,怎么滴!)
幸亏有case when语句,如:
drop table if exists wifi_shop_mall_rks3;
create table wifi_shop_mall_rks3 as
select a.row_id,
a.shop_id,
a.time_stamp ,
a.longitude ,
a.latitude ,
a.wifi_infos ,
a.price ,
a.category_id ,
a.bbid ,
a.signal ,
a.connected ,
case when connected = 'true' then '5'
else a.rks
end as rks
from wifi_shop_mall_rks2 a ;
即可实现对值的修改