[jira] [Created] (CARBONDATA-3561) After deletor updat the data, the query results become incorrect

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-3561) After deletor updat the data, the query results become incorrect

Akash R Nilugal (Jira)
Xigua created CARBONDATA-3561:
---------------------------------

             Summary: After deletor updat the data, the query results become incorrect
                 Key: CARBONDATA-3561
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3561
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.5.4, 1.6.0
         Environment: SUSE12 CDH5
            Reporter: Xigua
         Attachments: image-2019-10-30-14-42-49-871.png, image-2019-10-30-14-43-21-972.png

 

When I delet or updat table data use spark SQL 2.2.3, it affects other row data,the query results become incorrect.

 
{quote}CREATE TABLE `workqueue_zyy02` (`queuecode` STRING, `channelflag` STRING, `dt` STRING)
USING org.apache.spark.sql.CarbonSource
PARTITIONED BY (dt);
 
delete from workqueue_zyy02 m where m.queuecode ='1';{quote}
*before*
 * !image-2019-10-30-14-42-49-871.png!

 *
 * *after*
 * !image-2019-10-30-14-43-21-972.png!



--
This message was sent by Atlassian Jira
(v8.3.4#803005)