Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-639

"Delete data" feature doesn't work

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.0.0-incubating
    • Fix Version/s: 1.0.0-incubating
    • Component/s: core
    • Labels:
      None

      Description

      1.Version:CarbonData is the latest master , Spark 1.6.2
      2.Test Environment: spark-shell with command of ./bin/spark-shell --master local --jars ${carbondata_jar},${mysql_jar}

      3.Reproduce steps:
      1.Finish load data , query as below : cc.sql("select * from connectdemo1 where age > 40").show() :
      ----------------------

      name gender province singler age

      ----------------------

      Abbott Female AB false 54
      Abbott Female AB false 51
      Abbott Female AB false 65
      Abbott Female AB false 47
      Abbott Female AB false 56
      Abbott Female AB false 54
      Abbott Female AB false 61
      Abbott Female AB false 58
      Abbott Female AB false 62
      Abbott Female AB false 47
      Abbott Female AB false 49
      Abbott Female AB false 53
      Abbott Female AB false 63
      Abbott Female AB false 48
      Abbott Female AB false 52
      Abbott Female AB false 52
      Abbott Female AB false 62
      Abbott Female AB false 61
      Abbott Female AB false 63
      Abbott Female AB false 49

      ----------------------

      cc.sql("select count from connectdemo1").show()

      -------

      _c0

      -------

      9000000

      -------

      2.cc.sql("delete from connectdemo1 where age > 60").show

      3.query again with cc.sql("select * from connectdemo1 where age > 40").show() and cc.sql("select count from connectdemo1").show() : same result with before deletion , so the delete operation is failed.

      ----------------------

      name gender province singler age

      ----------------------

      Abbott Female AB false 54
      Abbott Female AB false 51
      Abbott Female AB false 65
      Abbott Female AB false 47
      Abbott Female AB false 56
      Abbott Female AB false 54
      Abbott Female AB false 61
      Abbott Female AB false 58
      Abbott Female AB false 62
      Abbott Female AB false 47
      Abbott Female AB false 49
      Abbott Female AB false 53
      Abbott Female AB false 63
      Abbott Female AB false 48
      Abbott Female AB false 52
      Abbott Female AB false 52
      Abbott Female AB false 62
      Abbott Female AB false 61
      Abbott Female AB false 63
      Abbott Female AB false 49

      ----------------------

      -------

      _c0

      -------

      9000000

      -------

        Attachments

          Activity

            People

            • Assignee:
              sounak sounak chakraborty
              Reporter:
              chenliang613 Liang Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: