• Home
• com.emarsys
• rdb-connector-redshift_2.12
• 4e6e2e40
• source code
• RedshiftSqlWriters.scala

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.emarsys.rdb.connector.redshift.RedshiftSqlWriters.scala Maven / Gradle / Ivy

package com.emarsys.rdb.connector.redshift

import com.emarsys.rdb.connector.common.defaults.{DefaultSqlWriters, SqlWriter}
import com.emarsys.rdb.connector.common.models.SimpleSelect
import com.emarsys.rdb.connector.common.models.SimpleSelect.FieldName

object RedshiftSqlWriters extends DefaultSqlWriters {
  def selectWithGroupLimitWriter(groupLimit: Int, references: Seq[String]): SqlWriter[SimpleSelect] =
    (ss: SimpleSelect) => {
      import com.emarsys.rdb.connector.common.defaults.SqlWriter._

      val partitionFields = references.map(FieldName).map(_.toSql).mkString(",")
      s"""select * from (
       |  select *, row_number() over (partition by $partitionFields) from (
       |    ${ss.toSql}
       |  ) tmp1
       |) tmp2 where row_number <= $groupLimit;""".stripMargin
    }
}