create table cf_tmp.sy_newstart_01 as select pin
from
( select pin,mobile,cast(rand() * 1000000 as int) as flag from cf_dm.d_jdsum_1507_v4 ) t1
where flag < 100000 and mobile is not NULL limit 5000;
from
( select pin,mobile,cast(rand() * 1000000 as int) as flag from cf_dm.d_jdsum_1507_v4 ) t1
where flag < 100000 and mobile is not NULL limit 5000;