rabeen的专栏

问题描述; 1.表规模是 150万行，每行18列。 执行查询语句： selectcount(DeviceId) from(select DeviceId, count(distinct SubdeviceMac) as MACnumfrom wide_table_all_row where TIMESTAMPP LIKE "%2017-10-13%" group by Device

####按家庭维度统计信号强度create table Power_STAT(select DeviceId,count(DeviceId) as AllNum,sum(case when SubdeviceWlanRadioPower >= -67 then 1 else 0 end) as GoodNum,sum(case when SubdeviceWlanRadio

####按硬件厂家统计覆盖质量create table Manufacture_STAT(select (case     when DeviceId like '%CIOT%' then 'CIOT'when DeviceId like '%FHTT%' then 'FHTT'when DeviceId like '%HWTC%' then 'HWTC'when De