package mobvista.dmp.datasource.taobao
object Constant {
val uc_lahuo_sql: String =
s"""
|SELECT device_ids FROM dmp.uc_lahuo_result_daily_all WHERE dt = '@date' AND device_type='@device_type'
""".stripMargin
val alipay_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'
""".stripMargin
val youku_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'
""".stripMargin
def buildPartUCLaHuo(partSize: Int): Seq[String] = {
var list: scala.List[String] = scala.List()
for (i <- 0 until partSize) {
list = list.::(s"CRC32(device_ids) % $partSize = $i")
}
list = list.reverse
list
}
}