akashrn5 commented on a change in pull request #3846: URL: https://github.com/apache/carbondata/pull/3846#discussion_r458018898
########## File path: integration/spark/src/test/scala/org/apache/carbondata/spark/testsuite/merge/MergeTestCase.scala ########## @@ -725,6 +725,47 @@ class MergeTestCase extends QueryTest with BeforeAndAfterAll { checkAnswer(sql("select * from target order by key"), Seq(Row("c", "200"), Row("d", "3"), Row("e", "100"))) } + test("check the ccd delete with partition") { + sql("drop table if exists target") + + val initframe = sqlContext.sparkSession.createDataFrame(Seq( + Row("a", "0"), + Row("a1", "0"), + Row("b", "1"), + Row("c", "2"), + Row("d", "3") + ).asJava, StructType(Seq(StructField("key", StringType), StructField("value", StringType)))) + + initframe.write + .format("carbondata") + .option("tableName", "target") + .option("partitionColumns", "value") + .mode(SaveMode.Overwrite) + .save() + val target = sqlContext.read.format("carbondata").option("tableName", "target").load() + var ccd = + sqlContext.sparkSession.createDataFrame(Seq( + Row("a", null, true, 1), + Row("a1", null, false, 1), + Row("b", null, true, 2), + Row("c", null, true, 3), + Row("e", "100", false, 6) + ).asJava, + StructType(Seq(StructField("key", StringType), + StructField("newValue", StringType), + StructField("deleted", BooleanType), StructField("time", IntegerType)))) + ccd.createOrReplaceTempView("changes") + + ccd = sql("SELECT key, latest.newValue as newValue, latest.deleted as deleted FROM ( SELECT key, max(struct(time, newValue, deleted)) as latest FROM changes GROUP BY key)") Review comment: same as above ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org