Scala 字符串插值: s插值

val pageLevelId = 3val pageLevelName = "entrance"val funnel = Map(2 -> List(11111), 4 -> List(7), 3 -> List(402, 403), 5 -> List(1572, 1574))val bg = s"$pageLevelName.page_id = 254" :: s"$pageLevelName.page_value in('%s')".format(funnel(pageLevelId).mkString("','")) :: s"page_level_id = $pageLevelId" :: Nilprintln(bg)val pageValues = 2val sqlStr = s"""select        |date as date_id,                   |site_id,        |terminal_id,        |cate_level1_id,        |from dw.fct_ordr_path_off        |where date = '%s'        |and $pageValues        |group by        |date,        |site_id,        |terminal_id,        |cate_level1_id,        |cate_level2_id,        |cate_level3_id;""".stripMarginval sql = String.format(sqlStr, "{$date}")println(sql)