packagemobvista.dmp.datasource.taobaoobjectConstant{valuc_lahuo_sql:String=s""" |SELECT device_ids FROM dmp.uc_lahuo_result_daily_all WHERE dt = '@date' AND device_type='@device_type' """.stripMarginvalalipay_lahuo_sql:String=s""" |SELECT device_ids FROM dmp.alipay_lahuo_result_daily_all WHERE dt >= '@begin_date' AND dt <= '@end_date' AND device_type='@device_type' AND hour='@hour' """.stripMarginvalyouku_laxin_sql:String=s""" |SELECT device_ids FROM dmp.youku_laxin_result_daily_all WHERE dt >= '@begin_date' AND dt <= '@end_date' AND device_type='@device_type' """.stripMargindefbuildPartUCLaHuo(partSize:Int):Seq[String]={varlist:scala.List[String]=scala.List()for(i<-0untilpartSize){list=list.::(s"CRC32(device_ids) % $partSize = $i")}list=list.reverselist}}