carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vinodkc <...@git.apache.org>
Subject [GitHub] incubator-carbondata pull request #720: [CARBONDATA-642] Delete Subquery is ...
Date Tue, 11 Apr 2017 04:58:16 GMT
Github user vinodkc commented on a diff in the pull request:

    https://github.com/apache/incubator-carbondata/pull/720#discussion_r110815691
  
    --- Diff: integration/spark/src/test/scala/org/apache/carbondata/spark/testsuite/iud/DeleteCarbonTableTestCase.scala
---
    @@ -81,6 +81,18 @@ class DeleteCarbonTableTestCase extends QueryTest with BeforeAndAfterAll
{
           Seq()
         )
       }
    +
    +  test("delete data from  carbon table[ JOIN with another table ]") {
    +    sql("""drop table if exists iud_db.dest""")
    +    sql("""create table iud_db.dest (c1 string,c2 int,c3 string,c5 string) STORED BY
'org.apache.carbondata.format'""").show()
    +    sql(s"""LOAD DATA LOCAL INPATH '$resourcesPath/IUD/dest.csv' INTO table iud_db.dest""")
    +    sql(""" DELETE FROM dest t1 INNER JOIN source2 t2 ON t1.c1 = t2.c11""").show(truncate
= false)
    +    checkAnswer(
    +      sql("""select c1 from iud_db.dest"""),
    +      Seq(Row("c"), Row("d"), Row("e"))
    +    )
    +  }
    +
     //  test("delete data from  carbon table[where IN (sub query) ]") {
    --- End diff --
    
    @jackylk , I've not commented any testcases. Just added a new test case line # 84 to 95


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message